回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10 - Mailing list pgsql-bugs

From Fan||
Subject 回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10
Date
Msg-id tencent_95048BB0084347F9AB2D89A13E24CFA53308@qq.com
Whole thread Raw
In response to BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: 回复: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was createdfrom PostgreSQL 10.10  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Sorry, sent to wrong mail. 
Sent again.


------------------ 原始邮件 ------------------
发件人: "我自己的邮箱"<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.
Will you assign someone take to look this issue? Do you need the full script? It's like 100% reproduce.

BRs,
Fan Lilu


------------------ 原始邮件 ------------------
发件人: "Sergei Kornilov"<sk@zsrv.org>;
发送时间: 2019年11月9日(星期六) 凌晨0:59
收件人: "Tom Lane"<tgl@sss.pgh.pa.us>;"Fan||"<82820676@qq.com>;
抄送: "pgsql-bugs@lists.postgresql.org"<pgsql-bugs@lists.postgresql.org>;
主题: Re: BUG #16102: Table can't be drop on PostgreSQL 10.09 if the table was created from PostgreSQL 10.10

Hello

> It is not, never has been, and never will be supported to try to run
> a cluster with an older server version after it's been modified by
> a newer one. We have enough trouble ensuring forwards compatibility.

I agree and believe that we document this compatibility policy somewhere. But I found such description in docs: https://www.postgresql.org/docs/current/upgrading.html

> Minor releases never change the internal storage format and are always compatible with earlier and later minor releases of the same major version number. For example, version 10.1 is compatible with version 10.0 and version 10.6. Similarly, for example, 9.5.3 is compatible with 9.5.0, 9.5.1, and 9.5.6.

Seems opposite.

regards, Sergei

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: REINDEX CONCURRENTLY unexpectedly fails
Next
From: PG Bug reporting form
Date:
Subject: BUG #16114: Repo is broken