[SIS-358] Leverage index inheritance when PostgreSQL will support this feature

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.8
• Component/s: Metadata
• Labels: SQL

Environment

PostgreSQL 9.6.

• Assignee: Unassigned
• Reporter: Martin Desruisseaux
• Created: 07/May/17 22:54
• Updated: 07/May/17 22:55

Description

The org.apache.sis.metadata.sql package takes advantage of table inheritance as documented there:

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

However as of version 9.6, 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.apache.sis.metadata.sql can not enforce foreigner key constraints on columns that reference a parent table.

If PostgreSQL supports index inheritance in a future version, then the Dialect.isIndexInheritanceSupported constant should be set to true.