| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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 | Content-Type | Size |
|---|---|---|
| frmSQLOutput_patch | application/octet-stream | 14.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Saito | 2003-09-24 17:29:45 | Re: Error Message: ERROR: Attribute 'cursor' not found |
| Previous Message | Andreas Pflug | 2003-09-24 15:02:54 | Re: [pgadmin-support] Aborted viewing operation |