routine_sequence_usage column is named sequence_catalog, not schema_catalog

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: micro6947(at)gmail(dot)com
Subject: routine_sequence_usage column is named sequence_catalog, not schema_catalog
Date: 2026-10-31 06:56:18
Message-ID: 179342977864.1246.4971529844925475150@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/infoschema-routine-sequence-usage.html
Description:

The information_schema.routine_sequence_usage page names the sequence
catalog
column "schema_catalog", but the view returns "sequence_catalog".

On PostgreSQL 16.14:

SELECT sequence_catalog
FROM information_schema.routine_sequence_usage
LIMIT 0;
-- success

SELECT schema_catalog
FROM information_schema.routine_sequence_usage
LIMIT 0;
-- ERROR: column "schema_catalog" does not exist

The REL_18_STABLE view definition also declares sequence_catalog:

https://github.com/postgres/postgres/blob/REL_18_STABLE/src/backend/catalog/information_schema.sql#L1478

The same documentation text appears in PG14 through PG19 pages. I suggest
changing schema_catalog to sequence_catalog in information_schema.sgml.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Yong Huang 2026-11-01 01:56:52 Re: postmaster.pid also contains shared memory key
Previous Message Mi cro 2026-10-31 06:39:20 Documented parameter names differ from callable proargnames for several built-ins