Re: pg_largeobject related issue with 9.2 - Mailing list pgsql-general

From Kevin Grittner
Subject Re: pg_largeobject related issue with 9.2
Date
Msg-id 1389399105.28163.YahooMailNeo@web122301.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: pg_largeobject related issue with 9.2  (sramay <nic.srama@gmail.com>)
Responses Re: pg_largeobject related issue with 9.2  (sramay <nic.srama@gmail.com>)
List pgsql-general
sramay <nic.srama@gmail.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


pgsql-general by date:

Previous
From: ambilalmca
Date:
Subject: Re: How to know server status variable in postgresql?
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade & tablespaces