Re: Partitioned tables and covering indexes - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Partitioned tables and covering indexes
Date
Msg-id a5ca67cf-0448-7875-ae89-64495748c016@sigaev.ru
Whole thread Raw
In response to Re: Partitioned tables and covering indexes  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: Partitioned tables and covering indexes
Re: Partitioned tables and covering indexes
List pgsql-hackers
>     Does the attached fix look correct?  Haven't checked the fix with ATTACH
>     PARTITION though.
> 
> 
> Attached patch seems to fix the problem.  However, I would rather get
> rid of modifying stmt->indexParams.  That seems to be more logical
> for me.  Also, it would be good to check some covering indexes on
> partitioned tables.  See the attached patch.
Seems right way, do not modify incoming object and do not copy rather large and 
deep nested structure as suggested by Amit.

But it will  be better to have a ATTACH PARTITION test too.

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Boolean partitions syntax
Next
From: Anthony Iliopoulos
Date:
Subject: Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS