From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
---|---|
To: | gearond(at)cvc(dot)net |
Cc: | "Shridhar Daithankar<shridhar_daithankar(at)nospam(dot)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: trigger question. |
Date: | 2003-03-25 20:27:53 |
Message-ID: | 3E80BBC9.EB8A8AB6@nsd.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Have you looked at the output of "pg_dump -at" lately?
JL
Dennis Gearon wrote:
>
> As a follow up, I would read the trigger into a file first, so that you can
> restore it. Also, watch single quotes and the semicolon at the end of the
> trigger definition. It may not show up correctly in the structure readout of the
> trigger.
>
> And, you don't need to drop the functions that the trigger references, just the
> trigger.
>
> Shridhar Daithankar wrote:
> > On Tuesday 25 Mar 2003 9:31 pm, alain(dot)bruneau(at)acoss(dot)fr wrote:
> >
> >>I have a problem with trigger. I don't find a way to disable it.
> >>Oracle statement :
> >>ALTER TRIGGER "TRG_DT_ACTI" ENABLE
> >>or
> >>ALTER TRIGGER "TRG_DT_ACTI" DISABLE
> >>I am looking for a way to do the same thing with postgresql.
> >>
> >>I want to disable trigger before COPY and enable it after.
> >>How can I do that?
> >
> >
> > Drop and recreate respectively.
> >
> > HTH
> >
> > Shridhar
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Flower Sun | 2003-03-25 20:32:53 | log rotation script for server output |
Previous Message | Dennis Gearon | 2003-03-25 19:39:46 | Re: TEXT datatype and VB6... |