| From: | "Brian Johnson" <bjohnson(at)jecinc(dot)on(dot)ca> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | List sequence assigned to primary key |
| Date: | 2002-11-05 05:45:09 |
| Message-ID: | 20021105.WhT.79991700@192.168.0.1 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I added a few records to a table and assigned numbers to the id field - now when I
try to add records properly, it says that it can't accept duplicate values on the
primary field (id)
Although there were only a few records and I could just redo them, I wonder if
there is another method (for future reference)
So here are my two questions
1. How can you list (find out) the sequence name assigned to a primary key?
2. How can you change that sequence value?
I searched a bunch of web sites but had trouble narrowing my search to less than
about 30,000 hits
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ciprian Popovici | 2002-11-05 09:34:52 | OT: displaying sender's email on archives.postgresql.org |
| Previous Message | Kassel Ben CRBE | 2002-11-05 02:10:57 | Re: AutoIncrement not working on this table only |