How to create read-only view on 9.3 - Mailing list pgsql-hackers

From Tomonari Katsumata
Subject How to create read-only view on 9.3
Date
Msg-id 5209FFA9.4060805@po.ntts.co.jp
Whole thread Raw
Responses Re: How to create read-only view on 9.3  (Szymon Guz <mabewlun@gmail.com>)
List 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





pgsql-hackers by date:

Previous
From: "Etsuro Fujita"
Date:
Subject: Re: 9.3 release notes suggestions
Next
From: Szymon Guz
Date:
Subject: Re: How to create read-only view on 9.3