Oh Sorry. patch is wrong.!! Wait for a while now. Regards, Hiroshi Saito
----- Original Message ----- From: "Hiroshi Saito" <[EMAIL PROTECTED]> To: "Aldo Tomasich" <[EMAIL PROTECTED]> Cc: "frank_lupo" <[EMAIL PROTECTED]>; "Dave Page" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > > (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 [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match