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

Re: bug in info.c file - incorrect SQL

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Jim Holliday <jholliday(at)aurigin(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: bug in info.c file - incorrect SQL
Date: 2003-01-03 21:17:12
Message-ID: 200301032117.h03LHCX10106@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Hiroshi Inoue wrote:
> -----Original Message-----
> From: Jim Holliday
> 
> > For the ODBC driver psqlodbc.dll version 7.02.0003 there is an error in
> the info.c. 
> > In 2 places the SQL contains an alias in the FROM clause for the
> pg_namespace
> > table and then references the table in the where clause.  The below cut
> from the
> > info.c file should replace all instances on pg_namespace. in the where
> clause with
> > pn. This should be done in both places.
> 
> Does the code give you a wrong result in the first place ?

I see what Hiroshi is saying now --- there was a reference to
pg_namespace (in WHERE but not in FROM) _and_ a reference to 'pn' as an
alias for pg_namespace (in WHERE and FROM).

The attached patch fixes this by creating a pn1 and pn2 alias for
pg_namespace in FROM.  It also improves some of the alias tags.  Applied
to ODBC CVS.  Can someone run some tests on these?

-- 
  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

Responses

pgsql-odbc by date

Next:From: Jim HollidayDate: 2003-01-03 21:34:45
Subject: Re: bug in info.c file - incorrect SQL
Previous:From: Hiroshi InoueDate: 2003-01-03 15:18:02
Subject: Re: bug in info.c file - incorrect SQL

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