[BUGS] Getting "FATAL: unexpected data beyond EOF in block 1 of relation 1663/1/1255/0" on Mac OS during initdb

2008-11-07 Thread Julius Stroffek
Hi All, I getting the following error output (see below) on mac os while running initdb on the latest CVS. The 8.3.5-1 one-click installer binary works fine. Is this a bug or I have something wrong in my kernel setup? Thank you. Cheers Julo /etc/sysctl.conf: kern.sysv.shmmax=33554432 ke

Re: [BUGS] BUG #3729: Query doesn't return the right answer

2007-11-08 Thread Julius Stroffek
Andrius, see the explanation about that at http://www.postgresql.org/docs/8.3/static/functions-comparison.html for more details. Cheers Julo Heikki Linnakangas wrote: Andrius Glozeckas wrote: I have a parent_type_id linking to group_type_id on the same table (group_type). I am trying to

Re: [BUGS] 'on insert do instead' rule with a where clause responds 'INSERT 0 0'

2007-10-18 Thread Julius Stroffek
Hi, please see my comments inline. Tom Lane wrote: Julius Stroffek <[EMAIL PROTECTED]> writes: Attached is the example script 'repro.sql' which creates two relations tab1 and tab2. It also creates a rule on tab1 which simply does insert into tab2. The insert statem

[BUGS] 'on insert do instead' rule with a where clause responds 'INSERT 0 0'

2007-09-07 Thread Julius Stroffek
Hi, Attached is the example script 'repro.sql' which creates two relations tab1 and tab2. It also creates a rule on tab1 which simply does insert into tab2. The insert statement into tab1 is executed afterwards. It responds with 'INSERT 0 1'. However if I would create the same rule with the w

[BUGS] pgbench - segmentation fault

2007-08-22 Thread Julius Stroffek
Hi, pgbench contrib module is doing segmentation fault on Solaris when -d option is specified without -p option specified. This is because the -d option dumps the connection information and the default value of pgport variable is NULL which causes segmentation fault on Solaris when NULL is passe