How to create read-only view on 9.3

From: Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to create read-only view on 9.3
Date: 2013-08-13 09:43:05
Message-ID: 5209FFA9.4060805@po.ntts.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Could anyone tell me how to create read-only view on
PostgreSQL 9.3 ?

I've been testing updatable views and noticed that
all simple views are updatable.

When I use pg_dump for upgrading from PostgreSQL 9.2
to PostgreSQL 9.3 and if the databse has views,
all views are updatable on the restored database.

I want to make these views read-only like PostgreSQL9.2.
How can I do this? Should I make access control on users ?
(Sorry, I couldn't find any explanations on document.)

regards,
--------------------
NTT Software Corporation
Tomonari Katsumata

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Szymon Guz 2013-08-13 10:16:01 Re: How to create read-only view on 9.3
Previous Message Etsuro Fujita 2013-08-13 08:59:05 Re: 9.3 release notes suggestions