Re: bug in info.c file - incorrect SQL

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: 03 January 2003 02:17
> To: Hiroshi Inoue
> Cc: Jim Holliday; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] bug in info.c file - incorrect SQL
>
>
> Hiroshi Inoue wrote:
> > > -----Original Message-----
> > > From: Bruce Momjian
> > >
> > > Good catch, patch attached. I found the problems you saw,
> plus a few
> > > cases where pg_namespace was referenced in the WHERE but not FROM
> > > --- not a big problem, but clearer if we specify it both places.
> > > Patch applied.
> >
> > Unfortunately it doesn't seem a right fix.
> > I would fix it later.
>
> Thanks, Hiroshi.  Also, seems someone is having trouble using
> the info functions in the current ODBC release, probably
> because of this bug.

The most recent problem there was with me, and it wasn't that I didn't
know what was wrong, rather snprintf wasn't behaving quite as I
expected. Tom helped me out by pointing out the obvious workaround that
I'm still kicking myself for not thinking of.

> Can you roll a new release once you fix it?  Thanks.

Hmm, I'm pretty busy right now, but when Hiroshi gives me the nod I'll
try to fit one in.

Regards, Dave.