Re: transaction safety

DaVinci <bombadil(at)wanadoo(dot)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