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

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

From: "Hiroshi Saito" <saito(at)inetrt(dot)skcapi(dot)co(dot)jp>
To: "Aldo Tomasich" <aldo(dot)tomasich(at)et-spa(dot)com>
Cc: "frank_lupo" <frank_lupo(at)email(dot)it>,"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Error Message: ERROR: parser: parse error at or near "Desc"
Date: 2003-09-24 17:18:53
Message-ID: 015301c382bf$ee64be50$1f324d80@w2k (view raw or flat)
Thread:
Lists: pgadmin-support
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(dot)tomasich(at)et-spa(dot)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"

Attachment: frmSQLOutput_patch
Description: application/octet-stream (14.7 KB)

In response to

Responses

pgadmin-support by date

Next:From: Hiroshi SaitoDate: 2003-09-24 17:29:45
Subject: Re: Error Message: ERROR: Attribute 'cursor' not found
Previous:From: Andreas PflugDate: 2003-09-24 15:02:54
Subject: Re: [pgadmin-support] Aborted viewing operation

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