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

Dear Aldo.

Though it is a reservation word, you must be able to use it with QUOTE.
Do you apply this patch, and can you try it?

frank will apply it soon.
Or Dave.

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Aldo Tomasich" <aldo.tomasich@et-spa.com>


(snip)
> 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"