Skip site navigation (1) Skip section navigation (2)

Inherting triggers

From: Dev <dev_hyd2001(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Inherting triggers
Date: 2008-09-10 08:02:34
Message-ID: (view raw or whole thread)
Lists: pgsql-novice

        I have a special schema created with a database definition which I use to create new databases in postgres. This schema also has a trigger definition. When databases are created using this schema , the triggers also get created but if in the future I want to modify the trigger, how does that work ? Will the trigger have to be modified in every database that was created using this schema or will just modifying the trigger in the main schema automatically modify the trigger in all the databases which were ever created using this schema ?



pgsql-novice by date

Next:From: Steve TDate: 2008-09-10 10:20:16
Subject: Re: Dump/Restore compatibility
Previous:From: Bram Van SteenlandtDate: 2008-09-10 07:49:27
Subject: Re: translation question

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group