Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)

From: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Date: 2005-08-08 05:13:28
Message-ID: 42F6E9F8.9070709@nttdata.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)nttdata(dot)co(dot)jp>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2005-08-08 07:52:14 Re: obtaining row locking information
Previous Message Tom Lane 2005-08-08 03:36:09 Re: Cygwin - make check broken

Browse pgsql-patches by date

  From Date Subject
Next Message Brendan Jurd 2005-08-08 08:16:30 Re: gettime() - a timeofday() alternative
Previous Message Alvaro Herrera 2005-08-08 01:18:10 Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)