Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] changing type of column on partitionated table. - Mailing list pgsql-general

From Edmundo Robles
Subject [GENERAL] changing type of column on partitionated table.
Date
Msg-id CAOXzpYCtz3Qg8APk0O+BaOfmAMXVh3rvzcRxDaENW9TprwR1QA@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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.
--

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Postgres 9.6.2 and pg_log