pg_lo_truncate64

pg_lo_truncate64
Prev	4.6. Large Object Processing Commands	Next

pg_lo_truncate64 — Truncate a large object, changing its size, using a 64-bit offset

Synopsis

pg_lo_truncate64 conn descriptor length

Description

pg_lo_truncate64 changes the size of a large object to a specified number of bytes. If the new size is smaller than the current size, the large object is truncated. If the new size is larger than the current size, the large object is padded with null bytes. The new size is a 64-bit integer, allowing for larger size objects compare to pg_lo_truncate.

Arguments

conn: The handle of the connection.
descriptor: A descriptor for the large object from pg_lo_open.
length: The desired new size in bytes for the large object, as a 64-bit integer.

Return Value

Nothing. A Tcl error will be thrown if an error occurs.

Notes

All large object manipulation must take place within an SQL transaction block.

This command was added in pgtclng-2.1.0 and in pgintcl-3.5.0.

This command uses or emulates the PostgreSQL libpq function lo_truncate64. In order for pg_lo_truncate64 to be available and usable, the library must be be built and linked with PostgreSQL libpq 9.3.0 or higher (does not apply to pgintcl), and be connected to a PostgreSQL server version 9.3.0 or higher.

Prev	Up	Next
pg_lo_truncate	Home	pg_lo_unlink