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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to