X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8269D32A7D4 for ; Mon, 18 Oct 2004 03:35:20 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02025-09 for ; Mon, 18 Oct 2004 02:35:05 +0000 (GMT) Received: from smtp.bltconsult.com (smtp.bltconsult.com [64.124.68.186]) by svr1.postgresql.org (Postfix) with ESMTP id 1C78832A62E for ; Mon, 18 Oct 2004 03:35:07 +0100 (BST) Received: from [138.89.132.102] (helo=LENNHOFF-PEXI.foo.bar) by 64.125.181.59 with asmtp (TLSv1:RC4-SHA:128) id 1CJNMT-00066X-00; Sun, 17 Oct 2004 22:35:01 -0400 Message-Id: <6.0.2.0.0.20041017223157.041f33b8@localhost> Date: Sun, 17 Oct 2004 22:34:59 -0400 To: Tom Lane From: Larry Lennhoff Subject: Re: Suppressing duplicate key error messages in Cc: pgsql-admin@postgresql.org In-Reply-To: <12835.1098048282@sss.pgh.pa.us> References: <6.0.2.0.0.20041016212538.01b2d7f8@localhost> <4602.1097985573@sss.pgh.pa.us> <6.0.2.0.0.20041017071206.01e9f870@localhost> <12835.1098048282@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/211 X-Sequence-Number: 15204 At 05:24 PM 10/17/2004, Tom Lane wrote: >Larry Lennhoff writes: > > Is there any way to suppress this message so that it won't appear in the > > log? I looked at the documentation and log_min_error_statement looked > > promising. I set it to panic, but the messages continue. What am I doing > > wrong? > >[ slightly more awake now ... ] Actually, PANIC is already the default >value of log_min_error_statement. I think what you want is >log_min_messages. Hi In release 7.3 log_min_messages is called server_min_messages. and setting that to log and then doing a pg_ctl restart cleared the problem right up. Thanks for your help Larry