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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-odbc pgsql-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

Browse pgsql-admin by date

  From Date Subject
Next Message Lukasz 2004-04-06 15:06:15 Problem
Previous Message Marion McKelvie 2004-04-06 12:02:35 restoring large objects

Browse pgsql-odbc by date

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

Browse pgsql-ports by date

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