Re: [HACKERS] multi-column range partition constraint

2017-05-12 Thread Amit Langote
On 2017/05/12 12:22, Robert Haas wrote: > On Wed, May 10, 2017 at 10:21 PM, Amit Langote > wrote: >>> Next update on this issue by Thursday 5/11. >> >> Attached updated patches. > > Thanks. 0001, at least, really needs a pgindent run. Also, my > compiler has this

Re: [HACKERS] Bug with pg_basebackup and 'shared' tablespace

2017-05-12 Thread Kyotaro HORIGUCHI
Hi, I noticed this just now. At Mon, 01 May 2017 19:28:59 +0200, Pierre Ducroquet wrote in <05c62730-8670-4da6-b783-52e66fb42...@pinaraf.info> > I didn't have much time to spend on that issue until today, and I > found a way to solve it that seems acceptable to me. > > The

Re: [HACKERS] UPDATE of partition key

2017-05-12 Thread Amit Kapila
On Fri, Feb 24, 2017 at 3:50 PM, Robert Haas wrote: > On Fri, Feb 24, 2017 at 3:24 PM, Simon Riggs wrote: > >> It is of course very good that we have something ready for this >> release and can make a choice of what to do. >> >> Thoughts >> >> 1.

[HACKERS] Is there any way to access heap_open() from _PG_init ??

2017-05-12 Thread Sairam Gaddam
Hello people, I was trying to build an extension(Index related) on top of postgres. During startup (_PG_init), I need to access some meta info of table/relation (like PK Column Position, FK Column Positions, Index Column Positions etc...) and load it into memory. To accomplish that, In

Re: [HACKERS] CTE inlining

2017-05-12 Thread Andreas Joseph Krogh
På torsdag 11. mai 2017 kl. 23:37:27, skrev Yaroslav >: Ilya Shkuratov wrote > First of all, to such replacement to be valid, the CTE must be >     1. non-writable (e.g. be of form: SELECT ...), >     2. do not use VOLATILE or STABLE

Re: [HACKERS] Adding support for Default partition in partitioning

2017-05-12 Thread Jeevan Ladhe
Hi Rahila, On Thu, May 11, 2017 at 7:37 PM, Rahila Syed wrote: > > >3. > >In following function isDefaultPartitionBound, first statement "return > false" > >is not needed. > It is needed to return false if the node is not DefElem. > Please have a look at following code:

<    1   2