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? http://www.postgresql.org/docs/faq
