Re: [GENERAL] transaction safety

[DaVinci]

On Tue, Feb 13, 2001 at 09:52:21AM -0500, Tom Lane wrote:
> DaVinci <[EMAIL PROTECTED]> 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