How to turn off referential integrity

How to turn off referential integrity

	Pam Wampler
	Apr 8, 2002 at 5:17 pm

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.

Thanks very much

Pam Wampler

Search Discussions

Discussion Posts

Follow ups

Joshua b. Jore: I have two functions for just that trick. I'm retyping this from another screen so there may be a typo or two. The DisableTriggers() function does more work than it has to - I copied the joins from the EnableTriggers() function which does need the extra joins. The key is, just set pg_class.reltriggers to either 0 or the correct number of triggers. Josh DROP FUNCTION DisableTriggers(); CREATE FUNCTION DisableTriggers() RETURNS BOOLEAN AS ' DECLARE Rows INTEGER; BEGIN UPDATE pg_class SET
Tom Lane: 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

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 1 of 3 \| next ›

Discussion Overview

group	pgsql-novice @
categories	postgresql
posted	Apr 8, '02 at 5:17p
active	Apr 8, '02 at 7:20p
posts	3
users	3
website	postgresql.org
irc	#postgresql

font	variable	Hotkey: f
user style	avatars	Hotkey: a

How to turn off referential integrity

Search Discussions

Discussion Posts

Related Discussions

3 users in discussion