Alright thanks all of you for your answers, but i've got 3 more questions :
1. Why ... partitionning is not a good idea ... like you said
Robert and Conor ... I grant that it would be better to never
need to do that ?
2. Is there another way or strategy to deal with very large
to workaround the
inheritance foreigh key issue but i will at least test it because we
have limited resources and can't afford to have many servers or whatever
to boost performances...
Best Regards
Le 15/03/2011 14:18, Shaun Thomas a écrit :
On 03/15/2011 05:10 AM, Samba GUEYE wrote:
1. Why
Yeah but is there a workaround to force the root table to propagate the
foreign key to the partitionned table
because right now all foreign keys to partitionned table throws
constraints violation and it's a big problem for me
Le 11/03/2011 19:31, Robert Haas a écrit :
On Thu, Mar 10, 2011 at
, 2011, at 9:45 AM, Samba GUEYE wrote:
I have a problem with table partitioning because i have a foreign key applied
on the partionned table and it throw a constraint violation error during
inserts.
I saw on the manual
(http://www.postgresql.org/docs/8.4/interactive/ddl-inherit.html caveats
Hello,
I have a problem with table partitioning because i have a foreign key
applied on the partionned table and it throw a constraint violation
error during inserts.
I saw on the manual
(http://www.postgresql.org/docs/8.4/interactive/ddl-inherit.html caveats
section) that it's a limitation