From: | Jorge Pereira <kell_pt(at)users(dot)sf(dot)net> |
---|---|
To: | PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Disabling triggers / constraints |
Date: | 2004-05-19 18:01:00 |
Message-ID: | 40ABA0DC.4030107@users.sf.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
After trying to do some custom dumping/restoring, and having to resort
to the awful trick of changing the trigger counts on the catalog (the
stuff pg_dump adds), decided to add a couple little variables to control
disabling constraints and triggers. Added them to guc.c so that they
show up in the SET/SHOW list, and added checks accordingly (always at
top level, to avoid unnecessary function calls and loops). Variables are
'disable_constraints' and 'disable_triggers' and they are "false" by
default.
I am unsure wether it is right to send such an uncalled-for patch, but
seeing as this is such a simple thing that can be quite useful (large
volumes of data), I thought it could be useful.
(apply with patch -p0 from the root distro directory)
Cheers
- Jorge Pereira
Attachment | Content-Type | Size |
---|---|---|
disable.patch | text/plain | 5.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2004-05-19 18:03:31 | Re: [COMMITTERS] pgsql-server/src backend/main/main.c backend/p ... |
Previous Message | Bruce Momjian | 2004-05-19 17:37:45 | Re: [COMMITTERS] pgsql-server/src backend/main/main.c backend/p ... |