Re: [BUGS] BUG #1096: pg_restore cannot restore large objects with

2004-03-11 Thread Bruce Momjian
7.4.X CVS has: if (conn->sversion >= 70300) query = "select proname, oid from pg_catalog.pg_proc " "where proname in (" "'lo_open', " "'lo_close', " "'lo_creat', " "'lo_unlink', " "'lo_lseek', " "'lo_t

Re: [BUGS] BUG #1096: pg_restore cannot restore large objects with other oid columns

2004-03-11 Thread Tom Lane
Janko Richter <[EMAIL PROTECTED]> writes: > I have found the bug. > 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 l

Re: [BUGS] BUG #1096: pg_restore cannot restore large objects with

2004-03-11 Thread Janko Richter
I have found the bug. 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

Re: [BUGS] BUG #1096: pg_restore cannot restore large objects with other oid columns

2004-03-10 Thread Tom Lane
"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.