Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction
Date
Msg-id fcd89ae4-706c-65d5-b803-c84d0498b98b@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Tree view 
On 9/13/17 09:56, Alvaro Herrera wrote:
> Tom Lane wrote:
>> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> 
>>> - Disallow DROP SUBSCRIPTION in a transaction under certain
>>> circumstances, for example if a transaction has previously manipulated
>>> the same subscription.
> 
>> ISTM the second of those (refuse to drop an in-use subscription) is
>> by far the least surprising behavior.
> 
> +1 for that option.  IIRC this has precedent for other object types such
> as tables, where we refuse some action if we have already operated on
> the table in the same transaction.

What are some examples of such behavior?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] expanding inheritance in partition bound order
Next
From: David Fetter
Date:
Subject: Re: [HACKERS] generated columns