Thread

bytea type and precision.

Michael J Schout <mschout@mail.gkg-com.com> — 1999-08-02T16:27:44Z

Hi.

I am trying to get postgresql to store data from MS-Project via ODBC.  So
far I have managed to get pretty close, but the save operation fails when
creating a table with one column specified as "fieldname bytea(8)".
Postgresql does not like the precision argument and bombs out with a parse
error at the '('.  
e.g.: create table foo (f1 bytea)    # ok
      create table foo (f1 bytea(8)) # fails

Awhile back on the list (dec 7 1998). this was brought up for inclusion
into the 6.4 tree.  Since Im running 6.5.1 I assume the patch that fixed
this never made it.  Was there a resolution to this issue as to why it
never was included into the main source?  And if so, does anyone know where
I can get this patch to get Project and postgresql to work together?

Thanks for any info anyone has.
Mike