Re: Updateing pg_trigger and pg_constraint

Craig Servin <cservin@cromagnon.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