Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T2QM3-0000ao-AP for pgsql-sql@postgresql.org; Fri, 17 Aug 2012 17:29:03 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T2QM1-0006nk-H1 for pgsql-sql@postgresql.org; Fri, 17 Aug 2012 17:29:02 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q7HHSx1P017351; Fri, 17 Aug 2012 13:28:59 -0400 (EDT) From: Tom Lane To: Alex cc: pgsql-sql@postgresql.org Subject: Re: Error: Template Id should be teh identifier of a template - help In-reply-to: References: Comments: In-reply-to Alex message dated "Fri, 17 Aug 2012 09:58:25 -0600" Date: Fri, 17 Aug 2012 13:28:58 -0400 Message-ID: <17350.1345224538@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201208/18 X-Sequence-Number: 36789 Alex writes: > When I execute this: > UPDATE HTMLPAGE SET PAGE_URL = REPLACE(PAGE_URL, '.dot', '.html') > WHERE PAGE_URL LIKE '%.dot'; > I get the following error from psql. Could you tell me what is wrong > or how to fix it? >> Failed to execute SQL : SQL UPDATE HTMLPAGE SET PAGE_URL = >> REPLACE(PAGE_URL, '.dot', '.html') WHERE PAGE_URL LIKE '%.dot'; >> failed : ERROR: Template Id should be the identifier of a template That is not any built-in Postgres error message. Perhaps it is coming from a trigger function or some such? In any case, we can't help you. You need to identify what layer of software it's coming from, and complain to the appropriate people. regards, tom lane