Re: [BUGS] BUG #5419: Default parameters in PLPGSQL functions skipping every other value in pgAdmin view

2010-04-13 Thread Pavel Stehule
2010/4/14 Cris Pond : > > The following bug has been logged online: > > Bug reference:      5419 > Logged by:          Cris Pond > Email address:      cpondw...@yahoo.com > PostgreSQL version: 8.4.2 > Operating system:   Ubuntu 9.10 kernel linux 2.6.31-20-generic > Description:        Default param

Re: [BUGS] BUG #5412: test case produced, possible race condition.

2010-04-13 Thread Rusty Conover
Hi Heikki and everybody else, It seems like this is a race condition cause by the system catalog cache not being locked properly. I've included a perl script below that causes the crash on my box consistently. The script forks two different types of processes: #1 - begin transaction, create a

Re: [BUGS] BUG #5419: Default parameters in PLPGSQL functions skipping every other value in pgAdmin view

2010-04-13 Thread Tom Lane
"Cris Pond" writes: > ... When I go to the pgAdmin interface to view the function, it skips the > default value for every other parameter! Sounds like a pgAdmin bug ... but you didn't say which pgAdmin version you're using. regards, tom lane -- Sent via pgsql-bugs maili

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Craig Ringer
On 13/04/10 21:16, Ben Madin wrote: G'day Craig, thanks for your reply. Please disregard my follow-up. I hadn't seen Tom's reply that he was able to reproduce the issue. There's no need for you to collect a backtrace now :-) -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@p

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Craig Ringer
On 13/04/10 21:16, Ben Madin wrote: I have checked console, and there are many psql entries - I have attached two as they all appear fairly similar, some numbers changing in this section : Thread 0 crashed with X86 Thread State (64-bit): rax: 0x rbx: 0x0002 rcx

[BUGS] BUG #5419: Default parameters in PLPGSQL functions skipping every other value in pgAdmin view

2010-04-13 Thread Cris Pond
The following bug has been logged online: Bug reference: 5419 Logged by: Cris Pond Email address: cpondw...@yahoo.com PostgreSQL version: 8.4.2 Operating system: Ubuntu 9.10 kernel linux 2.6.31-20-generic Description:Default parameters in PLPGSQL functions skipping ev

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Tom Lane
Craig Ringer writes: >> prices=# \d abapsql(11407) malloc: *** error for object 0xe: pointer being >> freed was not allocated >> *** set a breakpoint in malloc_error_break to debug >> Abort trap > This could be a bug in psql, a buggy/damaged readline library, etc. > ... > I don't have access to M

Re: [BUGS] BUG #5412: Crash in production SIGSEGV, equalTupleDescs (tupdesc1=0x7f7f7f7f, tupdesc2=0x966508c4) at tupdesc.c

2010-04-13 Thread Rusty Conover
On Apr 9, 2010, at 2:23 PM, Heikki Linnakangas wrote: > Rusty Conover wrote: >> The bug is reproducible, I'm not sure how to proceed. > > How do you reproduce it? Can you make a self-contained test case? > I can reproduce it by running my code, I haven't found a good test case yet because

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Alvaro Herrera
Ben Madin wrote: > Bug reference: 5418 > Logged by: Ben Madin > Email address: b...@ausvet.com.au > PostgreSQL version: 8.4.3 > Operating system: Mac OS X 10.6.3 > Description:psql exits after using tab-completion with error message Lots of problems have been reported

Re: [BUGS] BUG #5416: int4inc() is wrong

2010-04-13 Thread Tom Lane
"John Regehr" writes: > The overflow check in int4inc() from int.c is wrong. Hm, works for me: regression=# \set VERBOSITY verbose regression=# select int4inc(2147483647); ERROR: 22003: integer out of range LOCATION: int4inc, int.c:768 > The problem is that in > C, signed overflow is undefine

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Ben Madin
G'day Craig, thanks for your reply. On 13/04/2010, at 20:33 , Craig Ringer wrote: > >> prices=# \d abapsql(11407) malloc: *** error for object 0xe: pointer being >> freed was not allocated >> *** set a breakpoint in malloc_error_break to debug >> Abort trap > > This could be a bug in psql, a bu

Re: [BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Craig Ringer
prices=# \d abapsql(11407) malloc: *** error for object 0xe: pointer being freed was not allocated *** set a breakpoint in malloc_error_break to debug Abort trap This could be a bug in psql, a buggy/damaged readline library, etc. For GUI apps Mac OS X makes a crash record in the system logs.

[BUGS] BUG #5418: psql exits after using tab-completion with error message

2010-04-13 Thread Ben Madin
The following bug has been logged online: Bug reference: 5418 Logged by: Ben Madin Email address: b...@ausvet.com.au PostgreSQL version: 8.4.3 Operating system: Mac OS X 10.6.3 Description:psql exits after using tab-completion with error message Details: G'day, th

[BUGS] BUG #5416: int4inc() is wrong

2010-04-13 Thread John Regehr
The following bug has been logged online: Bug reference: 5416 Logged by: John Regehr Email address: reg...@cs.utah.edu PostgreSQL version: git head Apr 12 Operating system: n/a Description:int4inc() is wrong Details: The overflow check in int4inc() from int.c is wro

Re: [BUGS] Possible alpha5 SR bug

2010-04-13 Thread Magnus Hagander
On Tue, Apr 13, 2010 at 08:22, Fujii Masao wrote: > Thanks for the test and report! > > On Tue, Apr 13, 2010 at 1:36 PM, Jeff Davis wrote: >> FATAL:  could not load library >> "/usr/local/pgsql-9.0alpha5-build1/lib/libpqwalreceiver.so": >> dlopen(/usr/local/pgsql-9.0alpha5-build1/lib/libpqwalre

Re: [BUGS] BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3

2010-04-13 Thread Craig Ringer
On 13/04/10 09:03, y.y.chen wrote: The following bug has been logged online: Bug reference: 5414 Logged by: y.y.chen Email address: yyc...@clhs.tyc.edu.tw PostgreSQL version: 8.4.3 Operating system: XP and openSuSE 11.1 Description:pg_dump failure from database

[BUGS] BUG #5417: intarray adds <@ operator which breaks infromation_schema.referential_constraints

2010-04-13 Thread Kenaniah Cerny
The following bug has been logged online: Bug reference: 5417 Logged by: Kenaniah Cerny Email address: kenan...@gmail.com PostgreSQL version: 8.4.2 - 9.0 Operating system: linux Description:intarray adds <@ operator which breaks infromation_schema.referential_constrai