Re: transaction safety

DaVinci <bombadil@wanadoo.es> writes:
> On Mon, Feb 12, 2001 at 01:08:01PM -0000, Michael Ansley wrote:
>> Typically, the insert for a person, and for all the associated addresses
>> would be done in the same transaction so that if the insert for one of the
>> addresses failed, then the whole lot would role back (perhaps a bit extreme,
>> but I think that's what you asked for ;-)

>  I thought it is possible to have different transactions opened and insert
>  data in same table from them. It seems my idea was fault, doesn't it?.
>  In sumary: locks with inserts are for table and not for tuple. If this is
>  not true, tell me details, please :)

It's not true.  How did you arrive at that conclusion from what Mike
said?

            regards, tom lane