Re: BUG #18244: Corruption in indexes involving whole-row expressions - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #18244: Corruption in indexes involving whole-row expressions
Date
Msg-id c56c11e52620ea3a51f13aa482ac2376a3c552e8.camel@cybertec.at
Whole thread Raw
In response to Re: BUG #18244: Corruption in indexes involving whole-row expressions  (Junwang Zhao <zhjwpku@gmail.com>)
List pgsql-bugs
On Thu, 2023-12-14 at 16:27 +0800, Junwang Zhao wrote:
> +   While you can use composite types in column definitions, there is usually no
> +   benefit in doing so.
>
> Is this true? If yes, we'd better update this to
> https://wiki.postgresql.org/wiki/Don%27t_Do_This.

I cannot think of a use case for composite type columns that wouldn't be
better served by directly declaring the columns of the composite key
in the table definition.  And it makes accessing the values more complicated.

So yes, I'd be on board with a "don't do this" entry.

Yours,
Laurenz Albe



pgsql-bugs by date:

Previous
From: Junwang Zhao
Date:
Subject: Re: BUG #18244: Corruption in indexes involving whole-row expressions
Next
From: Richard Guo
Date:
Subject: Re: BUG #18247: Integer overflow leads to negative width