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

<p><font face="sans-serif" size="2">I can find no reference in any Postgres or EnterpriseDB documentation to
MATERIALIZEDVIEW.  Are you using pgAdmin with a different DB engine?  I'm confused.  I would also love to have
materializedviews.<br /></font><br /><br /><img alt="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 not" border="0" height="16"
src="cid:1__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="16" /><font color="#424282" face="sans-serif"
size="2">NeelPatel ---08/16/2013 01:19:01 AM---Hi, I have checked with latest master branch code and i am not able to
reproducethe issue.</font><br /><br /><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr
valign="top"><tdwidth="1%"><img alt="" border="0" height="1" src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"
width="96"/><br /><ul style="padding-left: 4pt"><font color="#5F5F5F" face="sans-serif"
size="1">From:</font></ul></td><tdwidth="100%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="1" /><br /><font face="sans-serif" size="1">Neel Patel
<neel.patel@enterprisedb.com></font></td></tr><trvalign="top"><td width="1%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="96" /><br /><ul style="padding-left: 4pt"><font
color="#5F5F5F"face="sans-serif" size="1">To:</font></ul></td><td width="100%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="1" /><br /><font face="sans-serif" size="1">Paragon
Corporation<lr@pcorp.us></font></td></tr><tr valign="top"><td width="1%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="96" /><br /><ul style="padding-left: 4pt"><font
color="#5F5F5F"face="sans-serif" size="1">Cc:</font></ul></td><td valign="middle" width="100%"><img alt="" border="0"
height="1"src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com" width="1" /><br /><font face="sans-serif"
size="1">pgadmin-support@postgresql.org</font></td></tr><trvalign="top"><td width="1%"><img alt="" border="0"
height="1"src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com" width="96" /><br /><ul style="padding-left: 4pt"><font
color="#5F5F5F"face="sans-serif" size="1">Date:</font></ul></td><td width="100%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="1" /><br /><font face="sans-serif" size="1">08/16/2013
01:19AM</font></td></tr><tr valign="top"><td width="1%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="96" /><br /><ul style="padding-left: 4pt"><font
color="#5F5F5F"face="sans-serif" size="1">Subject:</font></ul></td><td width="100%"><img alt="" border="0" height="1"
src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com"width="1" /><br /><font face="sans-serif" size="1">Re:
[pgadmin-support]MATERIALIZED VIEW not showing MATERIALIZED in SQL pane</font></td></tr><tr valign="top"><td
width="1%"><imgalt="" border="0" height="1" src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com" width="96" /><br
/><ulstyle="padding-left: 4pt"><font color="#5F5F5F" face="sans-serif" size="1">Sent by:</font></ul></td><td
width="100%"><imgalt="" border="0" height="1" src="cid:2__=09BBF15ADFC618CD8f9e8a93d@mck.us.ray.com" width="1" /><br
/><fontface="sans-serif" size="1">pgadmin-support-owner@postgresql.org</font></td></tr></table><hr align="left" noshade
size="2"style="color:#8091A5; " width="100%" /><br /><br /><br /><font face="serif" size="3">Hi,</font><br /><br
/><fontface="serif" size="3">I have checked with latest master branch code and i am not able to reproduce the
issue.</font><br/><br /><font face="serif" size="3">I have followed the below steps in Ubuntu 10.04 and windows 7 64
bit.</font><br/><br /><font face="serif" size="3">1. Create the Materialized View with below commands.</font><br /><br
/><fontface="serif" size="3">            CREATE MATERIALIZED VIEW m_test AS SELECT generate_series(1,10);</font><br
/><br/><font face="serif" size="3">2. Check the SQL Pane window it shows the below output for me which is
correct.</font><br/><br /><font face="serif" size="3">            -- Materialized View: m_test</font><br /><br /><font
face="serif"size="3">            -- DROP MATERIALIZED VIEW m_test;</font><br /><br /><font face="serif" size="3">     
     CREATE MATERIALIZED VIEW m_test AS </font><br /><font face="serif" size="3">             SELECT generate_series(1,
10)AS generate_series</font><br /><font face="serif" size="3">            WITH DATA;</font><br /><br /><font
face="serif"size="3">            ALTER TABLE m_test</font><br /><font face="serif" size="3">             OWNER TO
postgres;</font><br/><br /><br /><font face="serif" size="3">-- Are you using the installers or binary compiled with
latestsource code ? If using the installers then can you please check with latest source code and follow the same steps
toreproduce it.</font><br /><br /><font face="serif" size="3">-- Are you able to see the Materialized View icon under
the"Views" node ?</font><br /><br /><font face="serif" size="3">Thanks,</font><br /><font face="serif" size="3">Neel
Patel</font><br/><font face="serif" size="3"><br /></font><br /><font face="serif" size="3">On Thu, Aug 15, 2013 at
11:09AM, Paragon Corporation <</font><a href="mailto:lr@pcorp.us" target="_blank"><font color="#0000FF" face="serif"
size="3"><u>lr@pcorp.us</u></font></a><fontface="serif" size="3">> wrote:</font><ul style="padding-left: 9pt"><font
face="serif"size="3">I'm running pgAdmin 1.18.0 Alpha 1 on Windows<br /><br /> IF I create a view<br /><br /> CREATE
MATERIALIZEDVIEW mat_test<br /> AS SELECT generate_series(1,10) ;<br /><br /> Then look at the view in the SQL pane, it
showsthis:<br /><br /> CREATE OR REPLACE VIEW public.mat_test AS<br />  SELECT generate_series(1, 10) AS
generate_series;<br/><br /><br /> Thanks,<br /> Regina</font><font color="#888888" face="serif" size="3"><br /><br
/><br/><br /><br /> --<br /> Sent via pgadmin-support mailing list (</font><a
href="mailto:pgadmin-support@postgresql.org"><fontcolor="#0000FF" face="serif"
size="3"><u>pgadmin-support@postgresql.org</u></font></a><fontcolor="#888888" face="serif" size="3">)<br /> To make
changesto your subscription:</font><font color="#0000FF" face="serif" size="3"><u><br /></u></font><a
href="http://www.postgresql.org/mailpref/pgadmin-support"target="_blank"><font color="#0000FF" face="serif"
size="3"><u>http://www.postgresql.org/mailpref/pgadmin-support</u></font></a></ul><br/><br />