PK not being restored

Поиск
Список
Период
Сортировка
От Rajdeep Das
Тема PK not being restored
Дата
Msg-id 001901c9f3c9$71601c70$54205550$@das@ontrackindia.com
обсуждение исходный текст
Список pgsql-hackers
<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> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: 8.4RC2 is available
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: PK not being restored