Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5307

Add views referential_constraints, key_column_usage, table_constraints to information_schema

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 10.3
    • None
    • ODBC, Query Engine
    • None

    Description

      Outside of what is reference in npgsql provider, it seems as though PowerBI also references following views to generate schema information

      Add column in information_schema.columns

      • data_type

      Add support for information_schema.referential_constraints (
      https://www.postgresql.org/docs/current/static/infoschema-referential-constraints.html) to teiid

      Add support for information_schema.key_column_usage (
      https://www.postgresql.org/docs/current/static/infoschema-key-column-usage.html) to teiid

      Add support for information_schema.table_constraints (
      https://www.postgresql.org/docs/current/static/infoschema-table-constraints.html) to teiid

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            dvallabh_doi Divyesh Vallabh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: