Re: invalid input syntax for type tid: "(,)"

From: Jose' Cruanyes <cruanyes(at)cegroup(dot)it>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: invalid input syntax for type tid: "(,)"
Date: 2004-04-04 21:51:17
Message-ID: 33898D66-8682-11D8-A231-0003935B359C@cegroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-odbc pgsql-ports


On Apr 4, 2004, at 7:04 AM, Tom Lane wrote:

> "Jose' Cruanyes" <cruanyes(at)cegroup(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message JM 2004-04-05 05:18:42 Glibc upgrade for postgres
Previous Message Bud Curtis 2004-04-04 05:23:25 Problem after RH9 Install of 7.4.2

Browse pgsql-odbc by date

  From Date Subject
Next Message Bruce Momjian 2004-04-05 01:30:34 Re: ODBC driver further developments?
Previous Message Shachar Shemesh 2004-04-04 19:58:29 Re: ODBC driver further developments?

Browse pgsql-ports by date

  From Date Subject
Next Message Dave Page 2004-04-05 09:32:39 Re: invalid input syntax for type tid: '(,)'
Previous Message Richard Frith-Macdonald 2004-04-04 09:40:09 Re: libpq and libecpg problems on MacOs-X (Panther/10.3.3)