DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language;
	b=xEKqAeX4WVLvHAs98QqbNK49eobxs19PNOhcndD16BxrqoVRbKEtRr0eAMKkhIa2utjnQprzQ3Qy2okq+iKUMELMUsNp2Z+r5cCnVmz7EmPr4dIrMwmqEOpE0q2uYlDKNLPnyxg9X5rQgV3ctCf7FFDKWIx4kYkD4Bak+cVXfx0=
	;
From: "David Johnston" <polobo@yahoo.com>
To: "'Alex'" <alex.thegreat@ambix.net>, <pgsql-sql@postgresql.org>
References: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>
In-Reply-To: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>
Subject: Re: Error: Template Id should be teh identifier of a template - help
Date: Fri, 17 Aug 2012 12:18:16 -0400
Message-ID: <008201cd7c93$e8c0d240$ba4276c0$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: AQHKa+DWRGy+d6SMNXh0D8PTX27DfJdkTrfw
Content-Language: en-us

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 =3D REPLACE(PAGE_URL, '.dot', '.html') =
WHERE
PAGE_URL LIKE '%.dot';

I get the following error from psql. =A0Could you tell me what is wrong =
or how
to fix it?

Thanks,

Alex
Failed to execute SQL : SQL=A0UPDATE HTMLPAGE SET PAGE_URL =3D =
REPLACE(PAGE_URL,
'.dot', '.html') WHERE PAGE_URL LIKE '%.dot';=A0failed :=A0ERROR: =
Template Id
should be the identifier of a template


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D
=3D=3D

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.