NOTICE errors while restoring database.

Поиск
Список
Период
Сортировка
От Sanjay Bhatia
Тема NOTICE errors while restoring database.
Дата
Msg-id 20011218050233.11796.qmail@web13003.mail.yahoo.com
обсуждение исходный текст
Ответы Re: NOTICE errors while restoring database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello.

I am creating a backup of our database using the pg_dump -c command, and that
runs without problems.  However, when I do a restore operation, I get the
following NOTICEs (given below).  I can see that the data is restored as
expected.  Is there a way for me to ignore these messages or not have them show
up?  The pg_dump command exits with a non-zero value when these NOTICEs show up
and this is breaking my program.

Thanks,
sb

NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_task_info"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_task_info"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_difference"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_difference"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_difference_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_difference_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_gen_var_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_gen_var_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_installed_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_installed_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_gen_var_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_gen_var_settings"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_task_info"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_task_info"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_execution_plan"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_resource"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component_definition"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component_definition"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component_definition"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_component_definition"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_permission"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_permission"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_group"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  DROP TABLE implicitly drops referential integrity trigger from table
"rox_user"
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_permission_pkey' for table 'rox_permission'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'rox_user_pkey'
for table 'rox_user'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'rox_group_pkey'
for table 'rox_group'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_group_member_pkey' for table 'rox_group_member'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_parent_child_group_pkey' for table 'rox_parent_child_group'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_group_graph_pkey' for table 'rox_group_graph'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_granted_permission_pkey' for table 'rox_granted_permission'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_resource_pkey' for table 'rox_resource'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_gen_var_settings_pkey' for table 'rox_gen_var_settings'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_component_definition_pkey' for table 'rox_component_definition'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_component_pkey' for table 'rox_component'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_comp_var_settings_pkey' for table 'rox_comp_var_settings'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_execution_plan_pkey' for table 'rox_execution_plan'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_difference_settings_pkey' for table 'rox_difference_settings'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_difference_pkey' for table 'rox_difference'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_criteria_pkey' for table 'rox_criteria'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'rox_action_pkey'
for table 'rox_action'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'rox_rule_pkey'
for table 'rox_rule'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_task_info_pkey' for table 'rox_task_info'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_installed_component_pkey' for table 'rox_installed_component'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_installed_resource_pkey' for table 'rox_installed_resource'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_subplan_info_pkey' for table 'rox_subplan_info'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'rox_host_status_pkey' for table 'rox_host_status'
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'rox_events_pkey'
for table 'rox_events'

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: compilation troubles
Следующее
От: Tom Lane
Дата:
Сообщение: Re: NOTICE errors while restoring database.