1. Tiago
  2. Valentina Studio
  3. Среда, Ноябрь 29 2017, 01:01 PM
  4.  Подписаться через email
Hi,

I'm running Valentina Studio 7.5.4 on a mac, and I'm trying to see the materialized views that exist for a Postgres Schema, but I don't find that anywhere (they're not listed under "views";).
Is there a feature to see this? Where can I find it?

Thank you
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Tiago

It should be in the "views" list.

Refresh doesn't help, right?
Вложения
Комментарий
There are no comments made yet.
Tiago Ответ принят
Hi Sergey,
Yes, that was what I thought as well, but the views list is empty (and refresh doesn't help either).

Hello Tiago

It should be in the "views" list.

Refresh doesn't help, right?
Комментарий
There are no comments made yet.
DMITRY IVANOV Ответ принят
Today I worked in the materialized views in the version under Windows. I can assure you that there is no such problem. Everything is displayed in the views tree :)
Комментарий
There are no comments made yet.
Tiago Ответ принят
So, might this be a problem of the Mac version?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hi Tiago,

It works for me on Mac.

What PostgreSQL version are you using?

Here's the query used to get the list of views:

SELECT
cl.oid
, cl.relname AS viewname
, ns.nspname AS SCHEMA
, pg_get_viewdef( cl.oid ) AS definition
, obj_description( cl.oid ) AS COMMENT
, ( CASE
WHEN cl.relkind = 'm'
THEN TRUE
ELSE FALSE
END ) AS "materialized"
, ( CASE
WHEN cl.relkind = 'm'
THEN( SELECT ispopulated FROM pg_matviews WHERE schemaname = ns.nspname AND matviewname = cl.relname )
ELSE FALSE
END ) AS with_data
FROM pg_class cl
JOIN pg_namespace ns
ON ns.oid = relnamespace
AND ( cl.relkind = 'v' OR cl.relkind = 'm' )
AND ns.nspname = 'schema_name'


You can try it to see if materialized views are returned for your schema_name.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories