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