FAQ

Pam Wampler writes:
I am using Postgresql 7.2 -- I would like to know how to turn off the
referential integrity of tables so that I can
do a bulk load & then turn the referential integrity back on.
There's a little dance you can do involving disabling and then
re-enabling the triggers that enforce RI. The easiest example is
to do a "pg_dump -a" (data only) dump from a small table and look
to see how pg_dump does it. IIRC, you don't need to touch the
triggers themselves, just hit the pg_class field that says whether
the table has triggers.

regards, tom lane

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedApr 8, '02 at 5:17p
activeApr 8, '02 at 7:20p
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase