Re: [BUGS] currval and nextval in 7.3.4

2003-10-24 Thread j6m
Hello, Quoting Keith Marr <[EMAIL PROTECTED]>: > Hi, > > I recently installed 7.3.4 (complete install from scratch) and both 'select > > nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table' > > return a number of rows equal to the number of rows in the table. > > The

Re: [BUGS] currval and nextval in 7.3.4

2003-10-23 Thread Stephan Szabo
On Thu, 23 Oct 2003, Keith Marr wrote: > Hi, > > I recently installed 7.3.4 (complete install from scratch) and both 'select > nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table' > return a number of rows equal to the number of rows in the table. > > The sequence was crea

[BUGS] currval and nextval in 7.3.4

2003-10-23 Thread Keith Marr
Hi, I recently installed 7.3.4 (complete install from scratch) and both 'select nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table' return a number of rows equal to the number of rows in the table. The sequence was created with a SERIAL type if that helps. In 'psql'