Re: [GENERAL] Large object and pg_restore problem

2007-05-07 Thread Tom Lane
Gregory Gimenez <[EMAIL PROTECTED]> writes: > So, we try to get rid of this particular image by first deleting the > picture row with this corresponding oid and then making a vaccumdb + > reindex to delete the reference in the pg_largeoject but still the > largeobject is there. Well, yeah, you

[GENERAL] Large object and pg_restore problem

2007-05-07 Thread Gregory Gimenez
Dear All, We are using the postgreSQL version 8.0.7 and we are facing a problem regarding the large object and pg_dump. We are storing image data as OID type. We have developed a PHP application on it and we can see those images properly. The problem is when we dump the DB using the followi