Skip site navigation (1) Skip section navigation (2)

Re: pg_restore --clean vs. large object

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_restore --clean vs. large object
Date: 2009-07-21 21:48:41
Message-ID: 21153.1248212921@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-07-21 21:55:12
Subject: Re: WIP: Deferrable unique constraints
Previous:From: Bernd HelmleDate: 2009-07-21 21:21:57
Subject: Re: bytea vs. pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group