Re: COPY and triggers - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY and triggers
Date
Msg-id 24093.998176780@sss.pgh.pa.us
Whole thread Raw
In response to COPY and triggers  ("Oliver Elphick" <olly@lfix.co.uk>)
List 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 by date:

Previous
From: Stephen Robert Norris
Date:
Subject: Re: Serial not so unique?
Next
From: Justin Clift
Date:
Subject: Re: Serial not so unique?