Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-odbcpgsql-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

pgsql-ports by date

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

pgsql-admin by date

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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group