Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane

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(at)raytheon(dot)com]
Sent: Friday, August 16, 2013 11:38 AM
To: Neel Patel
Cc: Paragon Corporation; pgadmin-support(at)postgresql(dot)org;
pgadmin-support-owner(at)postgresql(dot)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(dot)patel(at)enterprisedb(dot)com>

To:

Paragon Corporation <lr(at)pcorp(dot)us>

Cc:

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