Re: pg_restore --clean vs. large object - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_restore --clean vs. large object
Date
Msg-id 21153.1248212921@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore --clean vs. large object  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> The attached is a patch to execute lo_unlink() before lo_create()
> in pg_restore.

Applied with corrections --- you had failed to ensure that pg_dump and
pg_restore produce the same output.  I also took the opportunity to
schema-qualify the calls of lo_xxx functions, just to be on the safe
side.  (The code already sets search_path, but why not be sure ...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: bytea vs. pg_dump
Next
From: Tom Lane
Date:
Subject: Re: WIP: Deferrable unique constraints