COPY and triggers

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: COPY and triggers
Date: 2001-08-18 22:04:40
Message-ID: 200108182204.f7IM4ima013901@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)Elphick(at)lfix(dot)co(dot)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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-18 22:32:12 Re: Serial not so unique?
Previous Message Stephen Robert Norris 2001-08-18 20:26:15 Re: Serial not so unique?