diff options
| author | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2009-12-14 00:39:11 +0000 |
|---|---|---|
| committer | Itagaki Takahiro <itagaki.takahiro@gmail.com> | 2009-12-14 00:39:11 +0000 |
| commit | 84f910a7076e09e551bf69e0972473ec15d33c79 (patch) | |
| tree | 7ce85524e7d24091581b2a0ce6309422d0330811 /contrib/lo | |
| parent | 0182d6f646997e486f56f847001ff74694bdd7da (diff) | |
| download | postgresql-84f910a7076e09e551bf69e0972473ec15d33c79.tar.gz | |
Additional fixes for large object access control.
Use pg_largeobject_metadata.oid instead of pg_largeobject.loid
to enumerate existing large objects in pg_dump, pg_restore, and
contrib modules.
Diffstat (limited to 'contrib/lo')
| -rw-r--r-- | contrib/lo/lo_test.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/contrib/lo/lo_test.sql b/contrib/lo/lo_test.sql index e22a8889b3..73022b2535 100644 --- a/contrib/lo/lo_test.sql +++ b/contrib/lo/lo_test.sql @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/contrib/lo/lo_test.sql,v 1.5 2007/11/13 04:24:28 momjian Exp $ */ +/* $PostgreSQL: pgsql/contrib/lo/lo_test.sql,v 1.6 2009/12/14 00:39:10 itagaki Exp $ */ -- Adjust this setting to control where the objects get created. SET search_path = public; @@ -12,7 +12,7 @@ SET search_path = public; -- -- Check what is in pg_largeobject -SELECT count(DISTINCT loid) FROM pg_largeobject; +SELECT count(oid) FROM pg_largeobject_metadata; -- ignore any errors here - simply drop the table if it already exists DROP TABLE a; @@ -74,6 +74,6 @@ DELETE FROM a; DROP TABLE a; -- Check what is in pg_largeobject ... if different from original, trouble -SELECT count(DISTINCT loid) FROM pg_largeobject; +SELECT count(oid) FROM pg_largeobject_metadata; -- end of tests |