Re: unique indexes on partitioned tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: unique indexes on partitioned tables
Date
Msg-id 20180219185430.bztdubmwhlceu6xs@alvherre.pgsql
Whole thread Raw
In response to Re: unique indexes on partitioned tables  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
Responses Re: unique indexes on partitioned tables
List pgsql-hackers
Jaime Casanova wrote:

> Hi Álvaro,
> 
> attached a tiny patch (on top of yours) that silence two "variables
> uninitilized" warnings.

Thanks!  Applied.

> also noted that if you:
> 
> """
> create table t1(i int) partition by hash (i);
> create table t1_0 partition of t1 for values with (modulus 2, remainder 0);
> create table t1_1 partition of t1 for values with (modulus 2, remainder 1);
> create unique index on t1(i);
> alter table t1 add primary key using index t1_i_idx ;
> """
> 
> the ALTER TABLE ADD PK does not recurse to partitions, which maybe is
> perfectly fine because i'm using USING INDEX but it feels like an
> oversight to me

Ouch.  Yeah, this is a bug.  I'll try to come up with something.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: pgbench - test whether a variable exists
Next
From: Jesper Pedersen
Date:
Subject: Re: JIT compiling with LLVM v10.1