[BUGS] BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble
The following bug has been logged on the website: Bug reference: 7615 Logged by: Marko Tiikkaja Email address: pgm...@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. :-( -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble
pgm...@joh.to writes: > Doing this: > 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 > (); Ooops :-(. Will fix, thanks for the report! regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #7521: Cannot disable WAL log while using pg_dump
On Thu, Oct 18, 2012 at 3:18 PM, Gezeala M. Bacuño II wrote: > You may disable full_page_writes, but as you can see from my previous > post, disabling it did not do the trick. My zfs' USED property > continues to increase. I think we need somebody to compile with WAL_DEBUG defined and try to reproduce this with wal_debug = on. Then we will find out what WAL records are being emitted, which will presumably give us a clue as to what is really happening here. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
