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