Re: Connection gets into state where all queries fail

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Scott Ribe <scott_ribe(at)killerbytes(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connection gets into state where all queries fail
Date: 2004-06-22 23:04:35
Message-ID: 24034.1087945475@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-06-22 23:24:24 Re: Planner choice & tuning
Previous Message Chris Goughnour 2004-06-22 23:02:37 Re: flock user defined function