new databases using a template.

Hi,
I'm trying to create a new database by using a template database. But it is not possible. The error code is that some one is using the template, but no one is using it.
I'm using PgAdmin III ver 1.1.0. Has some one seen something like this?
/Paul

________________________________
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Rob Richardson
Sent: den 28 februari 2011 16:19
To: pgsql-general(at)postgresql(dot)org
Cc: Tim Kelly
Subject: Re: [GENERAL] Thoroughly confused about time zones

I think maybe I'm making things much more difficult than they need to be. I tried this:

select cast (extract(epoch from ('2010-3-14 12:00'::timestamp - '2010-3-13 12:00'::timestamp)) as integer) / 60 / 60

and got 24. The difference between timestamps without time zones is 24 hours, even though the interval spanned a time change.

But when I tried this:

select cast (extract(epoch from ('2010-3-14 12:00'::timestamptz - '2010-3-13 12:00'::timestamptz)) as integer) / 60 / 60

I got 23, showing that even if I did not specify what time zone I'm talking about, I got the correct answer.

RobR