/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_extensions/test_ext_set_schema--1.0.sql
17 строк
634 B
Tom Lane
Repair ALTER EXTENSION ... SET SCHEMA.
09 май 2024, 19:19
09 май 2024, 19:19
9effc46
Код
Авторство
О чём код?
/* src/test/modules/test_extensions/test_ext_set_schema--1.0.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION test_ext_set_schema" to load this file. \quit -- Create various object types that need extra handling by SET SCHEMA. CREATE TABLE ess_table (f1 int primary key, f2 int, f3 text, constraint ess_c check (f1 != f2)); CREATE FUNCTION ess_func(int) RETURNS text BEGIN ATOMIC SELECT f3 FROM ess_table WHERE f1 = $1; END; CREATE TYPE ess_range_type AS RANGE (subtype = text); CREATE TYPE ess_composite_type AS (f1 int, f2 ess_range_type);