Re: Proposal to introduce a shuffle function to intarray extension - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal to introduce a shuffle function to intarray extension
Date
Msg-id 687490.1658152096@sss.pgh.pa.us
Whole thread Raw
In response to Re: Proposal to introduce a shuffle function to intarray extension  (John Naylor <john.naylor@enterprisedb.com>)
Responses [PATCH] Introduce array_shuffle() and array_sample()
List pgsql-hackers
John Naylor <john.naylor@enterprisedb.com> writes:
> On Mon, Jul 18, 2022 at 2:47 PM Martin Kalcher <
> martin.kalcher@aboutsource.net> wrote:
>> One more question. How do i pick a Oid for the functions?

> For this, we recommend running src/include/catalog/unused_oids, and it will
> give you a random range to pick from. That reduces the chance of different
> patches conflicting with each other. It doesn't really matter what the oid
> here is, since at feature freeze a committer will change them anyway.

If you want the nitty gritty details here, see

https://www.postgresql.org/docs/devel/system-catalog-initial-data.html#SYSTEM-CATALOG-OID-ASSIGNMENT

            regards, tom lane



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: limits of max, min optimization
Next
From: Andrey Borodin
Date:
Subject: Re: Use fadvise in wal replay