triggers

From: "paul butler" <polb(at)cableinet(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: triggers
Date: 2002-04-22 07:30:31
Message-ID: T5a692de92fac1785ec0c4@pcow034o.blueyonder.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Dear list,
Just starting out with postgresql, I've got a 18 table db listing info
on organisations and on the main organisation table I've got an
update column (timestamp), to keep a record of the last time
information was updated for each organisation.
Obviously I can do it on the client app, but I think table /row
triggers might be a better solution
is there a straight forward way of, on updating any of the
organisation tables I can update the update column for that
organisation?

eg On update orgsubtable wher orgId = X
trigger update orgMainTable.timestamp Values(now()) where
orgId = X

TIA

Paul Butler

Sorry about the previous post

Browse pgsql-novice by date

  From Date Subject
Next Message pdg 2002-04-22 07:41:42 Re: [NOVICE] Hardware needed for 15,000,000 record DB?
Previous Message paul butler 2002-04-22 07:26:34 triggers