[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Triggers and transactions
From:       Rosser Schwarz <rosser.schwarz () gmail ! com>
Date:       2013-01-28 19:25:18
Message-ID: CAFnxYwhfo-EGDheyyNSEGZM7Pt6ewrktoN-Sw29c_-3aS=s0CA () mail ! gmail ! com
[Download RAW message or body]

On Mon, Jan 28, 2013 at 10:54 AM, Craig James <cjames@emolecules.com> 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

[Attachment #3 (text/html)]

<div dir="ltr"><div style>On Mon, Jan 28, 2013 at 10:54 AM, Craig James <span \
dir="ltr">&lt;<a href="mailto:cjames@emolecules.com" \
target="_blank">cjames@emolecules.com</a>&gt;</span> wrote:<br></div><div \
class="gmail_extra"> <div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">But \
if the drop-and-restore-trigger operation blocks all access to the tables, that&#39;s \
a problem.<br>

</blockquote></div><br><div><span \
style="font-family:arial,sans-serif;font-size:13px">Were the triggers in question \
created with &quot;CREATE CONSTRAINT TRIGGER&quot;?  If not, </span><span \
style="font-family:arial,sans-serif;font-size:13px">&quot;ALTER TABLE foo DISABLE \
TRIGGER USER&quot; may do what you need here.</span></div> <div><span \
style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div><span \
style="font-family:arial,sans-serif;font-size:13px">rls</span></div><div><br></div>-- \
<br>:wq </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]