Transaction Isolation Level

[zeny]

Hi everyone!

I´m using postgreql 8.3 and I know that the default transaction level in postgresql is READ_COMMITED, but how can I check the actual transaction isolation level at any time (in pgadminIII, preferably)?

Regards

[rski]

Hi everyone!

I´m using postgreql 8.3 and I know that the default transaction level in postgresql is READ_COMMITED, but how can I check the actual transaction isolation level at any time (in pgadminIII, preferably)?

Regards

I do not use PgAdmin, form psql client you can write

 show transaction isolation level;

I believe you can use it also under PgAdmin.

[zeny]

I do not use PgAdmin, form psql client you can write

 show transaction isolation level;

I believe you can use it also under PgAdmin.

Thank u very much, it works under PgAdmin alright.