Search Postgresql Archives

[PGSQL 8.3.5] How to handle FKs with partitioning?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all.

I need to implement something very similar to temporal table partitioning as 
described in the documentation at chapter 5.9.

My issues come from the fact that I have other tables that references (FKs) to
the table(s) to be partitioned. Those references are enforced by means of DRI 
statements (REFERENCES ...).

As the table containing the referenced data will not be a single table, will I 
be forced to drop DRI?
The referencing table(s) don't need to be partitioned, though and have also 
other FKs to other tables.

Is there any other solution as I would keep DRI?

Thanks in advance.

-- 
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux