From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alex <alex(dot)thegreat(at)ambix(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Error: Template Id should be teh identifier of a template - help |
Date: | 2012-08-17 17:28:58 |
Message-ID: | 17350.1345224538@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Alex <alex(dot)thegreat(at)ambix(dot)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 | Date | Subject | |
---|---|---|---|
Next Message | Gary Stainburn | 2012-08-20 12:17:46 | generated dates from record dates - suggestions |
Previous Message | David Johnston | 2012-08-17 16:18:16 | Re: Error: Template Id should be teh identifier of a template - help |