Pdo\Pgsql::lobUnlink
(PHP 8 >= 8.4.0)
Pdo\Pgsql::lobUnlink — Deletes the large object
说明
Deletes a large object from the database identified by OID.
注意:
This function, and all manipulations of the large object, must be called and carried out within a transaction.
参数
oid
A large object identifier.
示例
示例 #1 Pdo\Pgsql::lobUnlink() example
This example unlinks a large object from the database before deleting the row that references it. It uses the blobs table from the Pdo\Pgsql::lobCreate() and Pdo\Pgsql::lobOpen() examples.
<?php
$db = new Pdo\Pgsql('pgsql:dbname=test host=localhost', $user, $pass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->beginTransaction();
$db->lobUnlink($oid);
$stmt = $db->prepare("DELETE FROM BLOBS where ident = ?");
$stmt->execute([$some_id]);
$db->commit();
?>参见
- Pdo\Pgsql::lobCreate() - Creates a new large object
- Pdo\Pgsql::lobOpen() - Opens an existing large object stream
- pg_lo_create() - 新建大对象
- pg_lo_open() - 打开大对象
来源:PHP Documentation Group · 作者与贡献记录 · CC BY 3.0。离线整理了版式、链接和媒体显示。
