Postgres Pro
Downloads
Home   >   mailing lists

Sequence query - Mailing list pgsql-odbc

From Tamara D. Blum
Subject Sequence query
Date
Msg-id 030501c13d35$9543e3e0$102401c8@saij.saij.jus.gov.ar
Whole thread Raw
List pgsql-odbc
Tree view
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

pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: [ODBC] pgAdmin II /odbc connect errors
Next
From: "allan d. go"
Date:
Subject: postgresql ODBC