Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction

From: Ravi Krishna <srkrishna1(at)comcast(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction
Date: 2020-05-13 10:42:25
Message-ID: edd3dc23-8093-d511-d86f-301ddc7685a3@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> the pgm does an INSERT, after this the row is there and can be seen
> with SELECT; than I CLOSE a non existing cursor, which rolls back
> the INSERTed data:

I have not done coding in ESQL/C in a long time, but shouldn't that be
expected as any error should trigger a rollback.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Ellis 2020-05-13 11:02:51 Why is it that “aggregate functions are not allowed in FROM clause of their own query level”?
Previous Message Matthias Apitz 2020-05-13 10:13:01 Re: ESQL/C: a ROLLBACK rolls back a COMMITED transaction