Re: ERROR: "ft1" is of the wrong type.

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>, Ahsan Hadi <ahsan(dot)hadi(at)gmail(dot)com>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: "ft1" is of the wrong type.
Date: 2021-07-08 08:02:53
Message-ID: 98fc542d-2a15-50c7-1818-55dcfe498a2d@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 02.07.21 06:20, Michael Paquier wrote:
> On Wed, Jun 30, 2021 at 01:43:52PM +0500, Ahsan Hadi wrote:
>> Sure I will also take a look at this patch.
>>
>> +1 for avoiding the backpatching burden.
>
> From what I recall of this thread, nobody has really complained about
> this stuff either, so a backpatch would be off the table. I agree
> that what Peter E is proposing on the other thread is much more
> suitable in the long term, as there is no need to worry about multiple
> combinations of relkinds in error message, so such error strings
> become a no-brainer when more relkinds are added.

My patch is now committed. The issue that started this thread now
behaves like this:

ALTER TABLE ft1 ATTACH PARTITION ...;
ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "ft1"
DETAIL: This operation is not supported for foreign tables.

So, for PG15, this is taken care of.

Backpatches under the old style for missing combinations would still be
in scope, but there my comment on the proposed patches is that I would
rather not remove apparently unused combinations from back branches.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2021-07-08 08:23:03 Re: [PATCH] expand the units that pg_size_pretty supports on output
Previous Message Peter Eisentraut 2021-07-08 07:54:58 Re: wrong relkind error messages