COPY and triggers

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема COPY and triggers
Дата
Msg-id 200108182204.f7IM4ima013901@linda.lfix.co.uk
обсуждение исходный текст
Ответы Re: COPY and triggers  (Peter Eisentraut <peter_e@gmx.net>)
Re: COPY and triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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? or is there some method of disabling
triggers and constraints that I have overlooked?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "And I say unto you, Ask, and it shall be given you;
      seek, and ye shall find; knock, and it shall be opened
      unto you."            Luke 11:9



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

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