tamodel 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
2 month because i thought that
partitioning was a possible solution that doesn't offer me Apache Derby
for my large table problem so if these questions sounds "dummy" for you
this is a postgresql novice talking to you.
Regards
Le 14/03/2011 20:40, Robert Haas a écrit :
On Mon,
at 3:25 AM, Samba GUEYE wrote:
The measure insertion is successful but problems raise up when inserting in
the simpleMeasure table because it can't find the foreign key inserted the
measure table and do not look at the partitionned tables
Yes, that's how it works.
--
Sent via pg
2011 23:01, Jim Nasby a écrit :
On Mar 8, 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/i
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 du
