pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex <alex.thegreat@ambix.net>
To: pgsql-sql@postgresql.org
Subject: Error:  Template Id should be teh identifier of a template - help
Date: Fri, 17 Aug 2012 09:58:25 -0600
Message-ID: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net> (raw)


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

view thread (3+ messages)  latest in thread

Message-ID: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>
Permalink:  ../EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net/
Also on:    postgresql.org/message-id/EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net

 · 

reply

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: alex.thegreat@ambix.net
  Subject: Re: Error:  Template Id should be teh identifier of a template - help
  In-Reply-To: <EBCBA6B9-F98A-48CE-B9EB-DAE6EEA756FD@ambix.net>

* 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