Обсуждение: PostgreSQL EndTransactionBlock and not inprogress/abort state

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
--

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