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

From: Alex <alex(dot)thegreat(at)ambix(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Error: Template Id should be teh identifier of a template - help
Date: 2012-08-17 15:58:25
Message-ID: EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Johnston 2012-08-17 16:18:16 Re: Error: Template Id should be teh identifier of a template - help
Previous Message Andreas Kretschmer 2012-08-14 17:33:38 Re: Indexing question