Craig Servin <cservin(at)cromagnon(dot)com> 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