Bug #912: pg_restore cannot restore individual rule from custom dump - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #912: pg_restore cannot restore individual rule from custom dump
Date
Msg-id 20030317192719.56198475AE5@postgresql.org
Whole thread Raw
List pgsql-bugs
Joseph Tate (jtate@mi-corporation.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
pg_restore cannot restore individual rule from custom dump

Long Description
pg_restore can restore individual triggers and tables, but cannot restore individual rules.  I tried using the -T
option,but it did not restore the rule.  Output:
 
$ pg_restore -h localhost -U webuser -s -T au_u_session_data -S postgresql -vd CUST_4 4-1047690019
pg_restore: connecting to database for restore
pg_restore: implied data-only restore

The rule is not restored.  I looked through the documentation upto and including 7.4-devel but saw no other references
torestoring rules. 

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #911: pg_dump/pg_restore fails when using triggers/rules on tables including large objects
Next
From: Tom Lane
Date:
Subject: Re: Problem with RULE to update tables