View source for PostgreSQLDatabase.DeleteLargeObject

{{MethodBox
| name=DeleteLargeObject
| owner=[[PostgreSQLDatabase]]
| ownertype=class
| scope=public
| parameters=oid As [[Integer]]
| platform=all
}}
{{Description
|text = Deletes the large object identified by ''oid''.}}

== Notes ==

PostgreSQL requires that all large object operations be performed inside of a transaction. Therefore, you must start a transaction before you perform your first large object operation:

<rbcode>
db.ExecuteSQL("BEGIN TRANSACTION")
</rbcode>

After you have performed your last large object operation, you should close the transaction, like this:

<rbcode>
db.ExecuteSQL("END TRANSACTION")
</rbcode>

Please see the [[PostgreSQLLargeObject]] class for information on how to work with large objects.

== Example ==
Delete a large object:

<rbcode>
// db is a previously connected PostgreSQLDatabase
// objectID is a reference to a previously created large object
Try
db.DeleteLargeObject(objectID)
Catch error As DatabaseException
  MessageDialog.Show("DB Error: " + error.Message)
End Try
</rbcode>