| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org, gb-docs(at)greatbridge(dot)org |
| Subject: | Re: COPY and triggers |
| Date: | 2001-08-18 23:19:40 |
| Message-ID: | 24093.998176780@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Oliver Elphick" <olly(at)lfix(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark McWilliams | 2001-08-19 00:12:23 | how do you recover a postgresql online backup |
| Previous Message | Stephen Robert Norris | 2001-08-18 23:18:27 | Re: Serial not so unique? |