bug report: pgadmin 1.20.0 Windows 8.1 MATERIALIZED VIEW with INDEX, pgadmin doesn't show the INDEX

From: Emery Lapinski <ewl(at)compressedtime(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug report: pgadmin 1.20.0 Windows 8.1 MATERIALIZED VIEW with INDEX, pgadmin doesn't show the INDEX
Date: 2015-09-09 21:34:55
Message-ID: CA+aXTH=7p9ryTvGAPFLVa+2ELJ5_-fyk+jzaNYCK0j=qND6LUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

For example:

set search_path = scratch;

drop materialized view if exists temp_a;

create materialized view temp_a as
select version() as str;

create index on temp_a (str);

select *
from temp_a;

Data Output:
str text
PostgreSQL 9.3.9 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

In the SQL pane I don't see the index, and they aren't in the Object
browser either:

-- Materialized View: scratch.temp_a

-- DROP MATERIALIZED VIEW scratch.temp_a;

CREATE MATERIALIZED VIEW scratch.temp_a AS
SELECT version() AS str
WITH DATA;

ALTER TABLE scratch.temp_a
OWNER TO xxx;

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message ganesan.k31 2015-09-10 04:54:17 Setting up Date Language in Postgresql
Previous Message Dave Page 2015-09-09 10:01:49 Re: Possible Bug: pgAdmin3 , OSX multi monitor quirk.