pg_relation_is_updatable, pg_column_is_updatable not documented

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: pg_relation_is_updatable, pg_column_is_updatable not documented
Date: 2022-11-10 17:31:52
Message-ID: CACJufxHrCM+v=5BfR-ePp3DsS=9BuWaNFkO=tEBwyh8tvGQJ-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2022-11-10 17:44:12 Re: pg_relation_is_updatable, pg_column_is_updatable not documented
Previous Message Peter Geoghegan 2022-11-10 00:34:04 Re: 64.4.2. Bottom-up Index Deletion