| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Tamara D(dot) Blum" <tblum(at)jus(dot)gov(dot)ar> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sequence query |
| Date: | 2001-09-15 03:43:30 |
| Message-ID: | Pine.BSF.4.21.0109142042170.45865-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunnar Rønning | 2001-09-15 04:00:03 | Re: How to make a REALLY FAST db server? |
| Previous Message | Culley Harrelson | 2001-09-15 03:30:06 | Re: Fwd: Re: unicode in 7.1 |