From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Judith <jaltamirano@correolux.com.mx>
Cc: pgsql-sql@postgresql.org
Subject: Re: Update in all tables
Date: Wed, 22 Feb 2006 13:12:10 -0600
Message-ID: <1140635530.5777.32.camel@state.g2switchworks.com> (raw)
In-Reply-To: <43FCA8B0.3050803@correolux.com.mx>
References: <43FCA8B0.3050803@correolux.com.mx>
On Wed, 2006-02-22 at 12:08, Judith wrote:
> Hello everybody I need to update a field with the same value in the
> tables of my data base but this field exists in almost all tables and
> has the same value, I don't want to code a script, so my question is if
> there is some way to update that field with a query and affects all the
> tables that contain the field?
Are those fields all dependent FK fields? If so, then declaring those
foreign keys as on update cascade is all you need.
If they're not related that way, then you'll have to script it.
If you need them all to change at the same time (or all roll back in the
event of an update failure) then you can wrap the changes in a
transaction (begin/end pair) and it'll be atomic.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: smarlowe@g2switchworks.com, jaltamirano@correolux.com.mx
Subject: Re: Update in all tables
In-Reply-To: <1140635530.5777.32.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox