Postgres Pro
Downloads
Home   >   mailing lists

Re: longchar data type?? - Mailing list pgsql-odbc

From Tom Lane
Subject Re: longchar data type??
Date
Msg-id 11307.1137716417@sss.pgh.pa.us
Whole thread Raw
In response to longchar data type??  (Ben Davis <bendavis78@gmail.com>)
Responses Re: longchar data type??  (Ludek Finstrle <luf@pzkagis.cz>)
Re: longchar data type??  (Ben Davis <bendavis78@gmail.com>)
List pgsql-odbc
Tree view 
Ben Davis <bendavis78@gmail.com> writes:
> Hi all.  I'm desparately trying to get Microsoft Project to connect to work
> with my postgresql server via ODBC.  For some reason,  MS Project tries to
> create a column with the datatype  "longchar"  when it should be
> "longvarchar".   Is it possible to tweak the psqlodbc source code so that it
> will accept the "longchar" type and convert it to "text" ??   I'd be happy
> to write a patch if someone can point me in the right direction...

Seems like it might work to just go

    CREATE DOMAIN longchar AS text;


            regards, tom lane

pgsql-odbc by date:

Previous
From: Ben Davis
Date:
Subject: longchar data type??
Next
From: zhaoxin
Date:
Subject: Re: some question about SavePoint ?