| 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:
The same documentation text appears in PG14 through PG19 pages. I suggest
changing schema_catalog to sequence_catalog in information_schema.sgml.
| 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 |