Re: [HACKERS] VACUUM FULL deadlock with backend startup

2011-03-20 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Sat, Mar 19, 2011 at 10:46 AM, Nikhil Sontakke nikhil.sonta...@enterprisedb.com wrote: Not really a performance issue AFAICS. If the relcache init file exists, then the phase2 of the catalog cache which eventually calls the above code path is

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-20 Thread Martijn van Oosterhout
On Sun, Mar 20, 2011 at 11:50:01AM +0800, hom wrote: I trace into scan.c because I want to known how the paser tree is built and I debug the source step by step. Then the eclipse pick up the scan.I and the excute order does not match the code. Umm, the scanners produced by flex and bison are

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-20 Thread Nicolas Barbier
2011/3/20 hom obsidian...@gmail.com: I trace into scan.c because I want to known how the paser tree is built and I debug the source step by step. I suggest you learn how flex/bison work first. The contents of the *.c files generated by flex/bison are not generally supposed to be interpreted by

Re: [HACKERS] VACUUM FULL deadlock with backend startup

2011-03-20 Thread Robert Haas
On Mar 20, 2011, at 2:24 AM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Sat, Mar 19, 2011 at 10:46 AM, Nikhil Sontakke nikhil.sonta...@enterprisedb.com wrote: Not really a performance issue AFAICS. If the relcache init file exists, then the phase2 of the

Re: Sync Rep and shutdown Re: [HACKERS] Sync Rep v19

2011-03-20 Thread Yeb Havinga
On 2011-03-20 05:44, Robert Haas wrote: Hmm, I'm not going to be able to reproduce this here, and my test setup didn't show a clear regression. I can try beating on it some more, but... Any chance you could rerun your test with the latest master-branch code, and perhaps also with the patch I

Re: [HACKERS] foreign keys for array/period contains relationships

2011-03-20 Thread Rod Taylor
On Mon, Oct 25, 2010 at 15:11, Peter Eisentraut pete...@gmx.net wrote: Example #4: PK is period, FK is timestamp. FK must be contained in some PK period. CREATE TABLE pk (a period PRIMARY KEY, ...); CREATE TABLE fk (x timestamp REFERENCES pk (a), ...); As above, we can probably arrange

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-20 Thread hom
2011/3/20 Martijn van Oosterhout klep...@svana.org: On Sun, Mar 20, 2011 at 11:50:01AM +0800, hom wrote: I trace into scan.c because I want to known how the paser tree is built and I debug the source step by step. Then the eclipse pick up the scan.I and the excute order does not match the

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-20 Thread hom
2011/3/20 Nicolas Barbier nicolas.barb...@gmail.com: 2011/3/20 hom obsidian...@gmail.com: I trace into scan.c because I want to known how the paser tree is built and I debug the source step by step. I suggest you learn how flex/bison work first. The contents of the *.c files generated by

Re: [HACKERS] Collations versus record-returning functions

2011-03-20 Thread Martijn van Oosterhout
On Fri, Mar 18, 2011 at 10:40:53PM -0400, Tom Lane wrote: (2) Allow collations to propagate up through nodes that deliver noncollatable outputs. I don't think this is the goal. Only strings types are collatable, as you point out. * Something like row('a' collate C, 'b' collate en_US)

Re: [HACKERS] WIP patch: collation assignment algorithm rewrite

2011-03-20 Thread Martijn van Oosterhout
On Sat, Mar 19, 2011 at 05:22:39PM -0400, Tom Lane wrote: Attached is a WIP patch to split the expression-tree representation of collations into separate fields for input and output collation, and to replace the parser's current method of assigning collations with a recursive post-pass. I

Re: [HACKERS] foreign keys for array/period contains relationships

2011-03-20 Thread Andrew Tipton
On Mon, Oct 25, 2010 at 15:11, Peter Eisentraut pete...@gmx.net wrote: Example #4: PK is period, FK is timestamp. FK must be contained in some PK period. CREATE TABLE pk (a period PRIMARY KEY, ...); CREATE TABLE fk (x timestamp REFERENCES pk (a), ...); As above, we can probably arrange

Re: [HACKERS] maximum digits for NUMERIC

2011-03-20 Thread Noah Misch
On Fri, Mar 11, 2011 at 11:36:14AM +, Gianni Ciolli wrote: maybe we should change the 1000 digits here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM that up to 2^17 digits are supported (which makes more sense than

Re: Sync Rep and shutdown Re: [HACKERS] Sync Rep v19

2011-03-20 Thread Robert Haas
On Sun, Mar 20, 2011 at 11:03 AM, Yeb Havinga yebhavi...@gmail.com wrote: On 2011-03-20 05:44, Robert Haas wrote: Hmm, I'm not going to be able to reproduce this here, and my test setup didn't show a clear regression.  I can try beating on it some more, but...  Any chance you could rerun your

Re: [HACKERS] pl/python tracebacks v2

2011-03-20 Thread Peter Geoghegan
On 20 March 2011 23:40, Jan Urbański wulc...@wulczer.org wrote: I'll update the commitfest app for the 2011-Next commitfest, but if someone would like to pick this up and include it in the 9.1 PL/Python revamp pack, I'd be thrilled. I would also be thrilled. I definitely share your sense of

Re: [HACKERS] WIP patch: collation assignment algorithm rewrite

2011-03-20 Thread Tom Lane
Martijn van Oosterhout klep...@svana.org writes: I've looked over the main code and it looks good. While I'm not totally conviced it has to be done as a seperate pass, this way is exceedingly readable and clear as to what is going on, which makes me much more confident of its correctness.

Re: [HACKERS] Rectifying wrong Date outputs

2011-03-20 Thread Piyush Newe
On Thu, Mar 17, 2011 at 7:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Thu, Mar 17, 2011 at 9:46 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Keep in mind that the datetime stuff was abandoned by the maintainer some years ago with quite