So I did miss something! Thanks for the brilliant explanation and simple
solution, Tom.
Bob
--- On Thu, 3/18/10, Tom Lane wrote:
> From: Tom Lane
> Subject: Re: [BUGS] Error while altering an inheritance hierarchy in mid-query
> To: "Bob Lunney"
> Cc: pgsql-bugs
Bob Lunney writes:
> 1. A select into query is run which summarizes the data from a partition
> into a table outside the inheritance hierarchy, which is then indexed.
> 2. Then
> a. a transaction is begun,
> b. the original partition is dropped,
> c. the new table renamed to the orig
My database implements partitioning using inheritance and constraint exclusion,
as described in the fine manual. Each partition holds data for a single day,
and there are well over 300 child partitions.
The exception mentioned below notwithstanding, the technique works exceedingly
well and i
