-- 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
