I have a problem with opening Large Object in postgresql version 9.2,
select * from pg_largeobject where loid = '19423';
will return data like this:
loid oid;page no integer;data bytea
19423;0;"<Comment>ripple height</Comment><Units>meter</Units><Model>TRIM2</Model><Title>Results of TRIM model (Hartmut Kapitza): bottom temperature, bottom salinity, bed shear stress generated by currents. Results of WAM model (Heinz Guenther, Ralf Weisse): bed she (...)"
However, when I try to open with
select lo_open(19423, x'40000'::int);
It returns error:
ERROR: large object 19423 does not exist
SQL state: 42704
The result of this query:
select * from pg_largeobject_metadata where oid = 19423
is empty: lomowner oid; lomacl aclitem[]
What is this kind of error in Postgresql? I have no clue about it. The data was restored from 1 postgresql dump .sql file.
42704 undefined_object
select * from pg_largeobject_metadata where oid = 19423
COPY pg_largeobject (loid, pageno, data) FROM stdin;