Re: strange permission error

Mr Dash Four <mr.dash.four@googlemail.com> writes:
> In my database I have restricted access to a particular user
> (non-superuser), which is used when a cron job passes a series of sql
> script files for execution via psql. During one such statement (below) I
> get the following set of error:

> ERROR:  permission denied for schema pg_catalog
> CONTEXT:  SQL function "textanycat" during inlining
> STATEMENT:  COPY  ( SELECT v FROM dandy.audit_v ) TO STDOUT ;

> What is causing the above permission error? I have deliberately
> restricted user access to pg_catalog

You caused it yourself, then.  Don't do that.  (Or if you must,
it's your own responsibility to fix things when they break.  But
preventing read access to pg_catalog seems pretty crippling.)

FWIW, it's probably the "'user: ' || u_name" expressions that result
in this specific failure.

            regards, tom lane