PgSqlException "Server did not respond within the specified

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
shilpa24
Posts: 14
Joined: Mon 06 Jun 2011 11:05

PgSqlException "Server did not respond within the specified

Post by shilpa24 » Fri 23 Sep 2011 10:17

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

Shalex
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 23 Sep 2011 11:46

Try setting the "Default Command Timeout=0;" connection string parameter - lo_unlink can take a lot of time.

shilpa24
Posts: 14
Joined: Mon 06 Jun 2011 11:05

Post by shilpa24 » Sat 24 Sep 2011 04:54

Thanks shalex ,
its working

Post Reply