Обсуждение: bug report: pgadmin 1.20.0 Windows 8.1 MATERIALIZED VIEW with INDEX, pgadmin doesn't show the INDEX

Поиск
Список
Период
Сортировка

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

От
Emery Lapinski
Дата:
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;

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

От
Dmitriy Olshevskiy
Дата:
hello.
> In the SQL pane I don't see the index, and they 
> aren't in the Object browser either:
it's already implemented and will appear in 
version 1.22.

On 10.09.2015 1:34, Emery Lapinski wrote:
> 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;
>

-- 
Dmitriy Olshevskiy