Postgres Pro
Downloads
Home   >   mailing lists

Re: Updateing pg_trigger and pg_constraint - Mailing list pgsql-admin

From Craig Servin
Subject Re: Updateing pg_trigger and pg_constraint
Date
Msg-id 200508171640.41924.cservin@cromagnon.com
Whole thread Raw
In response to Re: Updateing pg_trigger and pg_constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
> Try starting a fresh backend session.  Manual hacking of those tables
> isn't going to cause a relcache reload ...
>
Simply reconnecting to the backend does not help.  If I restart the server
everything works as expected.  I am wondering if there is a way to trigger a
relcache reload without shutting down the PostgreSQL.

Craig

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Updateing pg_trigger and pg_constraint
Next
From: Jana Nguyen
Date:
Subject: PostgreSQL Installer for Windows: No buffer space available