Re: extended stats objects are the only thing written like "%s"."%s"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: extended stats objects are the only thing written like "%s"."%s"
Дата
Msg-id 1050792.1630180101@sss.pgh.pa.us
обсуждение исходный текст
Ответ на extended stats objects are the only thing written like "%s"."%s"  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> I think using "%s.%s" as is done everywhere else is pretty much
> pointless.  It's not usable as an object identifier, since you have to
> make sure to remove the existing quotes, and unless the names work
> without quotes, you have to add different quotes.  So it looks «nice»
> but it's functionally more work.

I think what we are doing there is following the message style
guideline that says to put double quotes around inserted strings.
In this case schema.object (as a whole) is the inserted string.
People often confuse this with SQL double-quoted identifiers, but it
has nothing whatsoever to do with SQL's rules.  (It's easier to make
sense of this rule in translations where the quote marks are not
ASCII double-quotes ... like your example with «nice».)

In short: Justin is right, this should not be done this way.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: extended stats objects are the only thing written like "%s"."%s"
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: pg_receivewal: remove extra conn = NULL; in StreamLog