On Fri, 14 Sep 2001, Tamara D. Blum wrote:
> 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 ?
Have you tried double quoting the sequence name? My first guess is
that it's a mixed case problem.