From: | Richard D Levine <Richard_D_Levine(at)raytheon(dot)com> |
---|---|
To: | Neel Patel <neel(dot)patel(at)enterprisedb(dot)com> |
Cc: | Paragon Corporation <lr(at)pcorp(dot)us>, pgadmin-support(at)postgresql(dot)org, pgadmin-support-owner(at)postgresql(dot)org |
Subject: | Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane |
Date: | 2013-08-16 15:38:10 |
Message-ID: | OF7BC73CE6.202F4074-ON86257BC9.00559E5D-85257BC9.0055E481@mck.us.ray.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
|------------>
| 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 <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
From | Date | Subject | |
---|---|---|---|
Next Message | Ashesh Vashi | 2013-08-16 17:38:45 | Re: MATERIALIZED VIEW not showing MATERIALIZED in SQL pane |
Previous Message | Dave Page | 2013-08-16 08:47:53 | Re: PGAdmin3 runs pg_dump etc |