Postgres Pro
Downloads
Home   >   mailing lists

Thread: Sequence query

Sequence query

From
"Tamara D. Blum"
Date:
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 Informática Jurídica
	Ministerio de Justicia y Derechos Humanos

Re: Sequence query

From
Dave Page
Date:
 
-----Original Message-----
From: Tamara D. Blum [mailto:tblum@jus.gov.ar]
Sent: 14 September 2001 16:55
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Sequence query

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".
Try:
 
SELECT * FROM "objetos_ID_seq"
 
Without the quotes, the name will be treated as lowercase.
The same query works fine in cygwin interface. 
I must admit, that surprises me. 
What's wrong ? Is it the query or the Driver doesn't really admit this kind of queries ? 
Unquoted object names are always shifted to lowercase by the backend (not the ODBC driver).
 
HTH, regards, Dave.