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

From Hiroshi Inoue
Subject Re: bug in info.c file - incorrect SQL
Date
Msg-id 3E191241.325D0D3D@tpf.co.jp
Whole thread Raw
In response to Re: bug in info.c file - incorrect SQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-odbc
Tom Lane wrote:
>
> 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.

OK I would change as such when I have a time.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

pgsql-odbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: bug in info.c file - incorrect SQL
Next
From: Miguel Gonzalez
Date:
Subject: unsubscribe