The following bug has been logged on the website:
Bug reference: 7615
Logged by: Marko Tiikkaja
Email address: pgmail(at)joh(dot)to
PostgreSQL version: 9.1.6
Operating system: Linux
Description:
Hi,
Doing this:
CREATE TABLE foo(a int);
CREATE TABLE bar(a int);
CREATE RULE bar_rule1 AS ON INSERT TO bar DO ALSO INSERT INTO foo DEFAULT
VALUES;
breaks pg_dump. It outputs the following:
CREATE RULE bar_rule1 AS ON INSERT TO bar DO INSERT INTO foo () VALUES
();
which obviously won't work. :-(