I would suggest you 2 solutions:
1. to use a function to edit these fields. That way you will be sure
that you will not forget to update both tables.
2. use a trigger on master table. If I understand you - the history
table could be filled using trigger, when data in master table changes.
That way you could change only master table in your application.
> Hello Gurus,
> Is it possible to update two table using single sql statement? huh?
> let me be clear
> I have table master with state and date field. And in history table I
> have same fields i.e., state and date. I'm writing an update statement
> to set 'open' state records to 'closed' state after 7. both table can
> be joined using id.
> Any thoughts?
Programavimo skyriaus vadovas
In response to
pgsql-admin by date
|Next:||From: Jagadeesh||Date: 2008-10-10 07:46:40|
|Subject: Re: how to invoke edtor?|
|Previous:||From: Joshua Drake||Date: 2008-10-10 05:53:51|
|Subject: Re: can I update multiple table at a time?|