Re: [HACKERS] find_inheritance_children() and ALTER TABLE NO INHERIT

On 2015/12/03 15:30, Amit Langote wrote: > On 2015/12/03 13:09, Tom Lane wrote: >> Amit Langote writes: >>> Currently find_inheritance_children() is smart enough to skip a child >>> table that it finds has been dropped concurrently after it gets a lock on >>> the

[HACKERS] find_inheritance_children() and ALTER TABLE NO INHERIT

Currently find_inheritance_children() is smart enough to skip a child table that it finds has been dropped concurrently after it gets a lock on the same. It does so by looking up the child relid in syscache. It seems it should also check if the table is still in the list of children of the parent.

Re: [HACKERS] find_inheritance_children() and ALTER TABLE NO INHERIT

Amit Langote writes: > Currently find_inheritance_children() is smart enough to skip a child > table that it finds has been dropped concurrently after it gets a lock on > the same. It does so by looking up the child relid in syscache. It seems > it should also check

Re: [HACKERS] find_inheritance_children() and ALTER TABLE NO INHERIT

On 2015/12/03 13:09, Tom Lane wrote: > Amit Langote writes: >> Currently find_inheritance_children() is smart enough to skip a child >> table that it finds has been dropped concurrently after it gets a lock on >> the same. It does so by looking up the child relid in