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

Re: bug in info.c file - incorrect SQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>,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:38:42
Message-ID: 11662.1041629922@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-odbc
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> 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?

I see another bug here:

The 7.3-and-up versions of these queries should explicitly prefix
"pg_catalog."  to the names of all system catalogs (and types and
functions) they reference.  This will make them bulletproof against
conflicts against user-defined names, which might appear in front of
the system names in the search path.

			regards, tom lane

In response to

Responses

pgsql-odbc by date

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

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