I wrote: > I think it'd be a lot safer to modify (or just remove) the test in > pg_upgrade. It looks like a one-liner: Specifically, the attached patch takes care of the problem. Thanks for reporting it! regards, tom lane diff --git a/contrib/pg_upgrade/check.c b/contrib/pg_upgrade/check.c index 9690695..93b9e69 100644 *** a/contrib/pg_upgrade/check.c --- b/contrib/pg_upgrade/check.c *************** check_for_prepared_transactions(ClusterI *** 532,538 **** res = executeQueryOrDie(conn, "SELECT * " ! "FROM pg_catalog.pg_prepared_xact()"); if (PQntuples(res) != 0) pg_log(PG_FATAL, "The %s cluster contains prepared transactions\n", --- 532,538 ---- res = executeQueryOrDie(conn, "SELECT * " ! "FROM pg_catalog.pg_prepared_xacts"); if (PQntuples(res) != 0) pg_log(PG_FATAL, "The %s cluster contains prepared transactions\n", -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
