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

From Simon Riggs
Subject Re: Bug in pgAdminIII or in pg 8 beta3 ?
Date
Msg-id 1099603375.5682.39.camel@localhost.localdomain
Whole thread Raw
In response to Re: Bug in pgAdminIII or in pg 8 beta3 ?  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-bugs
On Thu, 2004-11-04 at 13:49, Oliver Elphick wrote:
> 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.
>

I believe tsearch2 is part of the install in Magnus' .mxi Windows
Installer version.

As Olly says, not a bug.

--
Best Regards, Simon Riggs

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: a bug in plpgsql
Next
From: "Magnus Hagander"
Date:
Subject: Re: Bug in pgAdminIII or in pg 8 beta3 ?