| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Ben Kassel <kasselb(at)nswccd(dot)navy(dot)mil> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Problem with Auto Increment |
| Date: | 2002-11-04 20:45:28 |
| Message-ID: | 20021104124318.I11215-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, 4 Nov 2002, Ben Kassel wrote:
> When I try to create a new row in this table and do not explicitly
> define a unique value for datadefindex I get the following error
> message:
> More information : If I DROP the database, recreate it, and enter
> values into the table manually, the autoincrement works on this table.
> It seems that the problem arises after I reload the data into the table
> using the \i command on a file which was created using the pg_dump
> command.
Was that a data only dump that you were reloading? I'd guess that a data
only dump is assuming that you have/will set the sequence's next value
correctly yourself. You might just try finding the max value and using
setval on the sequence to get the sequence in the right place.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Bakker | 2002-11-04 21:00:48 | Re: [SQL] Database Design tool |
| Previous Message | Ben Kassel | 2002-11-04 18:29:47 | Problem with Auto Increment |