Changes between Initial Version and Version 3 of Ticket #29722


Ignore:
Timestamp:
Sep 17, 2018, 4:10:40 PM (6 years ago)
Author:
Nick Pope
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #29722

    • Property Triage Stage Unreviewed → Accepted
    • Property Summary Improve introspection for special table and view types in PostgreSQL → Add introspection of special table and view types.
    • Property Has patch set
    • Property Owner changed from nobody to Nick Pope
    • Property Status new → assigned

  • Ticket #29722 – Description

    initial v3  
     1**Originally this ticket was aimed at PostgreSQL:**
     2
    13Looking at the documentation for [https://www.postgresql.org/docs/10/static/catalog-pg-class.html pg_class] there are the following types that we might be interested in introspecting for generation of models:
    24
    … …  
    2224
    2325On PostgreSQL 10+ we need to filter on `NOT relispartition` to ignore all of the partitions and only include the parent (which is the table that is usually interacted with).
     26
     27**Regarding support for all backends:**
     28
     29Feature support by backend:
     30
     31||= =||= PostgreSQL =||= MySQL =||= Oracle =||= SQLite =||
     32|| Partitions || ✔ || ✔ || ✔ || ✘ ||
     33|| Foreign Tables || ✔ || ✘ || ✘ || ✘ ||
     34|| Materialized Views || ✔ || ✘ || ✔ || ✘ ||
     35
     36It looks partitions can be introspected using `INFORMATION_SCHEMA.PARTITIONS` for [https://dev.mysql.com/doc/refman/8.0/en/partitions-table.html MySQL] and there are other options for [https://docs.oracle.com/cd/E18283_01/server.112/e16541/part_admin005.htm Oracle].
     37
     38For introspection of materialized views, I think we could use `USER_MVIEWS` for [https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_5332.htm#REFRN26139 Oracle].
Back to Top