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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jose' Cruanyes" <cruanyes(at)cegroup(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: Re: [ODBC] invalid input syntax for type tid: "(,)"
Date: 2004-04-04 05:04:46
Message-ID: 20827.1081055086@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-odbc pgsql-ports

"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 others.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bud Curtis 2004-04-04 05:23:25 Problem after RH9 Install of 7.4.2
Previous Message Jose' Cruanyes 2004-04-03 21:51:40 invalid input syntax for type tid: "(,)"

Browse pgsql-odbc by date

  From Date Subject
Next Message Philippe Lang 2004-04-04 11:36:20 ODBC driver further developments?
Previous Message Jose' Cruanyes 2004-04-03 21:51:40 invalid input syntax for type tid: "(,)"

Browse pgsql-ports by date

  From Date Subject
Next Message Richard Frith-Macdonald 2004-04-04 09:37:38 libpq and libecpg problems on MacOs-X (Panther/10.3.3)
Previous Message Jose' Cruanyes 2004-04-03 21:51:40 invalid input syntax for type tid: "(,)"