Can't access view pg_stat_progress_copy

[ogerardin]

Hi all,

I would like to read the system view pg_stat_progress_copy to monitor a COPY job.

This view, as all pg_ views, is in schema pg_catalog so I added this to my config:
db-schemas = "public, pg_catalog"

But when I try this:
curl "http://localhost:3000/pg_stat_progress_copy" -H "Accept-Profile: pg_catalog"

I get this error:
{"code":"PGRST205","details":null,"hint":null,"message":"Could not find the table 'pg_catalog.pg_stat_progress_copy' in the schema cache"}

The database user (postgres) has no issue querying this view using psql:
psql -U postgres -c "select * from pg_catalog.pg_stat_progress_copy;"

What have I missed?

[wolfgangwalther]

Our schema cache queries have a hardcoded exception for pg_catalog, you can't expose it like that:

postgrest/src/PostgREST/SchemaCache.hs

Line 711 in b915968

AND r.relnamespace NOT IN ('pg_catalog'::regnamespace, 'information_schema'::regnamespace)

If you really want to expose that data, I suggest you create a view in your regular exposed schema which selects from that pg_catalog view.

[ogerardin]

Oh.. That explains it. What was the rationale for this decision?

Additionally it would be nice to get a warning when it is explicitly added to db-schemas instead of silently ignoring it.