From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alex <alex.thegreat@ambix.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Error: Template Id should be teh identifier of a template - help
Date: Fri, 17 Aug 2012 13:28:58 -0400
Message-ID: <17350.1345224538@sss.pgh.pa.us> (raw)
In-Reply-To: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>
References: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, alex.thegreat@ambix.net
Subject: Re: Error: Template Id should be teh identifier of a template - help
In-Reply-To: <17350.1345224538@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox