I think I fixed this problem.
See the patch here.
http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?996
scot.
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]On Behalf Of Johann Zuschlag
Sent: Tuesday, November 09, 2004 7:37 AM
To: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] 08.00.0002 useless :-)
Dave Page wrote:
>
>
>
>
>>-----Original Message-----
>>From: pgsql-odbc-owner@postgresql.org
>>[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Johann Zuschlag
>>Sent: 08 November 2004 17:59
>>To: pgsql-odbc@postgresql.org
>>Subject: [ODBC] 08.00.0002 useless :-)
>>
>>Hello,
>>
>>somebody already mentioned it. I just want to repeat it. As
>>long as the driver produces strings like this:
>>
>>CREATE TABLE FOO (Userid varchar()(10) NOT NULL, Mcode
>>varchar()(25)...
>>
>>it is unfortunately useless. The backend will never accept it.
>>
>>I'm sure Hiroshi had something different in mind when he
>>changed that part of the code.
>>
>>Does somebody work on that?
>>
>>
>
>When exactly does the ODBC driver generate CREATE TABLE queries?
>
>Regards, Dave
>
>
>
Hi Dave,
well, my application tries to create the table and the driver adds the
"()". The old legacy driver didn't have that behavior, i.e. didn't
change my query. I don't understand why the driver adds the parenthesis.
Unfortunately I don't know the driver very well. Do you know where the
parenthesis's are added?
Regards,
Johann
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org