From: | Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | postgres list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_largeobject and oid mistmach after restore |
Date: | 2004-01-26 20:11:48 |
Message-ID: | 1075147908.9446.176.camel@bluejay.goodinassociates.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
my column types are and have always been oid, but for some weird reason
when I dump and restore, I can't seem to reference my blobs anymore. I
have done this a zillion times, and just can't figure our what the heck
I'm doing wrong (this time).
On Mon, 2004-01-26 at 14:03, Tom Lane wrote:
> Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> writes:
> > when I run the following two commands all of my OIDs for my blobs (about
> > 5.5 million of them) no longer reference anything in pg_largeobject.
> > All of the loid values change.
>
> pg_dump/pg_restore do not (and cannot) arrange for large objects to have
> the same OIDs after restore as they had before. What they do try to do
> is update references to the large objects to have the new OID values.
> Last I checked, they look in columns of types "oid" and "lo" (if "lo"
> exists) for such references. Maybe you were engaging in some type
> punning, like storing your references in int4 or int8 columns?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremiah Jahn | 2004-01-26 20:17:47 | Re: Where is initdb? |
Previous Message | Bruce Momjian | 2004-01-26 20:11:33 | Re: OT: SCO Extortion |