| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | Andrei Ilitchev <andrei(dot)ilitchev(at)oracle(dot)com>, pgsql-jdbc(at)postgresql(dot)org, Marina Vatkina <Marina(dot)Vatkina(at)Sun(dot)COM> |
| Subject: | Re: Fw: postgresql experts please help |
| Date: | 2007-10-19 00:09:49 |
| Message-ID: | 4717F5CD.8070603@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Kris Jurka wrote:
> Both of these problems are
> solved by using pg_get_serial_sequence, which should perhaps be
> mentioned more prominently in the documentation.
Alternatively if you really do want a particular sequence name rather
than letting SERIAL pick one for you, you can use an explicit CREATE
SEQUENCE and DEFAULT nextval('whatever') yourself. This is essentially
what SERIAL does under the covers anyway. See
http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | João Paulo Pires | 2007-10-19 22:43:33 | PostgreSQL JDBC Driver versus Encoding |
| Previous Message | Kris Jurka | 2007-10-18 23:34:36 | Re: Fw: postgresql experts please help |