Home > mailing lists

forcing a table (parent in inheritance) tor emain empty - Mailing list pgsql-general

From	Rémi Cura
Subject	forcing a table (parent in inheritance) tor emain empty
Date	October 11, 2016 19:27:19
Msg-id	CAJvUf_sWWmJKe-0XQ43R4HAdgbhT0NMTkg7u=r=F_+Ytk+-BiA@mail.gmail.com Whole thread Raw
Responses	Re: forcing a table (parent in inheritance) tor emain empty (Manuel Gómez <targen@gmail.com>)
List	pgsql-general

Hey dear list,

I can't find a nice solution to enforce a necessary behaviour in my case :

I want a parent table to remain empty.

Of course I could define a trigger and return NULL in any case, but I'd like a more elegant approach using check or constraints.

Any thought appreciated,

Cheers,

Rémi C

From: Tom Lane
Date: 11 October 2016, 17:20:43
Subject: Re: confusion about user paring with pg_hba and pg_ident

From: David A
Date: 11 October 2016, 19:28:37
Subject: My DB has has 5TB, many operations are very slow (on Google Cloud Compute)