On Tue, Oct 11, 2016 at 12:27 PM, Rémi Cura <remi(dot)cura(at)gmail(dot)com> wrote:
> 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.
You could probably do it with a simple constraint:
postgres=# create table dum(check (false));
CREATE TABLE
postgres=# insert into dum default values;
ERROR: new row for relation "dum" violates check constraint "dum_check"
DETAIL: Failing row contains ().