Re: [BUGS] BUG #3243: foreign key constraint not working?

2007-04-19 Thread Tom Lane
"" <[EMAIL PROTECTED]> writes: > I am experiencing a very interesting, actually very frightening thing: I > have a foreign key constraint along with rows violating it. You have not provided enough information to let anyone reproduce or debug the problem... FWIW, we recently found a problem in VAC

Re: [BUGS] BUG #3240: Unexpected evaluation sequence

2007-04-19 Thread Tom Lane
"Kevin Macdonald" <[EMAIL PROTECTED]> writes: > Now, take these two operations: > SQL> select currval ('seq') > returns 11 > SQL> select nextval ('seq'), currval ('seq') > returns (12, 12) > I would have expected it to have returned (12, 11). No, because currval reports the latest nextval res

Re: [BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-19 Thread Tom Lane
"Michel Dorochevsky" <[EMAIL PROTECTED]> writes: > We are encountering the following problem: > 2007-04-19 16:22:19 PANIC: failed to re-find shared lock object > 2007-04-19 16:22:19 STATEMENT: COMMIT PREPARED Wow, that's interesting. > My question is: how could we proceed to get help? > Does an

[BUGS] BUG #3245: PANIC: failed to re-find shared lock object

2007-04-19 Thread Michel Dorochevsky
The following bug has been logged online: Bug reference: 3245 Logged by: Michel Dorochevsky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows 2000 / XP / 2003 Description:PANIC: failed to re-find shared lock object Details: We are

[BUGS] BUG #3244: problem with PREPARE

2007-04-19 Thread William Lawrance
The following bug has been logged online: Bug reference: 3244 Logged by: William Lawrance Email address: [EMAIL PROTECTED] PostgreSQL version: cvs HEAD Operating system: Linux Description:problem with PREPARE Details: This program that does "PQprepare" and then "P

[BUGS] BUG #3240: Unexpected evaluation sequence

2007-04-19 Thread Kevin Macdonald
The following bug has been logged online: Bug reference: 3240 Logged by: Kevin Macdonald Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: Windows XP Description:Unexpected evaluation sequence Details: Take these two operations: SQL> sele

[BUGS] BUG #3243: foreign key constraint not working?

2007-04-19 Thread
The following bug has been logged online: Bug reference: 3243 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux: Ubuntu 6.06 (Dapper Drake) Description:foreign key constraint not working? Details: I am experiencing a very

Re: [BUGS] BUG #3242: FATAL: could not unlock semaphore: error code 298

2007-04-19 Thread Marcin Waldowski
We've made some tests on Linux and it seems like it never happen on this platform, but we use 8.1, not 8.2. select version() PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.4.5 (Gentoo 3.4.5, ssp-3.4.5-1.0, pie-8.7.9) Regards, Marcin Marcin Waldowski wrot

[BUGS] BUG #3242: FATAL: could not unlock semaphore: error code 298

2007-04-19 Thread Marcin Waldowski
The following bug has been logged online: Bug reference: 3242 Logged by: Marcin Waldowski Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 and 8.2.1 Operating system: Windows XP SP2 Description:FATAL: could not unlock semaphore: error code 298 Details: Hel

Re: [BUGS] BUG #3232: Regression: pgsql server startup problem with encrypted partitions

2007-04-19 Thread Magnus Hagander
On Thu, Apr 19, 2007 at 10:54:30AM +1000, Carsten Friedrich wrote: > Hi Magnus, > > thanks for the reply. > > I don't think the fact that this worked in the past was pure luck. I did > this for more than a year (almost 2 years) 5 days a week and never had a > problem. It seems very unlikely to