From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Johann Zuschlag <zuschlag(at)online(dot)de> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Why does this not work? (keyword 'TEXT') |
Date: | 2002-04-10 14:06:34 |
Message-ID: | 20020411000634.E12535@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Apr 10, 2002 at 03:55:33PM +0200, Johann Zuschlag wrote:
> And what do you thing about that one:
>
> DEBUG: query: declare SQL_CUR01F61ED0 cursor for SELECT t29.* FROM STUECKLI t29 WHERE t29.artikelnum = '010001' AND t29.art IS NULL
> ORDER BY t29.artikelnum ASC, t29.art ASC, t29.Position ASC, t29.stueckarti ASC, t29.stckid ASC
> ERROR: No such attribute or function 'position'
>
> position is not anymore a keyword, IIRC.
> Usually I just patch the ODBC-driver and it works for me.
Let me guess, you have capitals in your field names. When you create the
table, *don't* put quotes around the field names. Then everything becomes
case insenstive.
HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing. Speaking out against censorship and ignorance is the imperative
> of all intelligent people.
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Finch, FosterFinch Ltd | 2002-04-10 14:08:13 | Re: Who's using PostgreSQL? (thanks) |
Previous Message | Fran Fabrizio | 2002-04-10 13:56:31 | Re: Who's using PostgreSQL? (thanks) |