Musings on Triggers

From: Joshua Kramer <josh(at)bitbuckets(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Musings on Triggers
Date: 2005-12-06 15:49:31
Message-ID: Pine.LNX.4.63.0512061045520.4944@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Greetings all,

Can anyone recommend a tutorial on writing triggers, aside from what's in
the documentation?

Can a trigger in a table in Database_A alter/insert data in a table in
Database_B?

Can I write a trigger such that, it runs on every insert into Table_A, and
inserts a subset of fields of this insert into Table_B, but if this is not
successful, then the insert on Table_A also fails?

Thanks
-Josh

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2005-12-06 16:36:45 Re: Musings on Triggers
Previous Message Charley Tiggs 2005-12-06 15:42:11 Re: SQL Statement Help Needed