Re: Bug in pgAdminIII or in pg 8 beta3 ? - Mailing list pgsql-bugs

From Oliver Elphick
Subject Re: Bug in pgAdminIII or in pg 8 beta3 ?
Date
Msg-id 1099576186.5467.21.camel@braydb
Whole thread Raw
In response to Bug in pgAdminIII or in pg 8 beta3 ?  ("Luiz K. Matsumura" <luiz@planit.com.br>)
Responses Re: Bug in pgAdminIII or in pg 8 beta3 ?
List pgsql-bugs
On Thu, 2004-11-04 at 13:06, Luiz K. Matsumura wrote:
> Hi
>
> I think that is can be a bug... When I create a new database in pg8
> beta3 (win32) like this
>
> CREATE DATABASE test
>   WITH OWNER = admin
>        ENCODING = 'UNICODE';
>
> System objects became visible in public schema :
> tables like pg_ts_cfg , pg_ts_cfgmap, pg_ts_dict ...
> functions , operators etc.

I don't think those are system objects, unless they are specific to the
Win32 version.  I believe they are created when you use tsearch2 in a
database.  You must have done that some time in template1.

> but if I create a database from template0 this objects are not visibles
>
> My installation is with problem or this is a bug ?

No bug; these objects exist in the template1 database - someone created
them there - so they get copied into every new database.  This is a
_feature_.  It lets you ensure that every new database contains certain
objects.

If you don't want them in new databases, delete them from template1.

Oliver Elphick

pgsql-bugs by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: Bug in pgAdminIII or in pg 8 beta3 ?
Next
From: Tom Lane
Date:
Subject: Re: could not find /usr/local/timezone