[DBD::Pg] Adjust TABLE_TYPE to distinguish SYSTEM MATERIALIZED VIEW
dbdpg-commits-gENoVmVU/[email protected] Tue, 8 Jul 2014 01:58:20 +0000
| Newsgroups | gmane.comp.db.postgresql.dbdpg.cvs |
|---|---|
| Message-ID | <[email protected]> |
Committed by David Christensen <david-O9fzpki4YnJWk0Htik3J/[email protected]> Adjust TABLE_TYPE to distinguish SYSTEM MATERIALIZED VIEW --- Pg.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Pg.pm b/Pg.pm index 612984a..ffbd9d0 100644 --- a/Pg.pm +++ b/Pg.pm @@ -1101,7 +1101,7 @@ use 5.008001; WHEN c.relkind = 'v' THEN CASE WHEN quote_ident(n.nspname) ~ '^pg_' THEN 'SYSTEM VIEW' ELSE 'VIEW' END WHEN c.relkind = 'm' THEN - CASE WHEN quote_ident(n.nspname) ~ '^pg_' THEN 'SYSTEM VIEW' ELSE 'MATERIALIZED VIEW' END + CASE WHEN quote_ident(n.nspname) ~ '^pg_' THEN 'SYSTEM MATERIALIZED VIEW' ELSE 'MATERIALIZED VIEW' END ELSE CASE WHEN quote_ident(n.nspname) ~ '^pg_' THEN 'SYSTEM TABLE' ELSE 'TABLE' END END AS "TABLE_TYPE" @@ -2768,7 +2768,7 @@ B<TABLE_SCHEM>: The name of the schema that the table or view is in. B<TABLE_NAME>: The name of the table or view. B<TABLE_TYPE>: The type of object returned. Will be one of "TABLE", "VIEW", -"MATERIALIZED VIEW", "SYSTEM VIEW", or "SYSTEM TABLE". +"MATERIALIZED VIEW", "SYSTEM VIEW", "SYSTEM MATERIALIZED VIEW", or "SYSTEM TABLE". The TABLE_SCHEM and TABLE_NAME will be quoted via C<quote_ident()>. -- 1.8.4