Re: [BUGS] BUG #7521: Cannot disable WAL log while using pg_dump

2012-10-19 Thread Robert Haas
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 repr

Re: [BUGS] BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble

2012-10-19 Thread Tom Lane
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!

[BUGS] BUG #7615: CREATE RULE + DEFAULT VALUES + pg_dump trouble

2012-10-19 Thread pgmail
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); CREA