Re: value

Поиск
Список
Период
Сортировка
От Gissur Þórhallsson
Тема Re: value
Дата
Msg-id AANLkTimXGZ1iSKSNSo9bDjVQUOmVLxFQ8xm=MqUR8eXA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: value  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-general
OK, but you still need to be careful. That trick will only work if you
insert rows one at a time into the table. If you have a single insert
that inserts multiple rows (as in my example), it would fail because
the currval() call would return the same value for each row in the
insert created by the rule.
 
My advice would be to convert to triggers.
 
After going over your example a bit better, I think I will follow your advice.
Thanks a lot for the heads up.

Kind regards from Iceland,
Gissur Þórhallsson

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

Предыдущее
От: hans@welinux.cl
Дата:
Сообщение: Re: Simple schema diff script in Perl
Следующее
От: Florian Weimer
Дата:
Сообщение: Re: Simple schema diff script in Perl