On 10/3/2013 11:53 AM, bricklen wrote:
Are you uninheriting the partition before attempting to get rid of it? Eg. ALTER TABLE your_partition NO INHERIT the_parent_table;
in a completely different but similar scenario, we've tried this, but NO INHERIT also blocks and and can deadlock if there's locks on the parent table, which in our case has nearly continuous OLTP style insert, update, and select queries running
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
