File: hooks.sql

package info (click to toggle)
pgextwlist 1.19-1
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 216 kB
  • sloc: ansic: 849; sql: 62; makefile: 40; sh: 6
file content (14 lines) | stat: -rw-r--r-- 438 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
select case
  when setting::int >= 160000 then 'PG 16+'
  end as "regression output for PG version"
from pg_settings where name = 'server_version_num';

set client_min_messages = debug;
set extwlist.custom_path = '/dummy';
set role mere_mortal;

-- in the hope refint stays at version 1.0 in PostgreSQL
create extension refint;
alter extension refint update;
comment on extension refint is 'snarky remark';
drop extension refint, refint;