Re: longchar data type??

Great! I'm all for an easier solution :-)

On 1/19/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Ben Davis <bendavis78(at)gmail(dot)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
>