Re: COPY and triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY and triggers
Дата
Msg-id 24093.998176780@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY and triggers  ("Oliver Elphick" <olly@lfix.co.uk>)
Список pgsql-general
"Oliver Elphick" <olly@lfix.co.uk> writes:
> I've been reading Great Bridge's document on Administration and Tuning
> (PDF document under http://www.greatbridge.com/product/software.php)
> and came across this statement on page 27:

> "When using the COPY command to load data into a Great Bridge PostgreSQL
> database, the triggers and constraints on tables are disabled."

> This is contrary to what the man page on COPY says and to my experience.
> Is this statement wrong?

It's wrong.

COPY does not fire rules, but it does fire triggers and constraints.

            regards, tom lane

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

Предыдущее
От: Stephen Robert Norris
Дата:
Сообщение: Re: Serial not so unique?
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Serial not so unique?