Re: Triggers and transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jan 28, 2013 at 10:54 AM, Craig James <cjames@xxxxxxxxxxxxxx> wrote:
But if the drop-and-restore-trigger operation blocks all access to the tables, that's a problem.

Were the triggers in question created with "CREATE CONSTRAINT TRIGGER"?  If not, "ALTER TABLE foo DISABLE TRIGGER USER" may do what you need here.

rls

--
:wq

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux