How to close transaction? - Mailing list pgsql-general

From ds@ics.elcom.ru
Subject How to close transaction?
Date
Msg-id Pine.LNX.4.04.9909021932200.11694-100000@ics.elcom.ru
Whole thread Raw
List pgsql-general
Hello,

If I use RAISE EXCEPTION operator in stored procedure, should I call
ROLLBACK in client application to complete the transaction?

Now I'm getting notice from postgres backend:

UserAbortTransactionBlock and not in in-progress state

It seems to me I call ROLLBACK when the transaction does not exist
already? Am I right?

Where can I read more about different notice and error messages?

Thanks,

Dmitry Sorokin








pgsql-general by date:

Previous
From: "Natalya S. Makushina"
Date:
Subject: Re: [GENERAL] GEQO and KSQO problem.
Next
From: Charles Tassell
Date:
Subject: Re: [GENERAL] Whence libpgtcl.so ??