Re: [SQL] Error: Template Id should be teh identifier of a template - help

2012-08-17 Thread David Johnston
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Alex Sent: Friday, August 17, 2012 11:58 AM To: pgsql-sql@postgresql.org Subject: [SQL] Error: Template Id should be teh identifier of a template - help Hi, All! When I execute this: UPDATE HTMLPAGE SET PA

Re: [SQL] Error: Template Id should be teh identifier of a template - help

2012-08-17 Thread Tom Lane
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 =

[SQL] Error: Template Id should be teh identifier of a template - help

2012-08-17 Thread Alex
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 =