pg_relation_is_updatable, pg_column_is_updatable not documented - Mailing list pgsql-docs

From jian he
Subject pg_relation_is_updatable, pg_column_is_updatable not documented
Date
Msg-id CACJufxHrCM+v=5BfR-ePp3DsS=9BuWaNFkO=tEBwyh8tvGQJ-Q@mail.gmail.com
Whole thread Raw
Responses Re: pg_relation_is_updatable, pg_column_is_updatable not documented  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs

Hi,

seems pg_column_is_updatable, pg_relation_is_updatable not documented.

example:
create view test_v_tenk1 AS
    select abs(unique1),unique1 from tenk1;
select pg_catalog.pg_column_is_updatable('test_v_tenk1'::regclass, 2::smallint, false)
select events & 4 != 0 AS upd,
       events & 8 != 0 AS ins,
       events & 16 != 0 AS del
from pg_catalog.pg_relation_is_updatable('test_v_tenk1'::regclass, true) t(events);
-------------------

I am not sure what the third parameter is doing in pg_column_is_updatable. True or false. The result is the same.
similarly, pg_relation_is_updatable, the second parameter true or false the result is the same.




--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


pgsql-docs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: 64.4.2. Bottom-up Index Deletion
Next
From: Tom Lane
Date:
Subject: Re: pg_relation_is_updatable, pg_column_is_updatable not documented