× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nishtha(*) reported 2015-12-23T04:54:25Z  · tomconrad last modified 2018-03-09T23:30:37Z

PostgreSQL - Can we display materilized view Object Type name as 'MATERIALIZED VIEW' instead of 'MAT_VIEW'.


PM
Priority Low
Complexity Unknown
Component DB - PostgreSQL
Version Future

Product: Aqua Data Studio
Version: 17.0.0-ga-10


From Issue #14061

Steps to reproduce the issue :
1) Connect to PostgreSQL 9.3.6 or PostgreSQL 9.4.2.
2) Create a Table.

CREATE TABLE "public"."invoice"  (
    "invoice_no"      int4 NOT NULL,
    "seller_no"       int4 NULL,
    "invoice_date"    date NULL,
    "invoice_amt"     numeric(13,2) NULL,
    PRIMARY KEY("invoice_no")
)
GO

3) Create a Materialized View on above Table.
CREATE MATERIALIZED VIEW "public"."sales_summary"
    AS
    SELECT invoice.seller_no,
    invoice.invoice_date,
    (sum(invoice.invoice_amt))::numeric(13,2) AS sales_amt
   FROM invoice
  WHERE (invoice.invoice_date < ('now'::text)::date)
  GROUP BY invoice.seller_no, invoice.invoice_date
  ORDER BY invoice.seller_no, invoice.invoice_date
WITH DATA
GO

4) Now Right click on materialized View "Sales_summary" and Select 'Tools -> Object Search' option.
5) In Object Search Window, Select Database and Select Schema in which we have created above materialized view.
    From 'Object Types' section select "Materialized Views".
6) From 'Object Search' section, Select 'Object Names' and click on 'Search' Button.

Actual Result :
In 'Object Type' column 'MAT_VIEW' is displayed instead of 'MATERIALIZED VIEW'.

Expected Result :
Can we have materialized view objects read as type 'MATERIALIZED_VIEW' instead of 'MAT_VIEW'.

Please refer attached screen-shot "MaterializedViews_ObjectType.png".

Observation :
In Schema Script Generator window if we Save script in one file with 'Include Descriptive Header' option checked, In Descriptive Header also 'MAT_VIEW' is displayed as Object Type instead of 'MATERIALIZED VIEW'.
 

1 attachment

Issue #14077

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017