PgSqlException "Server did not respond within the specified

PgSqlException "Server did not respond within the specified

Postby 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
shilpa24
 
Posts: 14
Joined: Mon 06 Jun 2011 11:05

Postby 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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Postby shilpa24 » Sat 24 Sep 2011 04:54

Thanks shalex ,
its working
shilpa24
 
Posts: 14
Joined: Mon 06 Jun 2011 11:05


Return to dotConnect for PostgreSQL