Re: transaction_isolation vs. default_transaction_isolation - Mailing list pgsql-hackers

Itagaki-san,

> BEGIN;
> SET transaction_isolation = 'serializable';
> SET default_transaction_isolation = 'read committed';
> SHOW transaction_isolation;
>     => serializable
> SHOW default_transaction_isolation;
>     => read committed
> COMMIT;
> -- next transaction uses default_transaction_isolation
> SHOW transaction_isolation;
>     => read committed

Thank you; that was very informative.

--Josh