Обсуждение: pg_relation_is_updatable, pg_column_is_updatable not documented

Поиск
Список
Период
Сортировка

pg_relation_is_updatable, pg_column_is_updatable not documented

От
jian he
Дата:

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


Re: pg_relation_is_updatable, pg_column_is_updatable not documented

От
Tom Lane
Дата:
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