Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)
Дата
Msg-id CAEepm=17f2125qKN9UDjxEhmGAA0Jw_PBOQbqEQ9rsfwpYJ7OQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On Fri, May 5, 2017 at 8:29 AM, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:
> On Fri, May 5, 2017 at 2:40 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> On Thu, May 4, 2017 at 4:46 AM, Thomas Munro
>> <thomas.munro@enterprisedb.com> wrote:
>>> On Thu, May 4, 2017 at 4:02 AM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
>>>> Robert Haas wrote:
>>>>> I suspect that most users would find it more useful to capture all of
>>>>> the rows that the statement actually touched, regardless of whether
>>>>> they hit the named table or an inheritance child.
>>>>
>>>> Yes, agreed.  For the plain inheritance cases each row would need to
>>>> have an indicator of which relation it comes from (tableoid); I'm not
>>>> sure if such a thing would be useful in the partitioning case.
>>>
>>> On Thu, May 4, 2017 at 4:26 AM, David Fetter <david@fetter.org> wrote:
>>>> +1 on the not-duct-tape view of partitioned tables.
>>>
>>> Hmm.  Ok.  Are we talking about PG10 or PG11 here?  Does this approach
>>> makes sense?
>>
>> I was thinking PG10 if it can be done straightforwardly.
>
> Ok, I will draft a patch to do it the way I described and see what people think.

FYI I am still working on this and will post a draft patch to do this
(that is: make transition tables capture changes from children with
appropriate tuple conversion) in the next 24 hours.

-- 
Thomas Munro
http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: [HACKERS] proposal psql \gdesc
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] snapbuild woes