Postgres Pro
Downloads
Home   >   mailing lists

Re: Serial/sequence problem - Mailing list pgsql-general

From Michael Hall
Subject Re: Serial/sequence problem
Date
Msg-id 20081125080949.GA6426@server1.jarvisstreet.com
Whole thread Raw
In response to Re: Serial/sequence problem  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Serial/sequence problem  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
Tree view 
> The 3636 INSERT-Statements contains a fix value for the ID-Column,
> right? Thats wrong, omit the id-column and value or use simply 'default' for it.

That's right. I thought that might be the case.

> > - how can I rectify the situation?

> Set the sequence to the new value, 3636+9, via
> setval('your_sequence', 3636+9)

I'll re-import the data with DEFAULT in the id (SERIAL) column, hopefully new inserts will be OK then and I can leave
thesequence alone? 

Thanks

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Place of subselect
Next
From: "Guillaume Bog"
Date:
Subject: Re: Place of subselect