Bug in psql - Postgresql 7.3.1? - Mailing list pgsql-sql
From | John B. Scalia |
---|---|
Subject | Bug in psql - Postgresql 7.3.1? |
Date | |
Msg-id | 001a01c389b0$e00773a0$2501a8c0@John Whole thread Raw |
Responses |
Re: Bug in psql - Postgresql 7.3.1?
(Bruno Wolff III <bruno@wolff.to>)
Re: Bug in psql - Postgresql 7.3.1? (Wei Weng <wweng@kencast.com>) Re: Bug in psql - Postgresql 7.3.1? (Josh Berkus <josh@agliodbs.com>) Re: Bug in psql - Postgresql 7.3.1? (Tom Lane <tgl@sss.pgh.pa.us>) |
List | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">All,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">I’m not certain if what I’m trying to do is legal, but if I execute a statement like:</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">UPDATE my_table SET field1=’new_value’ AND SET field2=’different_value’ WHERE my_table_id = ‘key’;</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">in psql, it reports that it has successfully updated one record. However, the record does not appear tobe updated when I subsequently issue a SELECT for that record. I’ll buy the fact that I may be using illegal syntax – I’mnot SQL expert, but the update says it worked when in fact it did not. Should this have worked or should it have reportedan error?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">For record, this is Postgresql 7.3.1 on Solaris 9. Problem originally seen during a php4 script, but hasbeen duplicated on the psql command line.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">TIA,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; font-family:Arial">John</span></font></div>