Re: [HACKERS] dropping partitioned tables without CASCADE - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [HACKERS] dropping partitioned tables without CASCADE
Date
Msg-id 03c35118-4b0a-c288-e03f-ee738d36ee60@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] dropping partitioned tables without CASCADE  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: [HACKERS] dropping partitioned tables without CASCADE  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
On 2017/02/22 21:24, Ashutosh Bapat wrote:
> On Wed, Feb 22, 2017 at 11:11 AM, Amit Langote wrote:
>> +       /*
>> +        * Unlike inheritance children, partition tables are expected to be dropped
>> +        * when the parent partitioned table gets dropped.
>> +        */
>>
>> Hmm.  Partitions *are* inheritance children, so we perhaps don't need the
>> part before the comma.  Also, adding "automatically" somewhere in there
>> would be nice.
>>
>> Or, one could just write: /* add an auto dependency for partitions */
> 
> I changed it in the attached patch to
> +    /*
> +     * Partition tables are expected to be dropped when the parent partitioned
> +     * table gets dropped.
> +     */

OK, thanks.

Thanks,
Amit





pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] Measuring replay lag
Next
From: Michael Paquier
Date:
Subject: [HACKERS] Automatic cleanup of oldest WAL segments with pg_receivexlog