Postgres Pro
Downloads
Home   >   mailing lists

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

From Neel Patel
Subject Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
Date
Msg-id CAMcbDBHu69+EOhqrm=SrLchpJ4_YZ4YA_3jHZZ4cYAW=tr884g@mail.gmail.com
Whole thread Raw
In response to MATERIALIZED VIEW not showing MATERIALIZED in SQL pane  ("Paragon Corporation" <lr@pcorp.us>)
Responses Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane  (Richard D Levine <Richard_D_Levine@raytheon.com>)
List pgadmin-support
Tree view
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 by date:

Previous
From: Stephen Cook
Date:
Subject: PGAdmin3 runs pg_dump etc
Next
From: Dinesh Kumar
Date:
Subject: Re: PGAdmin3 runs pg_dump etc