From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Tamara D(dot) Blum'" <tblum(at)jus(dot)gov(dot)ar>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Sequence query |
Date: | 2001-09-15 11:20:27 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2E49@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
-----Original Message-----
From: Tamara D. Blum [mailto:tblum(at)jus(dot)gov(dot)ar]
Sent: 14 September 2001 16:55
To: pgsql-odbc(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-09-15 11:30:06 | Re: Installation of pgAdmin |
Previous Message | Andre Schnabel | 2001-09-15 07:28:25 | Re: dynasets |