diff --git a/contrib/lo/expected/lo.out b/contrib/lo/expected/lo.out index f7104aee3f..de5dbcb0f9 100644 --- a/contrib/lo/expected/lo.out +++ b/contrib/lo/expected/lo.out @@ -36,6 +36,13 @@ SELECT lo_get(43214); \x (1 row) +UPDATE image SET title = 'beautiful picture' WHERE title = 'beautiful image'; +SELECT lo_get(43214); + lo_get +-------- + \x +(1 row) + DELETE FROM image; SELECT lo_get(43214); ERROR: large object 43214 does not exist diff --git a/contrib/lo/sql/lo.sql b/contrib/lo/sql/lo.sql index 34ba6f00ec..1e96e67aba 100644 --- a/contrib/lo/sql/lo.sql +++ b/contrib/lo/sql/lo.sql @@ -18,6 +18,10 @@ UPDATE image SET raster = 43214 WHERE title = 'beautiful image'; SELECT lo_get(43213); SELECT lo_get(43214); +UPDATE image SET title = 'beautiful picture' WHERE title = 'beautiful image'; + +SELECT lo_get(43214); + DELETE FROM image; SELECT lo_get(43214);