[HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread jeroen van iddekinge
Hi all, When using intarray operator in a query, postgres dies and restart itself when executing the following query: select r1.bet_sentence r2.bet_sentence from related r1,related r2 where r1.bet_sentence r2.bet_sentence the log file contains the following: LOG: server process (PID

[HACKERS] creating the same table in 2 different sessions

2005-02-13 Thread Jeroen van Iddekinge
Hi, Maybe I found the following bug or 'not ideal behaviour' of postgres(version 7.4.7 and 8.0 /linux): first start asession 1 begin; create table a0(a bigint); than login for a second session begin create table a0(a bigint) postgres block nows in session 2 when session 1 is commited the

[HACKERS] strerror_r int and char* return type mixup on FC2

2005-02-13 Thread Jeroen van Iddekinge
Hi, I noticed that there where strange symbols in the error message when I can't connect to a database. This happends in PHP and pgsql and in the 7.4.x and 8.0 version of postgesql in pqStrError there is a 'if def' for 'char*' and 'int' return type strerror_r. I'm have FC2 linux. This

Re: [HACKERS] strerror_r int and char* return type mixup on FC2

2005-02-13 Thread Jeroen van Iddekinge
Thanks for the reply, I have 7.4.7 and 8.0.0 both installed , so I din't noticed that i was using 7.4.7 client. 8.0.0 works fine Thanks Jeroen Jeroen van Iddekinge wrote: Hi, I noticed that there where strange symbols in the error message when I can't connect to a database. This happends