Re: [HACKERS] dump, restore, dump yields differences

2013-03-22 Thread Greg Stark
On Fri, Mar 22, 2013 at 6:49 PM, Tom Lane wrote: > Those are expected. You can trace the ALTER TABLE history of those > tables if you want to see why they're so odd, but basically there > are inheritance situations where it's hard to avoid this. Incidentally it would still be cool to have make c

Re: [HACKERS] dump, restore, dump yields differences

2013-03-22 Thread Tom Lane
Kevin Grittner writes: > As part of testing the matview issues around dumping, I ran `make > installcheck-world`, ran pg_dump to dump the regression database, > loaded it into a new database, dumped the newly restored database, > and compared the output files from the two pg_dump runs.  There > we

[HACKERS] dump, restore, dump yields differences

2013-03-22 Thread Kevin Grittner
As part of testing the matview issues around dumping, I ran `make installcheck-world`, ran pg_dump to dump the regression database, loaded it into a new database, dumped the newly restored database, and compared the output files from the two pg_dump runs.  There were a few somewhat surprising diffe