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
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 |