BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      7615
Logged by:          Marko Tiikkaja
Email address:      pgmail@joh.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. :-(