On Thursday, October 19, 2023, Juan Rodrigo Alejandro Burgos Mella <
rodrigoburgosme...@gmail.com> wrote:
> By default, psql is configured with autocommit on.
> Use another administrator, like phpadmin, and configure the
> connection with autocommit off.
>
No. Please leave autocommit on and incor
By default, psql is configured with autocommit on.
Use another administrator, like phpadmin, and configure the connection with
autocommit off.
Atte
JRBM
El jue, 19 oct 2023 a las 11:49, Wen Yi () escribió:
> Hi community,
> I am learning the transaction of the postgresql, and I try to test using
On 10/19/23 04:36, Wen Yi wrote:
Hi community,
I am learning the transaction of the postgresql, and I try to test using
these:
##
terminal 1:
postgres=# select * from t;
number
1
(1 row)
postgres=# update t set number = 2;
UPDATE 1
postgres=# select * from t;
number
On Thursday, October 19, 2023, Wen Yi wrote:
> Hi community,
> I am learning the transaction of the postgresql, and I try to test using
> these:
>
You failed to show how the two sessions interleave. Also, your first
session doesn’t use multi-statement transactions.
postgres=# insert into t val
Hi community,
I am learning the transaction of the postgresql, and I try to test using these:
##
terminal 1:
postgres=# select * from t;
number
1
(1 row)
postgres=# update t set number = 2;
UPDATE 1
postgres=# select * from t;
number
2
(1 row)
postgre
