pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedError: Template Id should be teh identifier of a template - help
3+ messages / 3 participants
[nested] [flat]
* Error: Template Id should be teh identifier of a template - help
@ 2012-08-17 15:58 Alex <alex.thegreat@ambix.net>
0 siblings, 2 replies; 3+ messages in thread
From: Alex @ 2012-08-17 15:58 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Error: Template Id should be teh identifier of a template - help
@ 2012-08-17 16:18 David Johnston <polobo@yahoo.com>
parent: Alex <alex.thegreat@ambix.net>
1 sibling, 0 replies; 3+ messages in thread
From: David Johnston @ 2012-08-17 16:18 UTC (permalink / raw)
To: 'Alex' <alex.thegreat@ambix.net>; pgsql-sql
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Error: Template Id should be teh identifier of a template - help
@ 2012-08-17 17:28 Tom Lane <tgl@sss.pgh.pa.us>
parent: Alex <alex.thegreat@ambix.net>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2012-08-17 17:28 UTC (permalink / raw)
To: Alex <alex.thegreat@ambix.net>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-08-17 17:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-17 15:58 Error: Template Id should be teh identifier of a template - help Alex <alex.thegreat@ambix.net>
2012-08-17 16:18 ` Re: Error: Template Id should be teh identifier of a template - help David Johnston <polobo@yahoo.com>
2012-08-17 17:28 ` Re: Error: Template Id should be teh identifier of a template - help Tom Lane <tgl@sss.pgh.pa.us>
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