Thread: Error: Template Id should be teh identifier of a template - help
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
Alex <alex.thegreat@ambix.net> 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
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@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 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 ============================================================================ == This seems to be an application error and not something PostgreSQL is issuing on its own. The htmlpage table seems to have an update trigger on it that checks for the validity of a template id. Since it is a trigger and not a constraint it is possible/likely the trigger was added without validating existing data. Your update must hit one or more records that do not meet the conditions that the triggers sets forth so the trigger performs a "RAISE ERROR 'Template Id should be the identifier of a template'". You will need to speak with someone responsible for maintaining the database. David J.