X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 2902311F65F6 for ; Thu, 20 Apr 2006 19:42:17 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.451 X-Spam-Level: X-Spam-Status: No, score=-2.451 required=5 tests=[AWL=0.148, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id CX8Bwx2bcCfX for ; Thu, 20 Apr 2006 19:42:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id D5C8211F65EA for ; Thu, 20 Apr 2006 19:42:08 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id C2DF156431; Thu, 20 Apr 2006 17:42:08 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 20 Apr 2006 17:42:08 -0500 Date: Thu, 20 Apr 2006 17:42:08 -0500 From: "Jim C. Nasby" To: G?briel ?kos Cc: "pgsql-admin@postgresql.org" Subject: Re: Notification of database changes Message-ID: <20060420224207.GN49405@pervasive.com> References: <443CD180.2020704@i-logic.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <443CD180.2020704@i-logic.hu> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060420:akos.gabriel@i-logic.hu::6jqSv69LneLHnEfi:00000000000000 00000000000000000000000018XE X-Hashcash: 1:20:060420:pgsql-admin@postgresql.org::DEV1lu01DAjbEc/D:00000000000 0000000000000000000000005Gt/ X-Archive-Number: 200604/203 X-Sequence-Number: 21372 No, there is currently no support for DDL triggers, though I believe it is on the TODO list... On Wed, Apr 12, 2006 at 12:08:00PM +0200, G?briel ?kos wrote: > Hi, > > Is there a convenient method to let one know if something in the > database changes (DDL-level). > > Background: we have here several developers, and want to know is > somebody changes on the DDL-level something in the database. > We could communicate this manually of course, but if there is a > simple-to-implement automatic method (via e-mail for example) then it > would be very handy for us. > > Thanks in advance, > Akos > > > -- > ?dv?zlettel, > G?briel ?kos > -=E-Mail :akos.gabriel@i-logic.hu|Web: http://www.i-logic.hu=- > -=Tel/fax:+3612367353 |Mobil:+36209278894 =- > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461