7.4.1 template1

Hi all,

Just noticed that 7.4.1 template1 has 40 views / tables in it and copies all
of them to new databases. Tried to DROP them in template1 and in a dummy db
but got an error e.g. 'table "sql_features" does not exist'

How to make template1 blank ? Or what is this about ?

BR,

Aarni

bash-2.05a$ /usr/local/pgsql/bin/createdb dummy
CREATE DATABASE
bash-2.05a$ psql dummy
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

dummy=# \d
List of relations
Name | Type | Owner
---------------------------------+-------+----------
applicable_roles | view | postgres
check_constraints | view | postgres
column_domain_usage | view | postgres
column_privileges | view | postgres
column_udt_usage | view | postgres
columns | view | postgres
constraint_column_usage | view | postgres
constraint_table_usage | view | postgres
data_type_privileges | view | postgres
domain_constraints | view | postgres
domain_udt_usage | view | postgres
domains | view | postgres
element_types | view | postgres
enabled_roles | view | postgres
information_schema_catalog_name | view | postgres
key_column_usage | view | postgres
parameters | view | postgres
referential_constraints | view | postgres
role_column_grants | view | postgres
role_routine_grants | view | postgres
role_table_grants | view | postgres
role_usage_grants | view | postgres
routine_privileges | view | postgres
routines | view | postgres
schemata | view | postgres
sql_features | table | postgres
sql_implementation_info | table | postgres
sql_languages | table | postgres
sql_packages | table | postgres
sql_sizing | table | postgres
sql_sizing_profiles | table | postgres
table_constraints | view | postgres
table_privileges | view | postgres
tables | view | postgres
triggered_update_columns | view | postgres
triggers | view | postgres
usage_privileges | view | postgres
view_column_usage | view | postgres
view_table_usage | view | postgres
views | view | postgres
(40 rows)

dummy=# DROP TABLE sql_features;
ERROR: table "sql_features" does not exist
ERROR: table "sql_features" does not exist

--
-------------------------------------------------
Aarni Ruuhimäki | Megative Tmi | KYMI.com