File: 08_ignored.sql

package info (click to toggle)
pgl-ddl-deploy 2.2.1-2
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 3,780 kB
  • sloc: sql: 47,586; ansic: 364; python: 282; sh: 72; makefile: 63
file content (14 lines) | stat: -rw-r--r-- 343 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
SET ROLE test_pgl_ddl_deploy;

CREATE TEMP TABLE foo(id SERIAL PRIMARY KEY);
ALTER TABLE foo ADD COLUMN bla TEXT;
DROP TABLE foo;

SELECT 1 AS myfield INTO TEMP foo;
DROP TABLE foo;

CREATE TEMP TABLE foo AS
SELECT 1 AS myfield;
DROP TABLE foo;

SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY id DESC LIMIT 10;