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.

but if I create a database from template0 this objects are not visibles

My installation is with problem or this is a bug ?

Thanks in advance


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Thu, 2004-11-04 at 13:06, Luiz K. Matsumura wrote:
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.

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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Thu, 2004-11-04 at 13:49, Oliver Elphick wrote:
I believe tsearch2 is part of the install in Magnus' .mxi Windows
Installer version.

As Olly says, not a bug.

--
Best Regards, Simon Riggs


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

It is indeed installed. The activation of the module in 'template1' is
optional and *not* enabled by default, though. But there is a checkbox
for it...

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org