Mr Dash Four <mr.dash.four@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
