-- System Information -- Platform: Windows 2000 Version: 5.0 Build: 2195 Service Pack 3
-- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 7.1.0 Descripton: PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 -- Driver Information -- Name: PostgreSQL Version: 7.3.100 Descripton: PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 -- Error Information -- Description: ERROR: parser: parse error at or near "Desc" Number: -2147467259 Routine: pgAdmin II:frmSQLOutput.cmdSave_Click ************************************************************ Insert your comment: If the column have a name "Desc", the update query don't use double quote. 24/09/03 11.19.59 - SQL (xaetdb): SELECT count(*) AS count FROM "ApplicationParams" WHERE "Application" = 'AcdBase' AND "Name" = 'QueueMsg1' AND "Value" = 'Coda1.wav' AND Type = 'Text' AND Desc = '1 Msg della coda' AND "Family" = 'Messages' AND "Specific" = 'Default' AND "Advanced" = '0' 24/09/03 11.19.59 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR: parser: parse error at or near "Desc" ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match