1. Tiago
  2. Valentina Studio
  3. 水, 11月 29 2017, 01:01 PM
  4.  メールで購読
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 承諾済みの回答
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.
Tiago 承諾済みの回答
So, might this be a problem of the Mac version?
コメント
There are no comments made yet.
Jochen Peters 承諾済みの回答
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 承諾済みの回答
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.
Sergey Pashkov 承諾済みの回答
Hello Tiago

It should be in the "views" list.

Refresh doesn't help, right?
添付ファイル
コメント
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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories