Error: Template Id should be teh identifier of a template - help - Mailing list pgsql-sql

From Alex
Subject Error: Template Id should be teh identifier of a template - help
Date
Msg-id EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net
Whole thread Raw
Responses Re: Error: Template Id should be teh identifier of a template - help
Re: Error: Template Id should be teh identifier of a template - help
List 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

pgsql-sql by date:

Previous
From: "David Johnston"
Date:
Subject: Re: [GENERAL] Indexing question
Next
From: Tom Lane
Date:
Subject: Re: Error: Template Id should be teh identifier of a template - help