Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a work around for partition key needed for constraint - Mailing list pgsql-admin

From legrand legrand
Subject Re: Is there a work around for partition key needed for constraint
Date
Msg-id 1540532037246-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Is there a work around for partition key needed for constraint  (Jorge Torralba <jorge.torralba@gmail.com>)
List pgsql-admin
Tree view 
Jorge Torralba wrote
> Thanks for the suggestion. But there is one slight problem :)
> 
> DETAIL:  Partitioned tables cannot have BEFORE / FOR EACH ROW triggers.

Given exemple, works on a 11beta2 release. Triggers have to be created at 
PARTITION level, not at TABLE level (where it is not supported ;o(.

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Jorge Torralba
Date:
Subject: Re: Is there a work around for partition key needed for constraint
Next
From: Mark Steben
Date:
Subject: hot standby cascading replication