Re: --single-transaction hack to pg_upgrade does not work - Mailing list pgsql-hackers

From Tom Lane
Subject Re: --single-transaction hack to pg_upgrade does not work
Date
Msg-id 4818.1354389209@sss.pgh.pa.us
Whole thread Raw
In response to Re: --single-transaction hack to pg_upgrade does not work  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2012-12-01 13:43:44 -0500, Bruce Momjian wrote:
>> I believe this text in alter_type.sgml need updating:
>> 
>> <command>ALTER TYPE ... ADD VALUE</> (the form that adds a new value to an
>> enum type) cannot be executed inside a transaction block.

> I purposefully didn't change that because the new support is rather
> minimalistic.

Yeah, I tend to agree.  There are a lot of cases that people might think
should work that won't, and anyway it's not clear what the use-case is
for this beyond pg_dump's very specific usage.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: --single-transaction hack to pg_upgrade does not work
Next
From: Tom Lane
Date:
Subject: Re: --single-transaction hack to pg_upgrade does not work