changing type of column on partitionated table.

From: Edmundo Robles <edmundo(at)sw-argos(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: changing type of column on partitionated table.
Date: 2017-04-24 18:15:24
Message-ID: CAOXzpYCtz3Qg8APk0O+BaOfmAMXVh3rvzcRxDaENW9TprwR1QA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi !

I have Postgresql 9.4, a partitionated table and i must change the type
of column.

The changes over a master table DDL are applied to the childs?

or must I change the inheritance to off and change it one by one? for
each child and master table.

what is the best way/practice to change the type column over partitioned
tables?

Regards.
--

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-04-24 18:18:21 Re: Postgres 9.6.2 and pg_log
Previous Message Scott Marlowe 2017-04-24 18:11:11 Re: Block size recommendation for Red Hat Linux 7.2