pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: Fan|| <82820676@qq.com>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: 回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10
Date: Thu, 14 Nov 2019 23:13:17 +0100
Message-ID: <20191114221317.bef2at6wzh3pt5bv@development> (raw)
In-Reply-To: <tencent_95048BB0084347F9AB2D89A13E24CFA53308@qq.com>
References: <16102-3fe2c9426d7faba1@postgresql.org>
	<982.1573225598@sss.pgh.pa.us>
	<8523951573232347@vla1-78135a9f092e.qloud-c.yandex.net>
	<tencent_7267E919CC453E849323FF55CBC4271F8907@qq.com>
	<tencent_95048BB0084347F9AB2D89A13E24CFA53308@qq.com>

On Thu, Nov 14, 2019 at 04:13:10PM +0800, Fan|| wrote:
>Sorry, sent to wrong mail. 
>Sent again.
>

Please don't top post, it makes following the discussion much harder.

>
>------------------ 原始邮件 ------------------
>发件人: "我自己的邮箱"<82820676@qq.com>;
>发送时间: 2019年11月12日(星期二) 上午9:32
>收件人: "Sergei Kornilov"<sk@zsrv.org>;
>
>主题: 回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10
>
>Hello,
>
>Thanks for the reply. I understand this is an issue really sounds strange.
>
>So, form document it saying that it should be not problem when switching between minor release.

The linked docs are about internal on-disk format, and that's true.  It
simply means minor releases do no change on-disk format of data files,
so pg_upgrade nor dump/reload is needed.

The issue here is that a minor version fixed some sorf of bug, affecting
catalog contents, probably by adding a missing dependency between
objects. The older minor release is unaware of that, making the drop
fail. But that's expected, as Tom explains.

We need to be able to make these changes, because that's what bug fixes
often require. And we can't stop doing that.

So we only support upgrades, i.e. going from 12.0 -> 12.1 -> 12.3 ...
and the chance of us supporting downgrades is pretty much nil.

>Will you assign someone take to look this issue? Do you need the full
>script? It's like 100% reproduce.
>

Unlikely. Very few users need the capability to downgrade to older minor
releases, and I don't think anyone is going to work on that. If it is an
important feature for you, you'll need to look into what would it take
to support it and submit a patch.


regards

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





view thread (4+ messages)

Message-ID: <20191114221317.bef2at6wzh3pt5bv@development>
Permalink:  ../20191114221317.bef2at6wzh3pt5bv@development/
Also on:    postgresql.org/message-id/20191114221317.bef2at6wzh3pt5bv@development

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: tomas.vondra@2ndquadrant.com, 82820676@qq.com
  Subject: Re: 回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10
  In-Reply-To: <20191114221317.bef2at6wzh3pt5bv@development>
  References: <16102-3fe2c9426d7faba1@postgresql.org> <982.1573225598@sss.pgh.pa.us> <8523951573232347@vla1-78135a9f092e.qloud-c.yandex.net> <tencent_7267E919CC453E849323FF55CBC4271F8907@qq.com> <tencent_95048BB0084347F9AB2D89A13E24CFA53308@qq.com> <20191114221317.bef2at6wzh3pt5bv@development>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox