PgSql

[HACKERS] Auto-extending table partitions?
http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html Is there a way to automatically extend table partitions? I'm curious if / when a table is getting full if there is a way for postgres to create additional tables. Or is it all manual? Thanks :D -- Sent via pgsql-hackers mailing list (... 6 Jan 2010 09:10

xpath improvement suggestion
Arie Bikker wrote: Hi all, Well I had to burn some midnight oil trying to figure out why a construct like SELECT xpath('name()','<a/>'); doesn't give the expected result. Kept getting an empty array: xpath ------------- {} instead of the expected "{a}" BugID 4294 and the TODO item ... 2 Feb 2010 16:07

[HACKERS] xpath improvement suggestion
Hi all, Well I had to burn some midnight oil trying to figure out why a construct like SELECT xpath('name()','<a/>'); doesn't give the expected result. Kept getting an empty array: xpath ------------- {} instead of the expected "{a}" BugID 4294 and the TODO item "better handling of XPath data types" p... 6 Jan 2010 09:10

We no longer have a fallback for machines without working int64
David Fetter <david(a)fetter.org> writes: On Tue, Jan 05, 2010 at 10:47:33AM -0500, Tom Lane wrote: As pointed out here http://archives.postgresql.org/pgsql-general/2010-01/msg00145.php the current zic code doesn't cope gracefully with lack of working int64. Considering the trouble we've gone to throu... 6 Jan 2010 09:10

pgsql: Get rid of the need for manualmaintenance of the initial
Tom Lane wrote: Stefan Kaltenbrunner <stefan(a)kaltenbrunner.cc> writes: did that and it seems the problem is in the loop that does: foreach my $row (@$data) { # To construct fmgroids.h and fmgrtab.c, we need to inspect some # of the individual data fields. Just splitting on whit... 6 Jan 2010 09:10

Writeable CTEs
On Tue, Jan 5, 2010 at 4:42 PM, Marko Tiikkaja <marko.tiikkaja(a)cs.helsinki.fi> wrote: => with t as (delete from foo returning *) -> insert into bar -> select * from t; INSERT 0 2 It correctly reports 2 affected rows (one deleted and one inserted), but is this the answer we want?  It doesn't seem a... 6 Jan 2010 09:10

We no longer have a fallback for machines withoutworking int64
Tom Lane wrote: As pointed out here http://archives.postgresql.org/pgsql-general/2010-01/msg00145.php the current zic code doesn't cope gracefully with lack of working int64. Considering the trouble we've gone to throughout the rest of the system to support such compilers, it's a bit annoying to have... 6 Jan 2010 09:10

[HACKERS] We no longer have a fallback for machines without working int64
As pointed out here http://archives.postgresql.org/pgsql-general/2010-01/msg00145.php the current zic code doesn't cope gracefully with lack of working int64. Considering the trouble we've gone to throughout the rest of the system to support such compilers, it's a bit annoying to have this little detail break it.... 6 Jan 2010 09:10

Does parallel make require guards against duplicateactions?
On mån, 2010-01-04 at 21:58 -0500, Tom Lane wrote: The old Gen_fmgrtab.sh script used temporary file names that included its process PID. It had this comment about that: # We use the temporary files to avoid problems with concurrent runs # (which can happen during parallel make). The new impleme... 6 Jan 2010 09:10

execute sql commands in core
On Tue, Jan 5, 2010 at 12:56 AM, black light <blacklight1600(a)gmail.com> wrote: Hi, I want to add some hard-wired extra authentication codes in my PG. The only problem is how to access tables to get/change information from core (auth.c)? I have changed the SPI functions to use them but it was not effectiv... 6 Jan 2010 09:10