[geotk] [JIRA] Created: (GEOTK-30) Leverage index inheritance when PostgreSQL will support this feature

[Martin Desruisseaux (JIRA)]

Leverage index inheritance when PostgreSQL will support this feature
--------------------------------------------------------------------

                 Key: GEOTK-30
                 URL: http://jira.geotoolkit.org/browse/GEOTK-30
             Project: Geotoolkit
          Issue Type: Improvement
          Components: Metadata
    Affects Versions: 3.03
            Reporter: Martin Desruisseaux
            Priority: Trivial


The {{org.geotoolkit.metadata.sql}} package takes advantage of table inheritance as documented there:

    http://www.postgresql.org/docs/8.4/static/ddl-inherit.html

However as of version 8.4, PostgreSQL does not support index inheritance. This limitation is documented in the "Caveats" section at the bottom of the above-cited page. The consequence is that {{org.geotoolkit.metadata.sql}} can not enforce foreigner key constraints on columns that reference a parent table. (Note that even this workaround does not work in every cases, since {{org.geotoolkit.metadata.sql}} may not know that a table has childs if the columns in the parent table are created before the childs. This hack is hoped temporary, pending improvement of PostgreSQL inheritance).

If PostgreSQL supports index inheritance in a future version, then the {{MetadataWriter.INDEX_INHERITANCE_SUPPORTED}} constant should be removed (or temporarily set to {{true}}, pending removal).


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.geotoolkit.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira