tables in public

Started by Zlatko Matićover 20 years ago5 messagesgeneral
Jump to latest
#1Zlatko Matić
zlatko.matic1@sb.t-com.hr

Hello.

Postgres automatically included some tables in my public domain:
pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser, spatial_ref_sys.
I suppose it's because I switched on all additional options during initdb...

My question regarding those tables is wheter I can delete them safely from public ?

Zlatko

#2Magnus Hagander
magnus@hagander.net
In reply to: Zlatko Matić (#1)
Re: tables in public

Hello.

Postgres automatically included some tables in my public domain:
pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,

I beleive these are from tsearch2.

spatial_ref_sys.

And this is postgis.

I suppose it's because I switched on all additional options
during initdb...

Yes (this is win32 MSI installer, right?)

My question regarding those tables is wheter I can delete
them safely from public ?

Yes, unless you plan to use any of the functionality of those modules.

//Magnus

#3Zlatko Matić
zlatko.matic1@sb.t-com.hr
In reply to: Magnus Hagander (#2)
Re: tables in public

Could you, please, give me short description of functionalities of those
modules?
I don't know whether I need it, because I don't know what is the purpose of
those tables...

----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>;
<pgsql-general@postgresql.org>
Sent: Saturday, August 06, 2005 9:28 PM
Subject: RE: [GENERAL] tables in public

Hello.

Postgres automatically included some tables in my public domain:
pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,

I beleive these are from tsearch2.

spatial_ref_sys.

And this is postgis.

I suppose it's because I switched on all additional options
during initdb...

Yes (this is win32 MSI installer, right?)

My question regarding those tables is wheter I can delete
them safely from public ?

Yes, unless you plan to use any of the functionality of those modules.

//Magnus

#4Magnus Hagander
magnus@hagander.net
In reply to: Zlatko Matić (#3)
Re: tables in public

Could you, please, give me short description of
functionalities of those modules?

tsearch2 is full text indexing. postgis is geographical functionality.

//Magnus

#5Zlatko Matić
zlatko.matic1@sb.t-com.hr
In reply to: Magnus Hagander (#4)
Re: tables in public

OK.thanks...I suppose I don't need it.

----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>;
<pgsql-general@postgresql.org>
Sent: Saturday, August 06, 2005 9:55 PM
Subject: RE: [GENERAL] tables in public

Could you, please, give me short description of
functionalities of those modules?

tsearch2 is full text indexing. postgis is geographical functionality.

//Magnus