PG_LO_UNLINK(3)PG_LO_UNLINK(3)pg_lo_unlink - Delete a large objectSYNOPSIS
bool pg_lo_unlink (resource $connection, int $oid)
DESCRIPTION pg_lo_unlink(3) deletes a large object with the $oid. Returns TRUE on success or FALSE on failure.
To use the large object interface, it is necessary to enclose it within a transaction block.
Note
This function used to be called pg_lounlink(3).
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $oid
- The $OID of the large object in the database.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
pg_lo_unlink(3) example
<?php
// OID of the large object to delete
$doc_oid = 189762345;
$database = pg_connect("dbname=jacarta");
pg_query($database, "begin");
pg_lo_unlink($database, $doc_oid);
pg_query($database, "commit");
?>
SEE ALSO pg_lo_create(3), pg_lo_import(3).
PHP Documentation Group PG_LO_UNLINK(3)
Check Out this Related Man Page
PG_LO_OPEN(3)PG_LO_OPEN(3)pg_lo_open - Open a large objectSYNOPSIS
resource pg_lo_open (resource $connection, int $oid, string $mode)
DESCRIPTION pg_lo_open(3) opens a large object in the database and returns large object resource so that it can be manipulated.
Warning
Do not close the database connection before closing the large object resource.
To use the large object interface, it is necessary to enclose it within a transaction block.
Note
This function used to be called pg_loopen(3).
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $oid
- The $OID of the large object in the database.
o $mode
- Can be either "r" for read-only, "w" for write only or "rw" for read and write.
RETURN VALUES
A large object resource or FALSE on error.
EXAMPLES
Example #1
pg_lo_open(3) example
<?php
$database = pg_connect("dbname=jacarta");
pg_query($database, "begin");
$oid = pg_lo_create($database);
echo "$oid
";
$handle = pg_lo_open($database, $oid, "w");
echo "$handle
";
pg_lo_write($handle, "large object data");
pg_lo_close($handle);
pg_query($database, "commit");
?>
SEE ALSO pg_lo_close(3), pg_lo_create(3).
PHP Documentation Group PG_LO_OPEN(3)
I have a very large database and once in awhile the database auto loading scripts that update the database for the daily updates fails and I have to go in and manually fix it but when that happens I usually have to start from scratch on sundays I have access to a weekly database rebuild. Then I... (3 Replies)
i have a little pro*c code (as shown below)
to connect an oracle database. (in unix solaris platform)
in the preprocessor compilation step everything is ok.
but when i try to compile the code using cc i get the
error below:
ld:
Unresolved:
sqlcxt
i think there is a problem while linking... (3 Replies)
Hello,
first of all, I want to make myself clear about my language. I'm brazilian, so I ask you all to understand if i commit any mistake with the grammar.
Here is the problem.
Some days ago I needed to use a "sh" command in the Terminal (I use a Mac OSX 10.5.6) followed by a file... (0 Replies)
Hi All
We have got a HUGE process of securing our infrastructure(primarily the database)
We basically establish connection to oracle database from our UNIX shell scripts
when we do ps -ef | grep sqlplus
it blurts out all the credentials as output.
sqplus username/password@server
... (1 Reply)
Hi
I have a small function which returns a wrong value.
The function tries to make a connection to oracle database and tries to get the open_mode of the database in the variable status.
However when a database is down the value of the status column is set to READWRITE i am not sure why.
I... (0 Replies)
Hello,
I have a large database in which name homonyms are arranged in a row. Since the database is large and generated by hand, very often dupes creep in. I want to remove the dupes either using an awk or perl script.
An input is given below
The expected output is given below:
As can be... (2 Replies)