How to do a cascading update?
<p>I have a group of tables with columns that have foreign key constraints on a user name column in another table. I've been instructed not to add <code>ON UPDATE CASCADE</code> to the table definition because we don't want to silently lose information from things like activity logs. We only want to explicitly cascade in this one instance. I haven't been able to find an example of how to do it in a query though. I'm thinking it would look something like</p>

<pre><code>UPDATE CASCADE "MySchema"."MyTable"
SET user_name = "John Smith"
WHERE user_id = 1
</code></pre>

<p>Is this possible?</p>