Re: Reliable and fast money transaction design - Mailing list pgsql-general

From Ron Johnson
Subject Re: Reliable and fast money transaction design
Date
Msg-id 46D597FC.3050504@cox.net
Whole thread Raw
In response to Re: Reliable and fast money transaction design  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/29/07 10:47, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
>> On 08/29/07 07:27, cluster wrote:
>>> Just make sure and read up about transaction isolation... in the default
>>> of READ COMMITTED mode, you can sometimes see changes made by other
>>> transactions.
>
>> Argh!!!  The RDBMS that I typically use defaults to SERIALIZABLE.
>
> You can change default_transaction_isolation if you like.

You misunderand: we do that on purpose, and I had forgotten that
most RDBMSs don't do that.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG1Zf8S9HxQb37XmcRAjt+AKCW7I1H9ON60TEUaZMzLzcXYFb0pwCgh9qC
Q+VwNMFCHTWqq1mTL8kx13w=
=3NIY
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump.... pg_restore...how long does it take?
Next
From: Alvaro Herrera
Date:
Subject: Re: Question regarding autovacuum in 8.1