| 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: | Whole Thread | Raw Message | 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?
| 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 |