[drupal-devel] [bug] pgsql _db_query() shows each query error twice

[danielc]

Issue status update for http://drupal.org/node/19942

 Project:      Drupal
 Version:      cvs
 Component:    database system
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  danielc
 Updated by:   danielc
 Status:       patch

Add "pgsql" to title.


Test script:




danielc



Previous comments:
------------------------------------------------------------------------

April 3, 2005 - 23:27 : danielc

Attachment: http://drupal.org/files/issues/database.silence.query.diff (1.2 KB)

In _db_query(), when a query error happens, the error messages are
displayed twice.  First at the point of the pg_query()/mysql_query()
call and then at the track_errors() call.  Since there is an error
handling/reporting process in place, the query calls should suppress
error output by placing @'s in front of them.  The attached patch does
that for both the database.mysql.inc and database.pgsql.inc files.




------------------------------------------------------------------------

April 7, 2005 - 19:43 : danielc

Can this please be applied to 4-6 and HEAD?




------------------------------------------------------------------------

April 8, 2005 - 06:41 : Dries

How can we reproduce this?  No matter what I do, I only see each error
reported once.  


(We try to avoid the use of @ to surpress errors.)




------------------------------------------------------------------------

April 8, 2005 - 08:36 : danielc

Ah!  It's just happening with PostgreSQL.  I noticed it there and
assumed the same issue existed with MySQL.  Sorry for the confusion. 
Please commit to database.pgsql.inc only.