NOTICE errors while restoring database.

From: Sanjay Bhatia <sbix(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: NOTICE errors while restoring database.
Date: 2001-12-18 05:02:33
Message-ID: 20011218050233.11796.qmail@web13003.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-12-18 05:50:49 Re: NOTICE errors while restoring database.
Previous Message Tom Lane 2001-12-18 03:39:17 Re: compilation troubles