Re: transaction safety - Mailing list pgsql-general

From Tom Lane
Subject Re: transaction safety
Date
Msg-id 4437.982075941@sss.pgh.pa.us
Whole thread Raw
In response to Re: transaction safety  (DaVinci <bombadil@wanadoo.es>)
Responses Re: transaction safety
Re: transaction safety
List pgsql-general
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.

However, you still have not shown us a complete example that would allow
anyone else to reproduce your results.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: [ANNOUNCE] Request for speakers at O'Reilly conference
Next
From: Tom Lane
Date:
Subject: Re: "downgrade" 7.1.x to 7.0.x