> > Technically you *can* disable triggers, including RI checks, but it's VERY > unwise and almost completely defeats the purpose of having the checks. In > most such situations you're much better off dropping the constraints then > adding them again at the end of the load.
I know that the SQL server bulk loader defaults to not firing the triggers and I was hoping there would be an option on the COPY command to accomplish the same thing. pg_dump has a --disable-triggers option too. It seems to me that the COPY FROM should have an option that bypasses the triggers as a convience. Both the SQL server team and the postgres team have obviously recognized that there will be situations where the DBA will want to bulk load data without firing off a set of triggers for every insert. It doesn't seem like an outrageous expectation that the COPY command or something similar should have that option. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
