Error Message: ERROR: parser: parse error at or near "Desc"
| От | Aldo Tomasich |
|---|---|
| Тема | Error Message: ERROR: parser: parse error at or near "Desc" |
| Дата | |
| Msg-id | ACEBLCODPJGJPNLKFHBIIEIECDAA.aldo.tomasich@et-spa.com обсуждение исходный текст |
| Список | pgadmin-support |
-- 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"
В списке pgadmin-support по дате отправления: