Craig Servin <[EMAIL PROTECTED]> writes:
> I am trying to make some foreign keys deferrable and initially deferred.
> These foreign key constraints already exist so I was going to change them by
> updating pg_trigger and pg_constraint.
> However the changes do not seem to take affect. Is there something I need to
> do to get PostgreSQL to recognize that I have tweaked it's tables?
Try starting a fresh backend session. Manual hacking of those tables
isn't going to cause a relcache reload ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
