Re: 7.4.1 template1

Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni.ruuhimaki@kymi.com> writes:
> Just noticed that 7.4.1 template1 has 40 views / tables in it and copies all
> of them to new databases.

It's supposed to.

> Tried to DROP them in template1 and in a dummy db
> but got an error e.g.  'table "sql_features" does not exist'

information_schema isn't in your search path by default.

I think most of your confusion stems from using an ancient psql ---
since it's not showing a version number in the welcome banner,
it must be older than 7.3, which means it does not know about schemas.

            regards, tom lane