Re: transaction safety

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: transaction safety
Дата
Msg-id 4437.982075941@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: transaction safety  (DaVinci <bombadil@wanadoo.es>)
Ответы Re: transaction safety
Re: transaction safety
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: [ANNOUNCE] Request for speakers at O'Reilly conference
Следующее
От: Tom Lane
Дата:
Сообщение: Re: "downgrade" 7.1.x to 7.0.x