Hi most esteemed novices and experts. It is an honor to post here!

I imported a MySQL dump into PostgreSQL (7.4.3) and was wondering what
a good way to catch up the ID sequence table to be current with the
table I imported.

In the Perl app associated with the DB, I swapped out currval for
mysql_insertid. Then I noticed that the currval reported is started
from 0, but there are already 1400+ records in that table that have id
numbers.

The definition in question is:

messageid | integer | not null default
nextval('public.message_messageid_seq'::text)

Ideas? Many thanks!

Austin


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Austin Swinney <austin (AT) interactivate (DOT) com> writes:
You want setval(). The usual approach is

select setval('tab_col_seq', (select max(col) from tab) + 1);

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)