Greg Caulton, 10.09.2010 11:46:
delete from form_record_details where form_record_id in (select form_record_id
from forms where form_id= 40003656)
Seems fine at 1am.
However the subquery has a typo in it - there is no form_record_id in the forms
table
But rather than psql throwing an error...
it deletes every row in the form_record_details table
please tell me this is fixed since 8.3
This is not a bug.
I assume there is a form_record_id in the table form_record_details. As you have not used
table prefixes or aliases, you are simply referencing the form_record_id from the
"outer" table in the subquery.
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
