Re: RI_FKey_check: foreign key constraint blocks parallel

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: RI_FKey_check: foreign key constraint blocks parallel
Дата
Msg-id t6oatuc4tubo6j6tg9cefg1q3r4dtq50m1@4ax.com
обсуждение исходный текст
Ответ на Re: RI_FKey_check: foreign key constraint blocks parallel  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: RI_FKey_check: foreign key constraint blocks parallel  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-hackers
On Wed, 13 Nov 2002 14:22:51 -0800 (PST), Stephan Szabo
<sszabo@megazone23.bigpanda.com> wrote:
>Right now, I know that it has a hole that lets through invalid data

Stephan, your patch has been posted to -general (Subject: Re:
[GENERAL] Help..Help...).  Is this version still valid?

> void
> heap_mark4fk_lock_acquire(Relation relation, HeapTuple tuple) {
>  [...]
>  /* try to find the list for the table in question */
This part of the patch works, if the list
(a) is initially empty or
(b) already contains relid or
(c) starts with a table > relid.

>  while (ptr!=NULL) {
>   if (relid>ptr->table) {
>    ptr=ptr->next;
>    oldptr=ptr;
// AFAICT above two lines should be swapped ...
>   }
>   else 
>    break;
>  }

... otherwise
(d) if the new relid is to be inserted between two existing entries,
we get two items pointing to each other
(e) if the new relid is > the last table in the list, we lose the
whole list.

ServusManfred


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: Time to move on...
Следующее
От: Tom Lane
Дата:
Сообщение: char(n) to varchar or text conversion should strip trailing spaces