Обсуждение: PK not being restored

<div class="Section1"><p class="MsoNormal">Dear Sir/Madam,<p class="MsoNormal"> <p class="MsoNormal">I am using
postgresqldb server for our production environment. I have created a schema by the name “application”. The public
schemais not being used at all. I have noticed that suddenly, the public schema is having some table definition and a
wholelot of functions. I have no idea where it came from. For you reference I will list the four tables and a couple of
functionsthat has crept in my database’s public schema.<p class="MsoNormal"> <p class="MsoNormal">Tables:<p
class="MsoNormal">pg_ts_cfg<pclass="MsoNormal">pg_ts_cfgmap<p class="MsoNormal">pg_ts_dict<p
class="MsoNormal">pg_ts_parser<pclass="MsoNormal"> <p class="MsoNormal">Functions:<p
class="MsoNormal">_get_parser_from_curcfg<pclass="MsoNormal">_int_contained<p class="MsoNormal"> <p
class="MsoNormal">Theabove extraneous db objects is interfering with the backup and restore of my application’s
database.As a result, when I restore my db, the primary keys are not being restored.<p class="MsoNormal">Kindly
advise.<pclass="MsoNormal"> <p class="MsoNormal">Rajdeep<p class="MsoNormal">Ontrack Systems Ltd.<p
class="MsoNormal">Kolkata,India <p class="MsoNormal"> </div> 

On Tue, Jun 23, 2009 at 2:11 AM, Rajdeep
Das<rajdeep.das@ontrackindia.com> wrote:
> Dear Sir/Madam,
>
>
>
> I am using postgresql db server for our production environment. I have
> created a schema by the name “application”. The public schema is not being
> used at all. I have noticed that suddenly, the public schema is having some
> table definition and a whole lot of functions. I have no idea where it came
> from. For you reference I will list the four tables and a couple of
> functions that has crept in my database’s public schema.
>
>
>
> Tables:
>
> pg_ts_cfg
>
> pg_ts_cfgmap
>
> pg_ts_dict
>
> pg_ts_parser
>

what version postgresql?

the 'ts' stands for 'text search'.  how are the above tables blocking
you from restoring your data?

merlin