Re: Problem with unique key - Mailing list pgsql-general

From Greg Peters
Subject Re: Problem with unique key
Date
Msg-id 9bc001470611280135m22574434w950acb6118bd90fe@mail.gmail.com
Whole thread Raw
In response to Re: Problem with unique key  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thanks all,
 
with your help I figured out what happened. You are all correct in that the sequence is out of sync with the "key" value. I dumped the db and then selectively restored it from the sql file some time ago by cutting and pasting directly to the command prompt. I must have left out the commands that tell it what the current value of the sequence is. Problen solved.
 
Many thanks,
Greg.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Problem with unique key
Next
From: Alban Hertroys
Date:
Subject: Re: sequence help