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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jose' Cruanyes" <cruanyes(at)cegroup(dot)it>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: invalid input syntax for type tid: "(,)"
Date: 2004-04-06 14:32:36
Message-ID: 200404061432.i36EWab06319@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-odbcpgsql-ports
Jose' Cruanyes wrote:
> 
> 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...

Has this been fixed in ODBC CVS?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-ports by date

Next:From: M KDate: 2004-04-07 13:38:09
Subject: Postgresql .pdf docs for 7.4.2
Previous:From: Peter EisentrautDate: 2004-04-06 00:20:17
Subject: Re:

pgsql-admin by date

Next:From: LukaszDate: 2004-04-06 15:06:15
Subject: Problem
Previous:From: Marion McKelvieDate: 2004-04-06 12:02:35
Subject: restoring large objects

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2004-04-06 14:33:47
Subject: Re: ODBC driver further developments?
Previous:From: Bruce MomjianDate: 2004-04-06 14:27:19
Subject: Re: missing #include in multibyte.c

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