| From: | "Tamara D(dot) Blum" <tblum(at)jus(dot)gov(dot)ar> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Sequence query |
| Date: | 2001-09-14 15:54:47 |
| Message-ID: | 030501c13d35$9543e3e0$102401c8@saij.saij.jus.gov.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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".
The same query works fine in cygwin interface.
What's wrong ? Is it the query or the Driver doesn't really admit this kind of queries ?
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 | Jim Hines | 2001-09-14 18:03:19 | dynasets |
| Previous Message | Mike Renfro | 2001-09-14 14:58:31 | Re: secure ODBC connection |