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 по дате отправления: