Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items) - Mailing list pgsql-patches

From Satoshi Nagayasu
Subject Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Date
Msg-id 42F6E9F8.9070709@nttdata.co.jp
Whole thread Raw
In response to Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-patches
Alvaro Herrera wrote:
> There are a few elog() calls that should really be ereport().  Also
> this message

I've fixed to call ereport() on permission error.

>>+     elog(NOTICE, "%d trigger(s) on %s %s.",
>>+          changed,
>>+          NameStr(rel->rd_rel->relname),
>>+          enable ? "enabled" : "disabled");
>
>
> should really be two messages (Maybe even four: disabled-plural,
> disabled-singular, enabled-plural, enabled-singular)

What does "really be two messages" mean?

> There's a SQL typo here:
>
>>+             appendPQExpBuffer(query, "ALTER TABLE %s DIABLE TRIGGER %s;\n",

Fixed.

--
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Next
From: Brendan Jurd
Date:
Subject: Re: gettime() - a timeofday() alternative