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
The definition in question is:
messageid | integer | not null default
Ideas? Many thanks!
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-07-29 22:01:07|
|Subject: Re: catching up an id sequence |
|Previous:||From: Betsy Barker||Date: 2004-07-29 18:32:31|
|Subject: Re: Calling a function that returns a composite type using|