Re: [GENERAL] currval() in insert statements

2009-02-14 Thread Onno Molenkamp
Hi, I know that, and nextval -is- being called because it's the default value of column "a". The problem is that apparently the order in which it's called has changed for the form with a select, not that I don't know the difference between currval and nextval. Onno Op Saturday 14 February 200

[GENERAL] currval() in insert statements

2009-02-14 Thread Onno Molenkamp
Hi, I recently upgraded a database from 8.1.11 to 8.3.6, and I noticed the following statement stopped working: insert into test (b) select currval('test_a_seq'::regclass) given the following table: create table test (a serial, b int) The error I'm getting is: "ERROR: currval of sequence