You can use transactions to ensure that either both happen or neither happen
over an arbitrary number of commands.
eg:
BEGIN;
UPDATE x SET a=1;
UPDATE y SET b=2;
COMMIT;
Neither update will be visible to another transaction until the commit and
if there is a crash before the commit it will rollback on restart.
However in your specific case you should just be able to do something like
this:
UPDATE items SET items.price=(SELECT month.price FROM month WHERE
month.id=item.id);
Hope this helps,
- Stuart
(As a side note this looks like a candidate for normalisation, just joining
like so:
SELECT items.*,month.price FROM items INNER JOIN month ON items.id=month.id;
or
SELECT items.*,month.price FROM items,month WHERE items.id=month.id;
(the back end will try and optimise the table join order for this one))
> From: Steve Aulenbach [mailto:aulenbac@ucar.edu]
>
>
> Hi,
>
> Does postgreSQL support atomic multi-table updates? Something like:
>
> update items,month set items.price=month.price where
> items.id=month.id;
>
> We are considering postgreSQL for a project where we would like to be
> able to do this.
>
> Thanks,
> Steve Aulenbach