Postgres Pro
Downloads
Home   >   mailing lists

Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane - Mailing list pgadmin-support

From Paragon Corporation
Subject Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Date
Msg-id 244F18CE78834F1E9D93E35BB92C85E0@O
Whole thread Raw
In response to Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane  (Richard D Levine <Richard_D_Levine@raytheon.com>)
Responses Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
List pgadmin-support
Tree view
Materialized views is a new feature in PostgreSQL 9.3, so you won't see it available until the next EDB release and PostgreSQL releases.  Gathering from pg advocacy emails, I'm guessing they are planning to release 9.3 sometime in September or October.

From: Richard D Levine [mailto:Richard_D_Levine@raytheon.com]
Sent: Friday, August 16, 2013 11:38 AM
To: Neel Patel
Cc: Paragon Corporation; pgadmin-support@postgresql.org; pgadmin-support-owner@postgresql.org
Subject: Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

I can find no reference in any Postgres or EnterpriseDB documentation to MATERIALIZED VIEW.  Are you using pgAdmin with a different DB engine?  I'm confused.  I would also love to have materialized views.


Inactive hide details for Neel Patel ---08/16/2013 01:19:01 AM---Hi, I have checked with latest master branch code and i am notNeel Patel ---08/16/2013 01:19:01 AM---Hi, I have checked with latest master branch code and i am not able to reproduce the issue.


    From:

Neel Patel <neel.patel@enterprisedb.com>

    To:

Paragon Corporation <lr@pcorp.us>

    Cc:

pgadmin-support@postgresql.org

    Date:

08/16/2013 01:19 AM

    Subject:

Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

    Sent by:

pgadmin-support-owner@postgresql.org



Hi,

I have checked with latest master branch code and i am not able to reproduce the issue.

I have followed the below steps in Ubuntu 10.04 and windows 7 64 bit.

1. Create the Materialized View with below commands.

            CREATE MATERIALIZED VIEW m_test AS SELECT generate_series(1,10);

2. Check the SQL Pane window it shows the below output for me which is correct.

            -- Materialized View: m_test

            -- DROP MATERIALIZED VIEW m_test;

            CREATE MATERIALIZED VIEW m_test AS 
             SELECT generate_series(1, 10) AS generate_series
            WITH DATA;

            ALTER TABLE m_test
             OWNER TO postgres;


-- Are you using the installers or binary compiled with latest source code ? If using the installers then can you please check with latest source code and follow the same steps to reproduce it.

-- Are you able to see the Materialized View icon under the "Views" node ?

Thanks,
Neel Patel


On Thu, Aug 15, 2013 at 11:09 AM, Paragon Corporation <lr@pcorp.us> wrote:
    I'm running pgAdmin 1.18.0 Alpha 1 on Windows

    IF I create a view

    CREATE MATERIALIZED VIEW mat_test
    AS SELECT generate_series(1,10) ;

    Then look at the view in the SQL pane, it shows this:

    CREATE OR REPLACE VIEW public.mat_test AS
     SELECT generate_series(1, 10) AS generate_series;


    Thanks,
    Regina




    --
    Sent via pgadmin-support mailing list (    pgadmin-support@postgresql.org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgadmin-support


Attachment

pgadmin-support by date:

Previous
From: "John Foelster"
Date:
Subject: Re: Password setting having somewhat bizarre results.
Next
From: Darren Duncan
Date:
Subject: Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane