Why isn't pg_stat_get_subscription() marked as proretset?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Why isn't pg_stat_get_subscription() marked as proretset?
Date: 2021-03-07 18:29:42
Message-ID: 1636062.1615141782@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The code in pg_stat_get_subscription() appears to believe that it
can return a set of rows, but its pg_proc entry does not have
proretset set. It may be that this somehow accidentally fails
to malfunction when the function is used via the system views,
but if you try to call it directly it falls over:

regression=# select pg_stat_get_subscription(0);
ERROR: set-valued function called in context that cannot accept a set

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2021-03-07 19:12:08 Re: "has_column_privilege()" issue with attnums and non-existent columns
Previous Message Magnus Hagander 2021-03-07 17:11:09 Re: Nicer error when connecting to standby with hot_standby=off