14 lines
546 B
SQL
14 lines
546 B
SQL
|
|
-- Sanity test object existence in storage schema
|
|
|
|
select has_table('storage'::name, 'buckets'::name);
|
|
select has_table('storage'::name, 'objects'::name);
|
|
select has_table('storage'::name, 'migrations'::name);
|
|
select has_function('storage'::name, 'foldername'::name);
|
|
select has_function('storage'::name, 'filename'::name);
|
|
select has_function('storage'::name, 'extension'::name);
|
|
select has_function('storage'::name, 'search'::name);
|
|
|
|
select todo('This test should probably fail.'); select schema_privs_are('storage', 'anon', ARRAY['USAGE']);
|
|
|