Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction
Date
Msg-id 20170913135615.sxhwjp7bbo7bnq5g@alvherre.pgsql
Whole thread Raw
In response to Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the same transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] DROP SUBSCRIPTION hangs if sub is disabled in the sametransaction
List pgsql-hackers
Tree view 
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.

-- 
Álvaro Herrera                https://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: Jesper Pedersen
Date:
Subject: Re: [HACKERS] POC: Cache data in GetSnapshotData()
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] psql: new help related to variables are not too readable