currval and nextval in 7.3.4

From: Keith Marr <marrk(at)comcast(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: currval and nextval in 7.3.4
Date: 2003-10-23 07:51:06
Message-ID: 200310230051.07009.marrk@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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' the results look like this.

my_db=# select nextval('my_seq') from my_table;
nextval
---------
6
7
8
9
(4 rows)

my_db=# select currval('my_seq') from my_table;
currval
---------
9
9
9
9
(4 rows)

I get the same results using the JDBC driver so it's not a psql problem.

Any thoughts out there?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christopher Travers 2003-10-23 14:15:53 BUG: PLPGSQL function causes PgSQL process to die when inserting into a view
Previous Message dedy setiawan 2003-10-22 04:07:47 my postgreSQL 7.4 beta for windows