diff --strip-trailing-cr -U3 C:/cirrus/contrib/lo/expected/lo.out C:/cirrus/build/testrun/lo/regress/results/lo.out --- C:/cirrus/contrib/lo/expected/lo.out 2024-11-04 09:05:57.374569900 +0000 +++ C:/cirrus/build/testrun/lo/regress/results/lo.out 2024-11-04 09:11:42.689825600 +0000 @@ -1,7 +1,12 @@ CREATE EXTENSION lo; +ERROR: extension "lo" has no installation script nor update path for version "1.2" CREATE TABLE image (title text, raster lo); +ERROR: type "lo" does not exist +LINE 1: 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); +ERROR: relation "image" does not exist SELECT lo_create(43213); lo_create ----------- @@ -15,6 +20,9 @@ (1 row) INSERT INTO image (title, raster) VALUES ('beautiful image', 43213); +ERROR: relation "image" does not exist +LINE 1: INSERT INTO image (title, raster) VALUES ('beautiful image',... + ^ SELECT lo_get(43213); lo_get -------- @@ -28,8 +36,15 @@ (1 row) UPDATE image SET raster = 43214 WHERE title = 'beautiful image'; +ERROR: relation "image" does not exist +LINE 1: UPDATE image SET raster = 43214 WHERE title = 'beautiful ima... + ^ SELECT lo_get(43213); -ERROR: large object 43213 does not exist + lo_get +-------- + \x +(1 row) + SELECT lo_get(43214); lo_get -------- @@ -38,6 +53,9 @@ -- test updating of unrelated column UPDATE image SET title = 'beautiful picture' WHERE title = 'beautiful image'; +ERROR: relation "image" does not exist +LINE 1: UPDATE image SET title = 'beautiful picture' WHERE title = '... + ^ SELECT lo_get(43214); lo_get -------- @@ -45,6 +63,14 @@ (1 row) DELETE FROM image; +ERROR: relation "image" does not exist +LINE 1: DELETE FROM image; + ^ SELECT lo_get(43214); -ERROR: large object 43214 does not exist + lo_get +-------- + \x +(1 row) + DROP TABLE image; +ERROR: table "image" does not exist