Re: bug in info.c file - incorrect SQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bug in info.c file - incorrect SQL
Дата
Msg-id 11662.1041629922@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: bug in info.c file - incorrect SQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: bug in info.c file - incorrect SQL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: bug in info.c file - incorrect SQL
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: Re: bug in info.c file - incorrect SQL