[HACKERS] RC2 intermittent errors

2004-12-21 Thread Gaetano Mendola
Hi all, I'm testing now RC2 against our application and I'm experiencing intermittent errors. I isolated this test: CREATE TABLE users ( id_login SERIAL PRIMARY KEY, login TEXT ); CREATE OR REPLACE FUNCTION sp_id_user ( TEXT ) RETURNS INTEGER AS $$ DECLARE a_login ALIAS FOR

Re: [HACKERS] RC2 intermittent errors

2004-12-21 Thread Tom Lane
Gaetano Mendola [EMAIL PROTECTED] writes: I'm testing now RC2 against our application and I'm experiencing intermittent errors. I isolated this test: Argh! I put a GetTransactionSnapshot() call into exec_eval_simple_expr, but I forgot CommandCounterIncrement(). Wish I could say it was a copy-

Re: [HACKERS] RC2 intermittent errors

2004-12-21 Thread Bruce Momjian
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I'm testing now RC2 against our application and I'm experiencing intermittent errors. I isolated this test: Argh! I put a GetTransactionSnapshot() call into exec_eval_simple_expr, but I forgot CommandCounterIncrement(). Wish I

Re: [HACKERS] RC2 intermittent errors

2004-12-21 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Argh! I put a GetTransactionSnapshot() call into exec_eval_simple_expr, but I forgot CommandCounterIncrement(). Wish I could say it was a copy- and-paste mistake, but it was pure stupidity... Can we continue with RC2 or do we need an

Re: [HACKERS] RC2 intermittent errors

2004-12-21 Thread Gaetano Mendola
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Argh! I put a GetTransactionSnapshot() call into exec_eval_simple_expr, but I forgot CommandCounterIncrement(). Wish I could say it was a copy- and-paste mistake, but it was pure stupidity... Can we continue with RC2 or do