Re: inserting data with unique index

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: inserting data with unique index
Date: 2003-01-15 00:03:56
Message-ID: 20030114190356.B17481@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2003-01-15 00:28:17 Re: postgres on a PDA
Previous Message Al Bean 2003-01-14 23:58:39 postgres on a PDA