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

From sramay
Subject Re: pg_largeobject related issue with 9.2
Date
Msg-id 1389617630933-5786658.post@n5.nabble.com
Whole thread Raw
In response to Re: pg_largeobject related issue with 9.2  (sramay <nic.srama@gmail.com>)
List pgsql-general
Hi Kevin,


From Mr Momijan's suggestion by running the following query, I was in a
position
to create the pg_largeobject_metadata table instead of copying,  I assumed
that
postgres is the user at source and hence it should work for destination
also.  But
by running the following command

select pg_catalog.lo_create(t.loid)
    from (sleect  distinct  loid from pg_catalog.pg_largeobject) as t;


My issues are solved.  Thanks for the hint to you and to Mr. Momijan.

Regards

Rama



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-largeobject-related-issue-with-9-2-tp5784969p5786658.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: sramay
Date:
Subject: Re: pg_largeobject related issue with 9.2
Next
From: Tom Lane
Date:
Subject: Re: How to specify/mock the statistic data of tables in PostgreSQL