Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL EndTransactionBlock and not inprogress/abort state - Mailing list pgsql-general

From Manuel Lemos
Subject PostgreSQL EndTransactionBlock and not inprogress/abort state
Date
Msg-id 492.742T2685T1906242@acm.org
Whole thread Raw
List pgsql-general
Tree view 
Hello,

I am trying to use transactions with PostgreSQL with the normal sequence

BEGIN
one or more SELECT/INSERT/UPDATE/DELETE queries
COMMIT
END

But I am getting the following message just like if I haven't started a
transaction when I commit.

EndTransactionBlock and not inprogress/abort state

Anybody experienced anything like this with PostgreSQL 6.4.2?

Regards,
Manuel Lemos

E-mail: mlemos@acm.org
URL: http://www.e-na.net/the_author.html
PGP key: finger://mlemos@zeus.ci.ua.pt
--

pgsql-general by date:

Previous
From: "Manuel Lemos"
Date:
Subject: Negating the list of selected rows of a join
Next
From: Clark Evans
Date:
Subject: Re: [GENERAL] Negating the list of selected rows of a join