From: | Dennis Gearon <gearond(at)cvc(dot)net> |
---|---|
To: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
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 21:45:50 |
Message-ID: | 3E80CE0E.7070208@cvc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't manage my database directly too much, just when needed. phpPgAdmin is
what I use, and it has the problem I described below. perhaps that is happening
in that library, and not at the postgres side of the exchange. As I get more
into this, and someday have my own box on the web, I will be doing more directly
manipulation of the database, from an admin POV as well.
Jean-Luc Lachance wrote:
> 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 | Dennis Gearon | 2003-03-25 21:47:42 | Re: TEXT datatype and VB6... |
Previous Message | Andrew Ayers | 2003-03-25 21:28:59 | Re: TEXT datatype and VB6... |