Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

Поиск
Список
Период
Сортировка
От Paragon Corporation
Тема Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Дата
Msg-id 244F18CE78834F1E9D93E35BB92C85E0@O
обсуждение исходный текст
Ответ на Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane  (Richard D Levine <Richard_D_Levine@raytheon.com>)
Ответы Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Список pgadmin-support
Дерево обсуждения
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


Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: "John Foelster"
Дата:
Сообщение: Re: Password setting having somewhat bizarre results.
Следующее
От: Darren Duncan
Дата:
Сообщение: Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane