Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id E1636514018 for ; Fri, 9 Mar 2012 10:09:47 -0400 (AST) Received: from mail-gx0-f174.google.com ([209.85.161.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S60Vq-0000AR-QA for pgsql-hackers@postgresql.org; Fri, 09 Mar 2012 14:09:44 +0000 Received: by gghe5 with SMTP id e5so839259ggh.19 for ; Fri, 09 Mar 2012 06:09:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; bh=QJX4K3d4zBSBeEWw1XbbLvYpR1HjkWRv9+OnvqHS8l0=; b=huwhmAHRv9Ka4XvGNvMvrRiEvsCCHF3SWaQESJpdD7bPhBD2dL5agK1EU5AcyUsxyx 6MSZv3UfoPWNt4iLwMCi8dDnmVcYIRGfFaewBaDZEwooYu8RyRcVgpZab5P3dlOFhQPY DvlF8wJDxrgo3CDs9zK+COrgxdsjRy138GvQ2jgLb2hfdqaEpD3RJ5ZSxZlTNy9by8nK q9yUDv1r2RGDjVJjpEw1yS+vzi3odDNUNY3VgRNfVze9DjlkvLAovtgWC5a3GGJtKfbx IA14FlNqxmkXjVacMn5L5o3orRVMWTouUH3SebZgKV00cu37R4gkp9xATndCU2ZMtaeG Tovw== MIME-Version: 1.0 Received: by 10.50.184.200 with SMTP id ew8mr3442819igc.1.1331302169897; Fri, 09 Mar 2012 06:09:29 -0800 (PST) Received: by 10.50.106.132 with HTTP; Fri, 9 Mar 2012 06:09:29 -0800 (PST) In-Reply-To: References: <201203041650.39826.andres@anarazel.de> Date: Fri, 9 Mar 2012 09:09:29 -0500 Message-ID: Subject: Re: Command Triggers, patch v11 From: Robert Haas To: Thom Brown Cc: Dimitri Fontaine , pgsql-hackers@postgresql.org, Andres Freund , Tom Lane Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201203/572 X-Sequence-Number: 204454 On Wed, Mar 7, 2012 at 4:53 PM, Thom Brown wrote: > I've also since found that if I issue a VACUUM, CLUSTER or REINDEX on > a read-only standby, the BEFORE ANY COMMAND trigger fires. =A0I don't > think any trigger should fire on a read-only standby. Why ever not? --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company