On Fri, Apr 13, 2012 at 1:28 AM, Merlin Moncure <mmonc...@gmail.com> wrote: > (although > they can be great from reporting or double checking standpoint).
Good point. Double-checking your patch script may well be worth doing. It ought, in theory, be possible to load up a copy of your existing database, spin up a brand new one from the CREATE TABLE script, diff them, and compare against the patch script. Of course, that does run the risk of useless diff noise (for instance, I'll often add a new field into the middle of a table where it most logically fits, but the patch will simply ALTER TABLE to add it at the end), but it could still be a useful check, especially if completely automated. ChrisA -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
