Hello Nick, Nick Wellnhofer [2010-04-30 19:09 +0200]: > When upgrading a database from 8.3 to 8.4 I got several errors related > to foreign keys. It turned out that I could only upgrade succesfully by > making pg_upgradecluster pass the --disable-triggers option to pg_restore.
Ah, good point, thanks for your report! > It would be nice if a --disable-triggers option could be added to > pg_upgradecluster and passed to pg_restore. In fact, this almost looks like an --unbreak-my-upgrade option. I don't actually see why we would not want this option, since pg_upgradecluster runs pg_restore in a very controlled environment (we guarantee it's running as the DB superuser, and so on). I'll just add it by default. Thanks! Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
