Re: bug in info.c file - incorrect SQL - Mailing list pgsql-odbc

From Tom Lane
Subject Re: bug in info.c file - incorrect SQL
Date
Msg-id 11662.1041629922@sss.pgh.pa.us
Whole thread Raw
In response to Re: bug in info.c file - incorrect SQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: bug in info.c file - incorrect SQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-odbc
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: bug in info.c file - incorrect SQL
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: bug in info.c file - incorrect SQL