Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T2Ozc-00082x-Ma for pgsql-sql@postgresql.org; Fri, 17 Aug 2012 16:01:48 +0000 Received: from upwithsocialmedia.com ([192.217.104.86] helo=promomerch1.servername.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1T2Ozb-0004yL-HM for pgsql-sql@postgresql.org; Fri, 17 Aug 2012 16:01:48 +0000 Received: from [186.4.31.36] (port=51684 helo=[192.168.51.8]) by promomerch1.servername.com with esmtpa (Exim 4.77) (envelope-from ) id 1T2OzZ-0001LY-HL for pgsql-sql@postgresql.org; Fri, 17 Aug 2012 16:01:45 +0000 Message-Id: From: Alex To: pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=Apple-Mail-58--307798332 Mime-Version: 1.0 (Apple Message framework v936) Subject: Error: Template Id should be teh identifier of a template - help Date: Fri, 17 Aug 2012 09:58:25 -0600 X-Mailer: Apple Mail (2.936) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - promomerch1.servername.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - ambix.net X-Pg-Spam-Score: 0.8 (/) X-Archive-Number: 201208/17 X-Sequence-Number: 36788 --Apple-Mail-58--307798332 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Hi, All! 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? Thanks, Alex > 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 --Apple-Mail-58--307798332 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable

Hi, = All!

When I execute = this:

UPDATE HTMLPAGE SET = PAGE_URL =3D 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?

Thanks,

Alex

Failed to = execute SQL : SQL UPDATE HTMLPAGE SET PAGE_URL =3D = REPLACE(PAGE_URL, '.dot', '.html') WHERE PAGE_URL LIKE = '%.dot'; failed : ERROR: Template Id should be the = identifier of a = template

= --Apple-Mail-58--307798332--