<p><font face="Arial" size="2">I am using pgAdmin III, PostgreSQL tools, Version 1.2.0 Beta on Windows XP
Pro.</font><p><fontface="Arial" size="2">The following query, when executed as a stand alone query returns an error,
correctly,that the column name is not valid:</font><p><font face="Arial" size="2">Query A) Select patientorder_key from
patientorderwhere visit_key = 250314 and provider_key = 301;</font><p><font face="Arial" size="2">The correct syntax
shouldbe:</font><br /><font face="Arial" size="2">Query B) Select patientorder.key from patientorder where visit_key =
250314and provider_key = 301;</font><p><font face="Arial" size="2">However, when the query with the incorrect column
name(Query A) is embedded in a where clause, column validation does not happen, no error is displayed, and PGAdmin
apparentlyignores the where clause all together, resulting in complete data deletion, as if there were no where
clause:</font><p><fontface="Arial" size="2">Begin;</font><br /><font face="Arial" size="2">Delete from testorder where
patientorder_keyin </font><br /><font face="Arial" size="2">(Select patientorder_key from patientorder where visit_key
=250314 and provider_key = 301);</font><br /><font face="Arial" size="2">End;</font><p><font face="Arial" size="2">This
resultedin massive amounts of data being deleted erroneously.</font><p><font face="Arial" size="2">I believe this is a
bug.</font><p><b><fontface="Arial">Lori E. Pate</font></b><br /><font face="Arial"> </font><br /><font
face="Arial">QualityAssurance Engineer</font><br /><font face="Arial">Opus Healthcare Solutions, Inc.</font><br /><font
face="Arial">12301Research Blvd.</font><br /><font face="Arial">Bldg. IV, Suite 200</font><br /><font
face="Arial">Austin,Texas 78759</font><br /><font face="Arial"> </font><br /><font face="Arial">Phone:
512.336.4562</font><br/><font face="Arial">E-Mail: </font><a href="mailto:lpate@opushealthcare.com"><u><font
color="#0000FF"face="Arial">lpate@opushealthcare.com</font></u></a><br /><font face="Arial">AIM: loripate0508</font><br
/><ahref="http://www.opushealthcare.com/"><u><font color="#0000FF" face="Times New
Roman">http://www.opushealthcare.com/</font></u></a><br/><font face="Arial"> </font>