aboutsummaryrefslogtreecommitdiff
path: root/src/test/modules/test_dsm_registry/sql/test_dsm_registry.sql
blob: 965a3f1ebb63aa88a7ec17bc0030b7047a0a92e2 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT name, type, size IS DISTINCT FROM 0 AS size
FROM pg_dsm_registry_allocations
WHERE name like 'test_dsm_registry%' ORDER BY name;
CREATE EXTENSION test_dsm_registry;
SELECT set_val_in_shmem(1236);
SELECT set_val_in_hash('test', '1414');
\c
SELECT get_val_in_shmem();
SELECT get_val_in_hash('test');
\c
SELECT name, type, size IS DISTINCT FROM 0 AS size
FROM pg_dsm_registry_allocations
WHERE name like 'test_dsm_registry%' ORDER BY name;