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

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

From

"Aldo Tomasich"

Date:

24 September 2003, 13:29:44

-- 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"

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

From

"Hiroshi Saito"

Date:

24 September 2003, 17:24:10

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"

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

From

"Hiroshi Saito"

Date:

24 September 2003, 17:51:27

Oh Sorry.
patch is wrong.!!
Wait for a while now.

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Hiroshi Saito" <saito@inetrt.skcapi.co.jp>
To: "Aldo Tomasich" <aldo.tomasich@et-spa.com>
Cc: "frank_lupo" <frank_lupo@email.it>; "Dave Page" <dpage@vale-housing.co.uk>; <pgadmin-support@postgresql.org>
Sent: Thursday, September 25, 2003 2:18 AM
Subject: Re: [pgadmin-support] 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"
> 


--------------------------------------------------------------------------------


> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

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

From

"Dave Page"

Date:

24 September 2003, 18:14:27


> -----Original Message-----
> From: Hiroshi Saito [mailto:saito@inetrt.skcapi.co.jp]
> Sent: 24 September 2003 18:47
> To: Aldo Tomasich
> Cc: frank_lupo; Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Error Message: ERROR: parser:
> parse error at or near "Desc"
>
>
> Oh Sorry.
> patch is wrong.!!
> Wait for a while now.

Yes, fmtID should take care or reserved words. There's a silly bug in it
which I've just fixed.

Regards, Dave.

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

From

"Hiroshi Saito"

Date:

24 September 2003, 18:44:32

From: "Dave Page" <dpage@vale-housing.co.uk>

> Yes, fmtID should take care or reserved words. There's a silly bug in it
> which I've just fixed.

Ah..

Thanks.
It was repaired now and tested.:-)

Regards,
Hiroshi Saito