Thread: pg_relation_is_updatable, pg_column_is_updatable not documented
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 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);
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
jian he <jian.universality@gmail.com> writes: > seems pg_column_is_updatable, pg_relation_is_updatable not documented. I think they're not documented because they're only intended as support for some information_schema views. regards, tom lane