Re: [GENERAL] EndTransactionBlock error - Mailing list pgsql-general

From Ed Loehr
Subject Re: [GENERAL] EndTransactionBlock error
Date
Msg-id 388CFC64.F73C4F2F@austin.rr.com
Whole thread Raw
In response to EndTransactionBlock error  ("Graeme Merrall" <gmerrall@email.com>)
List pgsql-general
Ed Loehr wrote:
>
> Correction:  this message happens when you 'commit' but without
> anything to commit.
>
> % destroydb test; createdb test; psql -d test -c "commit"
> NOTICE:  EndTransactionBlock and not inprogress/abort state
> END

And it seems to be a harmless occurrence, **assuming** you do not have
a logic error leading to an empty commit (a big assumption?).

Cheers,
Ed Loehr

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] EndTransactionBlock error
Next
From: "Barnes"
Date:
Subject: RE: [GENERAL] PostgreSQL running on Redhat 6.1 and VB6.0