Re: transaction safety

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: DaVinci <bombadil(at)wanadoo(dot)es>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: transaction safety
Date: 2001-02-13 14:52:21
Message-ID: 4437.982075941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

DaVinci <bombadil(at)wanadoo(dot)es> writes:
> procedencia int2 references procedencia,
> lnea int2 references lnea,
> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-13 15:00:31 Re: "downgrade" 7.1.x to 7.0.x
Previous Message Bruce Momjian 2001-02-13 14:47:23 Re: Re: numeric type and odbc from access 2000