Dan,
> UPDATE commit_log_ports_elements X
> SET X.needs_refresh = CLP.needs_refresh,
> X.port_version = CLP.port_version,
> X.port_revision = CLP.port_revision
FROM commit_log_ports CLP
WHERE X.commit_log_id = CLP.commit_log_id
You can always ask this kind of thing on IRC .....
--
-Josh BerkusAglio Database SolutionsSan Francisco