Re: Simple task with partitioning which I can't realize

2022-03-02 Thread Geri Wright
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

Re: Simple task with partitioning which I can't realize

2022-03-02 Thread Mladen Gogala
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