/log/

/results/

/tmp_check/

DATA = lo--1.1.sql lo--1.0--1.1.sql lo--unpackaged--1.0.sql

PGFILEDESC = "lo - management for large objects"

REGRESS = lo

PG_CONFIG = pg_config

PGXS :=$(shell$(PG_CONFIG) --pgxs)

CREATE EXTENSION lo;

CREATE TABLE image (title text, raster lo);

CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image

FOR EACH ROW EXECUTE PROCEDURE lo_manage(raster);

SELECT lo_create(43213);

lo_create

-----------

43213

(1 row)

SELECT lo_create(43214);

lo_create

-----------

43214

(1 row)

INSERT INTO image (title, raster) VALUES ('beautiful image', 43213);

SELECT lo_get(43213);

lo_get

--------

\x

(1 row)

SELECT lo_get(43214);

lo_get

--------

\x

(1 row)

UPDATE image SET raster = 43214 WHERE title = 'beautiful image';

SELECT lo_get(43213);

ERROR: large object 43213 does not exist

SELECT lo_get(43214);

lo_get

--------

\x

(1 row)

DELETE FROM image;

SELECT lo_get(43214);

ERROR: large object 43214 does not exist

DROP TABLE image;

CREATE EXTENSION lo;

CREATETABLEimage (titletext, raster lo);

CREATETRIGGERt_raster BEFOREUPDATEORDELETEON image

FOR EACH ROW EXECUTE PROCEDURE lo_manage(raster);

SELECT lo_create(43213);

SELECT lo_create(43214);

INSERT INTO image (title, raster)VALUES ('beautiful image',43213);

SELECT lo_get(43213);

SELECT lo_get(43214);

UPDATE imageSET raster=43214WHERE title='beautiful image';

SELECT lo_get(43213);

SELECT lo_get(43214);

DELETEFROM image;

SELECT lo_get(43214);

DROPTABLE image;

</para>

<programlisting>

CREATE TABLE image (titleTEXT, raster lo);

CREATE TABLE image (titletext, raster lo);

CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image

FOR EACH ROW EXECUTE PROCEDURE lo_manage(raster);