Tim Uckun <timuckun@xxxxxxxxx> writes: > I have a very simple update query. > update cu > set screenshot_file_name = tu.screenshot_file_name, > screenshot_content_type = tu.screenshot_content_type, > screenshot_file_size = tu.screenshot_file_size, > screenshot_status = tu.screenshot_status > from cu > inner join tu on tu.cu_id = cu.id That isn't actually the query you're issuing, because if it were you would get an error "table name "cu" specified more than once". I suspect that the query you're actually issuing involves an unconstrained cartesian product self-join between the target table and another instance of itself. Postgres doesn't consider that the target table should be named again in FROM. But it's hard to be sure about that when looking at a redacted query. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
