Re: transaction safety

On Tue, Feb 13, 2001 at 09:52:21AM -0500, Tom Lane wrote:
> DaVinci <bombadil@wanadoo.es> writes:
> >     procedencia    int2 references procedencia,
> >     l�nea        int2 references l�nea,
> >     empresa        int2 references empresa,
>
> Depending on the data values you are working with, it could be that the
> foreign key references cause interlocks --- ie, one transaction has to
> wait to see if the other commits to know if it has a valid foreign key.

 Problem is with referential integrity like you say. But I don't understand
 well reason. Interlocks should appear only when values of referenced tables
 are changed, added or removed, shouldn't they?. But that is not the case. I
 only insert in table "aviso".

 Is this normal?

 Greets.

                                                             David