Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A20B42E2D6B for ; Thu, 15 Nov 2007 11:28:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45437-05 for ; Thu, 15 Nov 2007 11:28:28 -0400 (AST) Received: from node3.bonn.de (bonngw.bonn.de [212.79.173.49]) by postgresql.org (Postfix) with ESMTP id 4BD912E2D6A for ; Thu, 15 Nov 2007 11:28:27 -0400 (AST) Received: from mx2.bonn.de by node3.bonn.de via smtpd (for postgresql.org [200.46.204.71]) with ESMTP; Thu, 15 Nov 2007 16:17:52 +0100 Received: Received by internal MTA Received: Received by internal MTA Received: from (unknown [10.81.1.77]) by SV5104.bonn.de with smtp id 55be_afe5695c_9397_11dc_a2a9_0014221da358; Thu, 15 Nov 2007 17:27:41 +0100 Received: Received by internal MTA Message-ID: <1C2329C9430609409808ECF10237287612EA4CC7@mydomain.com> From: =?iso-8859-1?Q?=22K=F6nig=2C_Monika=22?= To: "'pgsql-admin@postgresql.org'" Subject: trigger ddl actions in a table Date: Thu, 15 Nov 2007 16:29:51 +0100 MIME-Version: 1.0 X-Mailer: internal Mail Client Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Header-Manager: Changed by NetCon X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/141 X-Sequence-Number: 27384 I need a way for logging every action on the system catalog. I must = have a table which shows when a tables was created or updated or deleted. I = need the date of the change . I tried to make an trigger on pg_catalog.pg_class but this throws an = error : "ERROR: permission denied: "pg_class" is a system catalog". I can see all ddl in my log files, but=20 - there are even the errors in and=20 - i can't use it for a select Is there an possibility for having such an system-action table?? Thanks Monika K=F6nig