Re: pg_largeobject related issue with 9.2

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: sramay <nic(dot)srama(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_largeobject related issue with 9.2
Date: 2014-01-11 00:11:45
Message-ID: 1389399105.28163.YahooMailNeo@web122301.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sramay <nic(dot)srama(at)gmail(dot)com> wrote:

> select * from pg_largeobject where loid=141066;
>
> it is showing 3 rows
>
> But whenever I want to export to lo_export it says loid missing

Perhaps pageno = 0 is missing for that object?  Perhaps you need
something in pg_largeobject_metadata for the object permissions?  I
would compare the entries for the large objects which are not
working with the entries that are working.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2014-01-11 02:59:36 Re: pg_upgrade & tablespaces
Previous Message Paul Ramsey 2014-01-10 23:12:54 Re: round(real,integer)