Re: Odd query execution behavior with extended protocol - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Odd query execution behavior with extended protocol
Date
Msg-id 32741.1443976832@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd query execution behavior with extended protocol  (Shay Rojansky <roji@roji.org>)
List pgsql-hackers
Shay Rojansky <roji@roji.org> writes:
>> Try adding a sync before the second execute.

> I tried inserting a Sync right before the second Execute, this caused an
> error with the message 'portal "MQ1" does not exist'.
> This seems like problematic behavior on its own, regardless of my issues
> here (Sync shouldn't be causing an implicit close of the portal, should
> it?).

Sync results in closing the transaction, if you've not explicitly executed
a BEGIN.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Odd query execution behavior with extended protocol
Next
From: Pavel Stehule
Date:
Subject: Re: check fails on Fedora 23