Re: COPY does not work with regproc and aclitem

Zdenek Kotala wrote:
> I tried to use COPY command to export and import tables from catalog,
> but COPY command has problem with data type regproc. See example
>
> create table test (like pg_aggregate);
> copy pg_aggregate to '/tmp/pg_agg.out';
> copy test from '/tmp/pg_agg.out';
>
> ERROR: more than one function named "pg_catalog.avg"
> CONTEXT: COPY test, line 1, column aggfnoid: "pg_catalog.avg"

Hmm, maybe it should be using regprocedure instead? That one emits
type-qualified function names, IIRC.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support