blob: 8ab4eb03385230e7ed2fdf57c8a10089bb4d89d3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
--
-- CREATE_SCHEMA
--
CREATE SCHEMA foo;
NOTICE: DDL test: type simple, tag CREATE SCHEMA
CREATE SCHEMA IF NOT EXISTS bar;
NOTICE: DDL test: type simple, tag CREATE SCHEMA
CREATE SCHEMA baz;
NOTICE: DDL test: type simple, tag CREATE SCHEMA
-- Will not be created, and will not be handled by the
-- event trigger
CREATE SCHEMA IF NOT EXISTS baz;
NOTICE: schema "baz" already exists, skipping
CREATE SCHEMA element_test
CREATE TABLE foo (id int)
CREATE VIEW bar AS SELECT * FROM foo;
NOTICE: DDL test: type simple, tag CREATE SCHEMA
NOTICE: DDL test: type simple, tag CREATE TABLE
NOTICE: DDL test: type simple, tag CREATE VIEW
|
