Re: Transaction issue

On Wed, 19 Jun 2024, Adrian Klaver wrote:

> It shouldn't:
>
> cat transaction_test.sql
> BEGIN;
> insert into transaction_test values(1, 'test'), (2, 'dog'), (3, 'cat');
>
> test=# create table transaction_test(id integer, fld_1 varchar);
>
> test=# \i transaction_test.sql
> BEGIN
> INSERT 0 3
>
> test=*# commit ;
> COMMIT
>
> test=# select * from transaction_test ;
> id | fld_1
> ----+-------
> 1 | test
> 2 | dog
> 3 | cat
> (3 rows)

Yes, I see how this works if the transaction is committed. But before I
commit the transaction I run a select statement to ensure the rows added are
correct. Can I rollback a commited transaction? I've assumed not, so I won't
commit the transaction without testing. And I'm not getting a detailed error
message.

Rich