Re: inserting data with unique index - Mailing list pgsql-general

On Tue, Jan 14, 2003 at 04:15:58PM -0500, Johnson, Shaunn wrote:
> However, when I want to insert a new record into the
> table, I get this:
>
> [snip error]
>
> ERROR:  Cannot insert a duplicate key into unique index trend_load_id_key
>
> [/snip error]

Did you do a setval() on the sequence after you reloaded?  If not,
that may be it.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110