Search Discussions

179 discussions - 1,397 posts

  • Is there going to be an option to abort the complete transaction without knowing how deep you are? Perhaps something like "ABORT ALL". The reason I suggest this, is that I can foresee an application ...
    Thomas SwanThomas Swan
    Jul 1, 2004 at 7:01 pm
    Jul 13, 2004 at 4:15 pm
  • Taking advantage of the freeze bubble allowed us... there are some last minute features to add. Summarising earlier thoughts, with some detailed digging and design from myself in last few days - ...
    Simon RiggsSimon Riggs
    Jul 5, 2004 at 8:45 pm
    Jul 31, 2004 at 12:36 am
  • All, Out of necessity, I've implemented user quotas in 7.4.3. What would the process be for having this reviewed and combined? I have a patch for 7.4.3 ready, but wanted to know if you suggest that I ...
    Jonah H. HarrisJonah H. Harris
    Jul 8, 2004 at 9:27 pm
    Jun 22, 2005 at 6:06 pm
  • Totally agree. I think the only downside to a longer release cycle is that features developed would take longer to get out to the public. Perhaps we need to start thinking of add-ons to existing ...
    Bruce MomjianBruce Momjian
    Jul 13, 2004 at 5:13 pm
    Jul 15, 2004 at 4:07 pm
  • Hi all, Not sure how worthwhile others will find this small patch (to CVS HEAD), but we found it useful. It adds the column comments to the information_schema.columns view. Hope it's useful. :-) ...
    Justin CliftJustin Clift
    Jul 1, 2004 at 3:04 am
    Jul 5, 2004 at 7:48 am
  • Hi everyone, I've decided to attempt to nail all known bugs in pg_dump for 7.5 :) So, please send me ALL your known bugs/issues with pg_dump, pg_dumpall and pg_restore. Note that I am NOT interested ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 18, 2004 at 6:33 am
    Aug 4, 2004 at 1:49 am
  • Is it really such a good idea to have "trust" authentication enabled for localhost (TCP/IP and Unix sockets) by default? Since this pretty much means that anybody with shell access on the server ...
    Magnus HaganderMagnus Hagander
    Jul 12, 2004 at 7:41 pm
    Jul 16, 2004 at 3:27 am
  • Dear developers, classifying the questions we got those three days in the PostgreSQL booth on LinuxTag, we had three ever repeating topics, two of them non-surprising: - what's the difference to ...
    Andreas PflugAndreas Pflug
    Jul 3, 2004 at 3:59 pm
    Jul 7, 2004 at 10:52 pm
  • How come I default to Antartica in CVS? test=# show time zone; TimeZone ------------------ Antarctica/Casey (1 row) test=# Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 9, 2004 at 3:50 am
    Jul 23, 2004 at 5:08 am
  • Currently, the way that ereport/elog processing works is: 1. Collect up all the error parameter information into an ErrorData structure. (This is somewhat nontrivial in itself, at least in the ...
    Tom LaneTom Lane
    Jul 24, 2004 at 11:48 pm
    Jul 29, 2004 at 2:54 pm
  • Folks, Well, we're past feature freeze and with one reservation we know what's in the next version. After talking to several people at OSCON, I want to revive a discussion: whether this is 7.5 or ...
    Josh BerkusJosh Berkus
    Jul 31, 2004 at 8:42 pm
    Aug 1, 2004 at 11:23 pm
  • OK, I talked to Tom about this patch and I understand the issues now. I think the best solution will be to have the postmaster start a child process that can read the guc variables and create a log ...
    Bruce MomjianBruce Momjian
    Jul 15, 2004 at 4:08 am
    Jul 16, 2004 at 10:59 pm
  • I have completed the 7.5 release notes. You can view them in HTML on the developer web page. I have marked a few items with question marks that need to be addressed. I am looking for improvements, ...
    Bruce MomjianBruce Momjian
    Jul 25, 2004 at 4:25 am
    Jul 26, 2004 at 6:18 am
  • Can anyone check how well the syntax of plpgsql EXCEPTION, as described at http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING agrees with what Oracle ...
    Tom LaneTom Lane
    Jul 31, 2004 at 4:26 pm
    Aug 4, 2004 at 5:48 pm
  • If we do not add timeline numbers to WAL file names, we will be forced to destroy information during recovery. Consider the following scenario: 1. You have a WAL directory containing, say, WAL ...
    Tom LaneTom Lane
    Jul 17, 2004 at 8:36 pm
    Jul 22, 2004 at 5:09 am
  • Hi guys, Not sure if this is a known issue or not, but I think I may have found a bug with the way view definitions are shown... at least in psql. Using 7.5 development CVS (as of a few hours ago) or ...
    Justin CliftJustin Clift
    Jul 1, 2004 at 10:44 am
    Jul 6, 2004 at 8:42 am
  • gmake[3]: Entering directory `/space/1/home/chriskl/pgsql/src/pl/plperl' gcc -O2 -fno-strict-aliasing -g -fpic -DPIC -I. -I/usr/libdata/perl/5.00503/mach/CORE -I../../../src/include -c -o SPI.o SPI.c ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 2, 2004 at 2:59 am
    Jul 6, 2004 at 2:14 am
  • Here's the promised list of things I think we still need to fix to complete the nested-transactions project. I assume you have a private todo list as well --- can we compare notes? Cursors have a ...
    Tom LaneTom Lane
    Jul 3, 2004 at 3:03 pm
    Jul 10, 2004 at 1:28 am
  • Do we want to add this to TODO: * Issue an extra message when COMMIT completes a failed transaction --------------------------------------------------------------------------- elein wrote: -- Bruce ...
    Bruce MomjianBruce Momjian
    Jul 9, 2004 at 2:16 pm
    Jul 11, 2004 at 3:01 pm
  • Hi all, today I add 4 new columns to a table with 4E+06 rows, I also update to an initial value these new columns. The new columns are 3 INTEGER one of type DOUBLE. The table have also 5 indexes. ...
    Gaetano MendolaGaetano Mendola
    Jul 20, 2004 at 8:58 pm
    Jul 22, 2004 at 2:01 am
  • One failing that has appeared during the 7.5 development cycle is that we as a community haven't been able to provide timely feedback to developers working on large feature additions. I am ...
    Bruce MomjianBruce Momjian
    Jul 13, 2004 at 2:02 pm
    Jul 14, 2004 at 7:32 am
  • Hi ppl, What need to do (understand, to devel) to allow several postgres instance running from several server to access to the same data (no replication at all) hosted on a SAN ? I'm probably wrong ...
    Yannick LecaillezYannick Lecaillez
    Jul 6, 2004 at 4:27 pm
    Jul 12, 2004 at 11:29 pm
  • In service of the refactoring of error handling that I was talking about a few days ago, I'm finding that there are several places that really ought to catch longjmps and clean up after themselves, ...
    Tom LaneTom Lane
    Jul 29, 2004 at 12:19 am
    Aug 1, 2004 at 2:38 am
  • I was all set to launch into a diatribe about the half dozen performance issues I think we *must* fix in the new nested-transactions code, and thought I'd back it up by citing some pgbench numbers. ...
    Tom LaneTom Lane
    Jul 1, 2004 at 4:22 am
    Jul 7, 2004 at 7:59 am
  • There is bad breakage in the DROP TABLESPACE command if the only thing "in" that tablespace is the default tablespaces for a schema: test=# create tablespace myspace location '/home/chriskl/loc'; ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 6, 2004 at 8:52 am
    Jul 11, 2004 at 2:03 am
  • There is a known security issue with the perl Safe module versions up to and including 2.07 (and 2.08 had a life of 1 day before 2.09 was released). see ...
    Andrew DunstanAndrew Dunstan
    Jul 5, 2004 at 5:49 pm
    Jul 10, 2004 at 3:08 am
  • Related to autovacuum work, I was looking into the new vacuum delay functionality. I might be missing something, but I can't find anything on it in the developer docs. Is that right? Also, in the ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Jul 18, 2004 at 12:06 am
    Aug 7, 2004 at 5:39 pm
  • Does anyone object to extending the grammar to allow this? ALTER TABLE test ADD PRIMARY KEY (a) TABLESPACE foo; ALTER TABLE test ADD UNIQUE (a) TABLESPACE foo; CREATE TABLE test (a INTEGER PRIMARY ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 22, 2004 at 6:51 am
    Jul 23, 2004 at 10:50 pm
  • As a result of the constraint output functions being shared between pg_dump and psql, some of the output is mis-quoted in the display area for columns including quotes. Notice it's correct in the ...
    Rod TaylorRod Taylor
    Jul 8, 2004 at 4:24 pm
    Jul 12, 2004 at 6:49 am
  • Hi all, I'm doing some experiments with NT, I din't expect this behaviuor: create table test ( a integer ); insert into test values (3); insert into test values (4); insert into test values (5); ...
    Gaetano MendolaGaetano Mendola
    Jul 17, 2004 at 11:06 pm
    Jul 21, 2004 at 3:15 am
  • I've been having a problem with the pgstat.c localhost change since 7.4, in that statistics gathering stopped working on my gentoo boxes. I've not traced it back beyond getaddrinfo called in ...
    Gavin M. RoyGavin M. Roy
    Jul 19, 2004 at 11:09 pm
    Jul 20, 2004 at 4:16 pm
  • I've been thinking about what to do with cursors in subtransactions. The problem really includes both cursors (created with DECLARE CURSOR) and portals (created with the V3-protocol Bind message) ...
    Tom LaneTom Lane
    Jul 13, 2004 at 8:57 pm
    Jul 15, 2004 at 4:21 am
  • In mysql, we can wrote a create table like CREATE TABLE t (i INT) ENGINE = INNODB||BDB|; where the storage engine is the innodb one. This allow to have differents kind of storage format, and allow to ...
    Pierre Emmanuel GrosPierre Emmanuel Gros
    Jul 19, 2004 at 1:40 pm
    Jul 29, 2004 at 11:53 am
  • OK, I wrote a utility for 7.3 that takes the output of a select command in a Binary cursor and creates a binary "COPY" file. The premise of the utility is to take the results of two or more selects ...
    Mark L. WoodwardMark L. Woodward
    Jul 26, 2004 at 5:30 pm
    Jul 27, 2004 at 11:30 am
  • I notice this: When a checkpoint occurs, if a log file is more than 75% full then a new file will be allocated (in PreallocXlogFiles). This assumes we checkpoint at least 4 times per log file, ...
    Simon RiggsSimon Riggs
    Jul 21, 2004 at 8:01 pm
    Jul 24, 2004 at 8:31 pm
  • Maybe other people want to comment on this issue. So far, \z and \dp have shown privileges of tables. Now \dn+ and \db+ show the privileges of schemas and tablespaces. Should we, for consistency, ...
    Peter EisentrautPeter Eisentraut
    Jul 15, 2004 at 12:11 pm
    Jul 20, 2004 at 10:30 pm
  • I'm looking at a couple of features that are possible to add. PITR is to recover from rogue transactions. I have a suggestion that I'd like some considered thought on. I've given it a couple of weeks ...
    Simon RiggsSimon Riggs
    Jul 5, 2004 at 8:22 pm
    Jul 10, 2004 at 8:01 pm
  • There is one problem with the optimizer that is a constant source of frustration. When using prepared statements and functions (particularly where function parameters are passed to a query), the ...
    Merlin MoncureMerlin Moncure
    Jul 21, 2004 at 6:12 pm
    Aug 12, 2004 at 7:45 pm
  • I am forwarding this to hackers on behalf of some people who want to improve PostgreSQL in India. I suggest you read the developers FAQ on the developers page: http://developers.postgresql.org then ...
    Bruce MomjianBruce Momjian
    Jul 25, 2004 at 9:52 pm
    Jul 27, 2004 at 1:01 am
  • CVS web interface has not been working for a few days. Not important right now, but something to fix soon-ish. Best Regards, Simon Riggs ========================================= Error Error: ...
    Simon RiggsSimon Riggs
    Jul 25, 2004 at 9:19 pm
    Jul 26, 2004 at 8:56 pm
  • (cc: -hackers as I think this has been raised there before) It's going to be fun using anything more than very basic cursors via the V3 protocol in the JDBC driver. DECLARE does not work with ...
    Oliver JowettOliver Jowett
    Jul 20, 2004 at 10:09 pm
    Jul 25, 2004 at 6:37 am
  • Can anyone suggest why I might be seeing this effect (each notice comes out once per row plus once per function call) thanks andrew andrew=# create function tstset() returns setof tst language plperl ...
    Andrew DunstanAndrew Dunstan
    Jul 5, 2004 at 1:34 pm
    Jul 6, 2004 at 12:04 pm
  • Hi all, I'm playing with complex row type: kalman=# create table test ( a integer, b integer ); CREATE TABLE kalman=# create table test1 ( c integer , d test ); CREATE TABLE kalman=# insert into ...
    Gaetano MendolaGaetano Mendola
    Jul 26, 2004 at 12:45 am
    Aug 4, 2004 at 7:34 pm
  • Kind people, It's been pointed out to me that I tend to document by example <http://fetter.org/sgml/plperl.html , e.g. My personal opinion is that this is a good thing, and should happen throughout ...
    David FetterDavid Fetter
    Jul 18, 2004 at 7:51 pm
    Jul 19, 2004 at 1:56 am
  • this is 7.3.3 (PGDG rpm's) on red hat 7.2: i had a lot of debugging enabled. i went to create an index, and pgsql dumped on me. i tried restarting several times - no luck. starting postgresql gives ...
    Jul 16, 2004 at 5:25 am
    Jul 16, 2004 at 1:59 pm
  • Hi, I am seeing the following compile failure in currrent CVS. gmake[4]: Leaving directory `/dados/pgsql/cvs/pgsql/src/port' gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Jul 31, 2004 at 2:11 pm
    Jul 31, 2004 at 5:24 pm
  • Okay, how is this for a proposed way of fixing this. Because as I see it, the problem is that there just aren't enough signals to go around. We invent something we could call "extended signals" that ...
    Magnus HaganderMagnus Hagander
    Jul 29, 2004 at 9:24 am
    Jul 29, 2004 at 5:05 pm
  • Hi, Usually i'd ply away at this one until I figured it out, but we're running out of time :) If I have the nspForm variable (which is a Form_pg_namespace) struct pointer, then how do I check if the ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 25, 2004 at 3:33 am
    Jul 29, 2004 at 5:49 am
  • Hi, I've prepared a patch(against CVS HEAD of today) to pg_dump.c to make pg_dump understand multiple -t options for dumping multiple tables in one command. Eks: pg_dump -t table1 -t table2 -t table3 ...
    Andreas Joseph KroghAndreas Joseph Krogh
    Jul 9, 2004 at 12:03 pm
    Jul 23, 2004 at 6:45 pm
  • I know it's not critical, but is it worth rewriting pg_config in C so it works on Windows (or alternatively writing it as a .bat file for Windows)? cheers andrew
    Andrew DunstanAndrew Dunstan
    Jul 20, 2004 at 2:01 am
    Jul 20, 2004 at 4:25 pm
Group Navigation
period‹ prev | Jul 2004 | next ›
Group Overview
grouppgsql-hackers @

134 users for July 2004

Tom Lane: 211 posts Bruce Momjian: 166 posts Christopher Kings-Lynne: 94 posts Simon Riggs: 86 posts Alvaro Herrera Munoz: 82 posts Oliver Jowett: 44 posts Andreas Pflug: 42 posts Peter Eisentraut: 41 posts Marc G. Fournier: 39 posts Andrew Dunstan: 36 posts Gaetano Mendola: 34 posts Dennis Bjorklund: 27 posts Jeroen T. Vermeulen: 24 posts Andreas Zeugswetter: 23 posts Magnus Hagander: 23 posts Rod Taylor: 23 posts Josh Berkus: 22 posts Justin Clift: 19 posts Mark Kirkwood: 16 posts Gavin Sherry: 14 posts
show more