7.4.1 template1 - Mailing list pgsql-novice

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