Re: Learning Plpgsql ??

Hi Jonathan

I've been using Postgres for a bit but I'm not really an expert.

You have probably seen that the "SERIAL" type expands to
'not null default nextval('"auto_generated_index_name"'::text)

If you have imported a large set of records with explicit ids you could
simply use the 'setval(index_name,number)' function to reset the sequence's
current value.

Cheers
Rory

On 23/01/03, Jonathon Batson (jonathon(at)octahedron(dot)com(dot)au) wrote:
> I am porting dbs from Access97 to postgres, tables and data comes across
> fine but the autonumber(sequences) do not
> get updated, so I need to do this manually using > SELECT
> setval(sequence_name,value);
--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>