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
