PostgreSQL EndTransactionBlock and not inprogress/abort state

Manuel Lemos wrote:

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

I could be wrong, but the END isn't necessary.

BEGIN
....
COMMIT;

<or>

BEGIN
....
ROLLBACK;

Hope this helps,

Clark

Clark Evans wrote:

Manuel Lemos wrote:

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

Oops! forgot the semicolon. *whap*

BEGIN;

....
COMMIT;

<or>

BEGIN;

....
ROLLBACK;

BTW, are you putting on the "END" beacuse you are in a
PL/pgsql block? If so, I'm not sure if transactions
can work inside this language. Hmm.

Clark