Postgres Pro
Downloads
Home   >   mailing lists

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

From Szymon Guz
Subject Re: How to create read-only view on 9.3
Date
Msg-id CAFjNrYtmJA83FKx+VryfdLo7vCp7hz0TMMeEmS9iZgqSFHCAJg@mail.gmail.com
Whole thread Raw
In response to How to create read-only view on 9.3  (Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp>)
Responses Re: How to create read-only view on 9.3  (Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp>)
List pgsql-hackers
Tree view



On 13 August 2013 11:43, Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp> wrote:
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



Could you show an example?

Szymon 

pgsql-hackers by date:

Previous
From: Tomonari Katsumata
Date:
Subject: How to create read-only view on 9.3
Next
From: Tomonari Katsumata
Date:
Subject: Re: How to create read-only view on 9.3