Page 1 of 1

PgSqlException "Server did not respond within the specified

Posted: Fri 23 Sep 2011 10:17
by shilpa24
hi,

i had stored a large file upto 300 mb in pg_largeobject table
but when i m going to remove this large object data,
exception occur "server did not respond within the specified timeout interval"

following query are used to remove the large object

Call Database.ExecuteSQL("select lo_unlink(" & oid.ToString & ")")

where oid is the loid field of pg_largeobject table

Posted: Fri 23 Sep 2011 11:46
by Shalex
Try setting the "Default Command Timeout=0;" connection string parameter - lo_unlink can take a lot of time.

Posted: Sat 24 Sep 2011 04:54
by shilpa24
Thanks shalex ,
its working