Re: --single-transaction hack to pg_upgrade does not work

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Andres Freund <andres@2ndquadrant.com>, Bruce Momjian <bruce@momjian.us>, pgsql-hackers@postgreSQL.org
Date: 2012-12-01T17:06:02Z
Lists: pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Does this actually get you over the problem identified in the comment?:

>   * We disallow this in transaction blocks, because we can't cope
>   * with enum OID values getting into indexes and then having their
>   * defining pg_enum entries go away.

Why wouldn't it?  If the enum type was created in the current xact, then
surely any table columns of the type, or a fortiori indexes on the type,
were also created in the current xact and they'd all go away on abort.

			regards, tom lane


Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. In pg_upgrade, dump each database separately and use