Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

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(at)pcorp(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>