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

Add views referential_constraints, key_column_usage, table_constraints to information_schema

    XMLWordPrintable

    Details

    • Type: Enhancement
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 10.3
    • Component/s: ODBC, Query Engine
    • Labels:
      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                dvallabh_doi Divyesh Vallabh
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: