If you are wanting to ensure uniqueness for the original oracle pk across
the partitions, you could look into adding an advisory trigger to the table.
On Wed, Mar 2, 2022, 2:28 AM Michel SALAIS wrote:
> *De :* Marc Millas
> *Envoyé :* mardi 1 mars 2022 19:00
> *À :* Andrew Zakharov
> *Cc :* pg
On 3/1/22 10:54, David G. Johnston wrote:
On Tue, Mar 1, 2022 at 8:37 AM Andrew Zakharov wrote:
create table region_hierarchy(
gid uuid not null default uuid_generate_v1mc(),
parent_gid uuid null,
region_code int2,
I’ve carefully looked thru docs/faqs/google/commun