Thread: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane
The feature was not available in 1.18.0 alpha1 build.
If you want to use it, please build it from the development branch or please wait for new release of pgAdmin III.
It has already been taken care in the repository.
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
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
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.Neel 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.
| Neel Patel <neel.patel@enterprisedb.com> |
| Paragon Corporation <lr@pcorp.us> |
| pgadmin-support@postgresql.org |
| 08/16/2013 01:19 AM |
| Re: [pgadmin-support] MATERIALIZED VIEW not showing MATERIALIZED in SQL pane |
| 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
