Re: [GENERAL] Disabling inheritance with query.

Поиск
Список
Период
Сортировка
От Edmundo Robles
Тема Re: [GENERAL] Disabling inheritance with query.
Дата
Msg-id CAOXzpYCLCOmwp1aKzYfpGLnp6mgK=BH8CrwyjzhyYVxk59Nj1A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Disabling inheritance with query.  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] Disabling inheritance with query.
Re: [GENERAL] Disabling inheritance with query.
Список pgsql-general
Дерево обсуждения
I want to do that because,  I have  a  partitioned table  (big_table)  and others  (t1,t2,t3,t4)  have  foreign keys  reference to big_table  and i had many trobules at insert data, reading the doc: 
"A serious limitation of the inheritance feature is that indexes (including unique constraints) and foreign key constraints only apply to single tables, not to their inheritance children. "

On Wed, Dec 21, 2016 at 4:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Edmundo Robles <edmundo@sw-argos.com> writes:
> i need  disable  inheritance  from many tables in a query like
> "delete from pg_inherits where inhparent=20473"  instead alter table ...
> but  is safe?   which is the risk for  database if  i  delete it?

This seems really dangerous.  You're certainly missing the pg_depend
linkages, not to mention attribute inheritance counts in pg_attribute,
and there may be other things I'm not remembering offhand.

Why can't you use the normal ALTER TABLE approach?

                        regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Андрей Брюхов
Дата:
Сообщение: [GENERAL] Fwd: idea for big speed optimization
Следующее
От: Scott Mead
Дата:
Сообщение: Re: [GENERAL] Disabling inheritance with query.