Обсуждение: Error Message: ERROR: parser: parse error at or near "Desc"
-- 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"
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"
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 >
> -----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.
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