Re: [BUGS] BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly

2009-12-09 Thread Tom Lane
Robert Haas writes: > I'm not an expert on this area of the code, but can we just ignore > isNatural and usingClause when deparsing? No. These properties are *not* ignorable because doing so changes the set of returned columns --- you should get only one column out not two. My reading of the sp

Re: [BUGS] BUG #5234: ALTER TABLE ... RENAME COLUMN change view definition incorrectly

2009-12-09 Thread Robert Haas
On Sun, Dec 6, 2009 at 5:41 PM, Sergey Burladyan wrote: > > The following bug has been logged online: > > Bug reference:      5234 > Logged by:          Sergey Burladyan > Email address:      eshkin...@gmail.com > PostgreSQL version: 8.3.8 > Operating system:   Debian GNU/Linux 5.0.3 (lenny) + tes

[BUGS] BUG #5237: strange int->bit and bit->int conversions

2009-12-09 Thread Roman Kononov
The following bug has been logged online: Bug reference: 5237 Logged by: Roman Kononov Email address: kono...@ftml.net PostgreSQL version: 8.4.1 Operating system: GNU/Linux x86_64 Description:strange int->bit and bit->int conversions Details: test=# select (11::int4

[BUGS] getting libpqd.lib and libpqd.dll for postgesql 8.4.1 on Vista with VS8 or cygwin g++

2009-12-09 Thread Mike Landis
I am trying to experiment with the libpqxx API and postgresql 8.4.1 on a 32-bit Vista machine.  Libpqxx wants release and debug libraries for libpq available.  libpq.dll ships with the binary release of PG and libpq.lib ships with the source tree, but debug versions have to be built from source. 

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Tom Lane
Andrew Gierth writes: > Still, even though the code is preposterous, the result shouldn't be a > segfault. I wasn't able to reproduce one myself (using 8.3.7 on > freebsd 7.2) however. Yeah, for me it also recurses till the exception is hit, and then processes that successfully. This is effectiv

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Andrew Gierth
> "Andrew" == Andrew Gierth writes: Andrew> What are the definitions of your instr() and ad_parent_tree() Andrew> functions? Well, there's so much wrong with that ad_parent_tree function - it's always going to recurse infinitely (with a new subxact per recursion level, even) regardless of

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Tom Lane
Stefan Kaltenbrunner writes: > I vaguely recall issues in the past with linking of postgresql (or PLs > that require it) against libc_r causing some rather small stack limits > being imposed under some circumstances but I don't recall the details > any more... Yeah, we've seen cases where libc

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Stefan Kaltenbrunner
Andrew Gierth wrote: "Robert" == Robert Haas writes: Robert> How about (3) getrlimit(RLIMIT_STACK) lies through its teeth, Robert> by ignoring the existence of another and lower limit imposed Robert> elsewhere? Robert> A little Googling seems to reveal that FreeBSD has a Robert> paramete

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Oleg Jurtšenko
Functions are attached Oleg Andrew Gierth wrote: "Oleg" == Oleg Jurtšenko writes: Oleg> I tried to execute "select instr(ad_parent_tree(?,?),'|'||'?'||'|') AS Oleg> isItsOwnChild from dual;" query with psql terminal and got Oleg> segmentation fault as well. Oleg> The most i

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Andrew Gierth
> "Oleg" == Oleg Jurtšenko writes: Oleg> I tried to execute "select instr(ad_parent_tree(?,?),'|'||'?'||'|') AS Oleg> isItsOwnChild from dual;" query with psql terminal and got Oleg> segmentation fault as well. Oleg> The most interesting thing is that this function makes segmentation Ol

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Andrew Gierth
> "Robert" == Robert Haas writes: Robert> How about (3) getrlimit(RLIMIT_STACK) lies through its teeth, Robert> by ignoring the existence of another and lower limit imposed Robert> elsewhere? Robert> A little Googling seems to reveal that FreeBSD has a Robert> parameter called MAXSSIZ (

Re: [BUGS] BUG #5235: Segmentation fault under high load through JDBC

2009-12-09 Thread Robert Haas
On Tue, Dec 8, 2009 at 11:08 PM, Tom Lane wrote: > Robert Haas writes: >> 2009/12/8 Oleg Jurtšenko : >>> You are right, it crushes on following statement: "select >>> instr(ad_parent_tree(?,?),'|'||?||'|') AS isItsOwnChild from dual;" >>> >>> max_stack_depth is commented out, I think it has the d