Re: Unusual problem. A sequence is incrementing by 2 when

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Unusual problem. A sequence is incrementing by 2 when
Дата
Msg-id 20011104201048.C38619-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Unusual problem. A sequence is incrementing by 2 when increment_by = 1, think it's caused by an INSERT rule  (Justin Clift <justin@postgresql.org>)
Список pgsql-general
I think this is probably the same side effect that causes
insert rules using NEW.<nextvalcol> to increment and put
different values in a master and detail table.  IIRC,
when it sees the new.idnum in your rule anywhere it sees
the nextval(...) not the value and will call nextval again.
I think if you search for foreign key problems and
insert rules you'll probably find posts by Tom that
probably have more details.


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: My new job
Следующее
От: Bruce Momjian
Дата:
Сообщение: My new job with SRA