On Thu, Jan 04, 2007 at 11:36:35AM -0500, Tom Lane wrote: > > update clin.episode > > set fk_patient = clin.health_issue.fk_patient > > from clin.health_issue > > where > > clin.episode.fk_patient is NULL and > > clin.episode.fk_health_issue = clin.health_issue.pk; > > > It returns "UPDATE 2" which is what I expect from the data. > > However, the rows in question are not actually updated. > > That seems very strange. Could you perhaps have a BEFORE UPDATE trigger > that's changing the values back to null again? I do but I drop that one in the script before doing the above update. I may have an old one hanging around, though, I'll double-check. Thanks, Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
