| From: | "Tamara D(dot) Blum" <tblum(at)jus(dot)gov(dot)ar> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Sequence query |
| Date: | 2001-09-14 16:19:42 |
| Message-ID: | 031301c13d39$0fc6c6c0$102401c8@saij.saij.jus.gov.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi !
I need to ask for the following secuence number for a field.
I am connecting PostgreSQL with an ODBC Driver and with ADO.
If i ask for the value of the field after updating the recordset, i get it is null (and it can't be), so i read how to ask for information about sequences and i founded that "SELECT * FROM objetos_ID_seq" would be ok, but i got an error: "The Relation 'objetos_Id_seq' does not exist".
What's wrong ? Is there any problem with my sequence ?
Thanks
Tamara D. Blum
Analista de Sistemas
Tel.: 4831-9061 al 66 int. 110
Sistema Argentino de Informatica Juridica
Ministerio de Justicia y Derechos Humanos
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lalo Castro | 2001-09-14 16:24:09 | pgdumpall |
| Previous Message | Matthew Rice | 2001-09-14 16:06:20 | Re: Where do they find the time??? Great Bridge closed now!!!?? |