BUG #3233: Trigger checks failed on concurrent transactions

Поиск
Список
Период
Сортировка
От Dmitry Belyavsky
Тема BUG #3233: Trigger checks failed on concurrent transactions
Дата
Msg-id 200704171032.l3HAWo6r047277@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3233
Logged by:          Dmitry Belyavsky
Email address:      beldmit@masterhost.ru
PostgreSQL version: 8.1.6
Operating system:   FreeBSD 6
Description:        Trigger checks failed on concurrent transactions
Details:

Greetings!

I have a table containing IP ranges and a BEFORE INSERT trigger checking the
ranges I insert don't intersect already existing ranges. So the concurrent
transactions are able to insert 2 intersecting ranges.

Whether TODO record "Allow statement-level triggers to access modified rows"
concerns the case I report?

Is there any workaround except LOCK TABLE causing performance degradation?

Thank you!

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

Предыдущее
От: "Jonathan Vanasco"
Дата:
Сообщение: BUG #3234: pg_dump uses the first version of a primary key's name when generating reports
Следующее
От: "Carsten"
Дата:
Сообщение: BUG #3232: Regression: pgsql server startup problem with encrypted partitions