pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_relation_is_updatable, pg_column_is_updatable not documented
2+ messages / 2 participants
[nested] [flat]
* pg_relation_is_updatable, pg_column_is_updatable not documented
@ 2022-11-10 17:31 jian he <jian.universality@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: jian he @ 2022-11-10 17:31 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_relation_is_updatable, pg_column_is_updatable not documented
@ 2022-11-10 17:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: jian he <jian.universality@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2022-11-10 17:44 UTC (permalink / raw)
To: jian he <jian.universality@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-10 17:44 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-10 17:31 pg_relation_is_updatable, pg_column_is_updatable not documented jian he <jian.universality@gmail.com>
2022-11-10 17:44 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox