Ouch. 

>-----Original Message-----
>From: slony1-general-bounces at gborg.postgresql.org 
>[mailto:slony1-general-bounces at gborg.postgresql.org] On Behalf 
>Of Doug McNaught
>Sent: Friday, December 03, 2004 5:44 PM
>To: Darcy Buskermolen
>Cc: slony1-general at gborg.postgresql.org
>Subject: Re: [Slony1-general] large objects
>
>Darcy Buskermolen <darcy at wavefire.com> writes:
>
>> For this how does the large object dump/restore facility work in PG 
>> now (I think it's a contrib package)
>
>No, it's built into pg_dump/pg_restore.  The restore process 
>fixes up the LOIDs on the fly, as long as the referencing 
>field is of type "oid" or a derivative.  If you are 
>referencing the LOID with an int4 field you will end up with a 
>broken database after restore...
>
>-Doug
>_______________________________________________
>Slony1-general mailing list
>Slony1-general at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/slony1-general
>