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 BB51A534CC for ; Sat, 14 May 2005 20:00:48 -0300 (ADT) 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 73250-06 for ; Sat, 14 May 2005 23:00:46 +0000 (GMT) Received: from web51009.mail.yahoo.com (web51009.mail.yahoo.com [206.190.39.128]) by svr1.postgresql.org (Postfix) with SMTP id 18F8B5346F for ; Sat, 14 May 2005 20:00:43 -0300 (ADT) Received: (qmail 6154 invoked by uid 60001); 14 May 2005 23:00:45 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=tQoZ/kJnn4t1XAj1y1w/CB8r/NHHXg7c/+69HCbwF7zhogrqPCdJT4um0rWMLX/p479uTBlM+JOf4eLC7eW7HtotNRa4f8I+dHJpZtPHsIfq5HkwRnKAIQRdXO59DVoFDv0nlSJhF1KJWsXcmSkp2yIXbLysvHOv5kv4S/FnUmo= ; Message-ID: <20050514230045.6150.qmail@web51009.mail.yahoo.com> Received: from [65.118.47.99] by web51009.mail.yahoo.com via HTTP; Sat, 14 May 2005 16:00:45 PDT Date: Sat, 14 May 2005 16:00:45 -0700 (PDT) From: S Murthy Kambhampaty Subject: Config option log_statement To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.883 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: X-Archive-Number: 200505/201 X-Sequence-Number: 17630 In postgresql 8.0, "create table <> as ..." statements appear not to logged unless log_statement = 'all' in postgresql.conf. We are trying to reduce noise in the logs from pgAdminIII and phpPgAdmin, but we use a lot of 'create table <> as ...' queries that need to be logged, and their duration tracked. Is there a combination of settings that will do the trick? Can postgresql be upgraded to log "create table <> as ..." statements with log_statment = 'ddl' and/or log_statment = 'mod'? Thanks, Murthy __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail