Error Message: ERROR: parser: parse error at or near "Desc"

From: "Aldo Tomasich" <aldo(dot)tomasich(at)et-spa(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Error Message: ERROR: parser: parse error at or near "Desc"
Date: 2003-09-24 09:24:34
Message-ID: ACEBLCODPJGJPNLKFHBIIEIECDAA.aldo.tomasich@et-spa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aldo Tomasich 2003-09-24 09:32:14 Error Message: ERROR: Attribute 'cursor' not found
Previous Message Dave Page 2003-09-24 07:23:58 Re: [pgadmin-support] Aborted viewing operation