[pgpool-general: 1878] Re: current transaction is aborted, commands ignored

Sean Hogan sean at compusult.net
Mon Jul 8 23:14:25 JST 2013


On 13-07-08 11:10 AM, Sean Hogan wrote:
> If I comment out the syntactically incorrect statement (the first 
> one), then the last query succeeds with both PostgreSQL and pgpool.

You may ask why I care what happens with syntactically incorrect 
statements. :-)  One potential use case (not mine) is for a front-end 
application that lets a human key in SQL statements. Having to close and 
reopen the connection after each error would be rather ugly.

Thanks again,
Sean
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130708/bef63a4b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 287 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130708/bef63a4b/attachment.vcf>


More information about the pgpool-general mailing list