Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group