Unfortunately, I have a table called public.pg_proc within my database
with the same structure of pg_catalog.pg_proc. I did a test with it and forgot to drop it.
Within postgresql-7.4.1/src/interfaces/libpq/fe-lobj.c near line 555 is a query call as
res = PQexec(conn, "select proname, oid from pg_proc \
where proname = 'lo_open' \
or proname = 'lo_close' \
or proname = 'lo_creat' \
or proname = 'lo_unlink' \
or proname = 'lo_lseek' \
or proname = 'lo_tell' \
or proname = 'loread' \
or proname = 'lowrite'");
without a given schema. In my opinion, it must be:
res = PQexec(conn, "select proname, oid from pg_catalog.pg_proc \ ...
I have changed it in my fe-lobj.c . Now pg_restore works well.
BTW, I have droped the my test table public.pg_proc too ;-)
Regards, Janko
Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
When I restore the dumped database, pg_restore tries to restore the functions of tsearch2 as a large object.
It does what? I don't think you're describing this accurately. Please show the actual problem and not your interpretation of it.
regards, tom lane
-- Janko Richter
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
