On Wed, 8 Oct 2003, Josh Berkus wrote:
> > UPDATE commit_log_ports_elements X
IIRC, PostgreSQL doesn't like aliases of the
update table, so I think you'll need to spell it
out in the WHERE.
> > SET X.needs_refresh = CLP.needs_refresh,
> > X.port_version = CLP.port_version,
> > X.port_revision = CLP.port_revision
I don't think you need the X.'s here anyway, there's
only one update table.