1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
/* Once support for 9.5 has passed, use CASCADE */
CREATE EXTENSION IF NOT EXISTS btree_gist;
/* Once support for 9.6 has passed, just create the extension */
CREATE EXTENSION periods VERSION '1.2';
SELECT extversion
FROM pg_extension
WHERE extname = 'periods';
extversion
------------
1.2
(1 row)
DROP ROLE periods_unprivileged_user;
ERROR: role "periods_unprivileged_user" does not exist
CREATE ROLE periods_unprivileged_user;
/* Make tests work on PG 15 */
GRANT CREATE ON SCHEMA public TO PUBLIC;
|
