Re: Error Message: ERROR: parser: parse error at or near "Desc"
От | Hiroshi Saito |
---|---|
Тема | Re: Error Message: ERROR: parser: parse error at or near "Desc" |
Дата | |
Msg-id | 020901c382c3$d875ac90$1f324d80@w2k обсуждение исходный текст |
Ответ на | Error Message: ERROR: parser: parse error at or near "Desc" ("Aldo Tomasich" <aldo.tomasich@et-spa.com>) |
Список | pgadmin-support |
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 >
В списке pgadmin-support по дате отправления: