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

From Ed Loehr
Subject Re: [GENERAL] EndTransactionBlock error
Date
Msg-id 388CFBA2.6516A1FE@austin.rr.com
Whole thread Raw
In response to EndTransactionBlock error  ("Graeme Merrall" <gmerrall@email.com>)
List pgsql-general
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

Cheers,
Ed Loehr

Graeme Merrall wrote:
>
> > Not certain, but I think you get an error message like that when you
> > rollback at inappropriate (but harmless?) times, as in when you are
> > not in a transaction or have nothing pending on the current
> > transaction.
> The transaction goes though OK so I don't think it's that. I'll take a
> closer look though.
>

pgsql-general by date:

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