Re: [GENERAL] BLOBS : how to remove them totally

2003-12-22 Thread Nilabhra Banerjee
Thanx for ur suggestion... But I face a new problem now... connection.setAutoCommit works well with postgresql 7.3 .. but with postgresql 7.4 I am getting the error... Error in connection == ERROR: SET AUTOCOMMIT TO OFF is no longer supported I have tried pg73jdbc1.jar and pg73jdbc3.jar .. both

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Nilabhra Banerjee
Thanks a lot for the clue... Now I am comfortably handling the Lrge Objects thru SQL... But unfortunately I could not extract this data to frontend thru java... I tried in two ways but got the same error...after getting the data in Blob or Large Object. Error in connection == FastPath call

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Kris Jurka
On Sat, 20 Dec 2003, [iso-8859-1] Nilabhra Banerjee wrote: But unfortunately I could not extract this data to frontend thru java... I tried in two ways but got the same error...after getting the data in Blob or Large Object. Error in connection == FastPath call returned ERROR: invalid

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Paul Ganainm
[EMAIL PROTECTED] says... That's a good discussion, but it left out at least one useful bit of info about managing large objects: there's a contrib utility (contrib/vacuumlo) that can find and remove large objects that are not referenced anywhere in the database. What is the URL for the