From: | "Johann Zuschlag" <zuschlag(at)online(dot)de> |
---|---|
To: | "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 13:55:33 |
Message-ID: | E16vIZM-0004g8-00@mrvdom00.kundenserver.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 09 Apr 2002 16:53:16 -0400, Tom Lane wrote:
>> all-test=# create table text (textid varchar(10));
>> ERROR: type named text already exists
>
>Every table has an associated datatype of the same name (to wit,
>its row type). So there's a naming conflict when the system tries
>to create the row type for your table.
Hi Tom,
but that won't help me if I have to port an app. from MS-SQL
to PostgreSQL. I can't change the app.
Ok, I can patch the ODBC-driver, but there should be
a smarter solution in future.
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.
regards
Johann Zuschlag
zuschlag(at)online(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | Fran Fabrizio | 2002-04-10 13:56:31 | Re: Who's using PostgreSQL? (thanks) |
Previous Message | Daniel Ferreira Felix | 2002-04-10 13:51:37 | ENC: Datatype time PostGreSql 7.2.1 |