Re: bug in info.c file - incorrect SQL

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

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