pg_relation_is_updatable, pg_column_is_updatable not documented

Started by jian heover 3 years ago2 messagesdocs
Jump to latest
#1jian he
jian.universality@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: jian he (#1)
Re: pg_relation_is_updatable, pg_column_is_updatable not documented

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