| From: | pgsql-bugs(at)postgresql(dot)org |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug #912: pg_restore cannot restore individual rule from custom dump |
| Date: | 2003-03-17 19:27:19 |
| Message-ID: | 20030317192719.56198475AE5@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Joseph Tate (jtate(at)mi-corporation(dot)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 to restoring rules.
Sample Code
No file was uploaded with this report
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-03-17 19:41:29 | Re: Problem with RULE to update tables |
| Previous Message | pgsql-bugs | 2003-03-17 19:03:48 | Bug #911: pg_dump/pg_restore fails when using triggers/rules on tables including large objects |