Re: Connection gets into state where all queries fail

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Connection gets into state where all queries fail
Дата
Msg-id 24034.1087945475@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Connection gets into state where all queries fail  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Tue, Jun 22, 2004 at 04:30:15PM -0600, Scott Ribe wrote:
>> What's not clear is why I should be told this when the invalid query ended
>> with a commit.

> Hmm, it only happens when you send the whole lot in a single query
> strings. That's not recommended IIRC.

When you send multiple commands in a single query string, the entire
string is thrown away after an error.  That's how it's always worked,
and I believe it's well-documented.  There are apps that (mis?)use this
fact.

            regards, tom lane

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

Предыдущее
От: Chris Goughnour
Дата:
Сообщение: Re: flock user defined function
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Planner choice & tuning