Re: Fix for VACUUM in psql autocommit off

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Fix for VACUUM in psql autocommit off
Дата
Msg-id 22029.1095626662@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Fix for VACUUM in psql autocommit off  ("Michael Paesold" <mpaesold@gmx.at>)
Список pgsql-patches
"Michael Paesold" <mpaesold@gmx.at> writes:
>  Or do I not understand what you mean by nested
> comments? (There is code for ignore /* .. */ before the first keyword.)

Per SQL spec, the backend thinks that /* .. */ nests:

regression=# /* some /* comment */ comment */ select 1;
 ?column?
----------
        1
(1 row)

As it stands, is_transact_command will get confused by this.

> Any suggestion how to that? I can think of a way myself, but it may not be
> the best, as I don't consider C my natural language. I can try, or does
> anyone else feel inclined to fix this?

I'd split out the code that locates "the next keyword" into a separate
function that could be called twice.

            regards, tom lane

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

Предыдущее
От: "Michael Paesold"
Дата:
Сообщение: Re: Fix for VACUUM in psql autocommit off
Следующее
От: "Michael Paesold"
Дата:
Сообщение: Re: Fix for VACUUM in psql autocommit off