Re: invalid input syntax for type tid: "(,)" - Mailing list pgsql-odbc

From Jose' Cruanyes
Subject Re: invalid input syntax for type tid: "(,)"
Date
Msg-id 33898D66-8682-11D8-A231-0003935B359C@cegroup.it
Whole thread Raw
In response to Re: invalid input syntax for type tid: "(,)"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: invalid input syntax for type tid: '(,)'
Re: invalid input syntax for type tid: "(,)"
List pgsql-odbc
On Apr 4, 2004, at 7:04 AM, Tom Lane wrote:

> "Jose' Cruanyes" <cruanyes@cegroup.it> writes:
>> select * from table1 where ctid = '(,)';
>> [ works on some machines and not others ]
>
> I would argue that the ODBC driver is broken and needs to be fixed,
> as does the TID input parser which should never allow this ...
>
> However, the reason for the platform dependency is probably that
> strtoul() is setting errno on some machines and not othe

since strtoul() should return 0 on an empty string, I think it will be
safe to change the instances of '(,)' to '(0,0)' in the driver source
code, even if it's not too clear to me what it does...

I've found three, two on "convert.c" and one on "results.c"

now if some one can put the changes upstream...

thanks.

Pax et Bonum

# dott. Jose' Cruanyes Aguilar  -  C.E. Soft srl
#  Pzza. Firenze,4 MILANO  -  XX Settembre 10, CREMONA
#   02,33603122                0372,460602


pgsql-odbc by date:

Previous
From: Shachar Shemesh
Date:
Subject: Re: ODBC driver further developments?
Next
From: Bruce Momjian
Date:
Subject: Re: ODBC driver further developments?