Re: Referential Integrity

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Temporarily disable the triggers on that table and then re-enable them
afterwards. The trick is to set pg_class.reltriggers = 0 to disable and
then restore it to the correct number of triggers afterward. Play with
pg_restore or search the recent (last month) archives for more on this.
If you give pg_restore enough information it will disable triggers oduring
the load. You'd want to read that for an example of the correct SQL. Also,
I posted last month two functions to disable/enable all non-system
triggers in on swell foop. Look in the archives for that.

Joshua b. Jore
http://www.greentechnologist.org

On Mon, 15 Apr 2002, Rob wrote:

> Hi all,
>
> I've got a column in one of my tables that references another column in
> another table
>     i.e. barcode REFERENCES product(barcode)
>
> Is there a way to drop this referential integrity for a while and then
> reinstate it?
>
>
>
> --
> Rob
>
> He who dies with the most toys ...
>
>                     ... still dies
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8utEKfexLsowstzcRAhIWAJsEdG0U+xQ86/5uztMGENzVFatWawCeOVm1
wtmltx7CyDrr3kKfGSD5QJM=
=e0nU
-----END PGP SIGNATURE-----