File: 35_edges.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 (12 lines) | stat: -rw-r--r-- 467 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
 
SET client_min_messages TO warning;
SET ROLE test_pgl_ddl_deploy;

CREATE TABLE foobar.foo (id SERIAL PRIMARY KEY);
CREATE TABLE foo (id SERIAL PRIMARY KEY);

--This is an edge case that currently can't be dealt with well with filtered replication.
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY id DESC LIMIT 10;

DROP TABLE foobar.foo CASCADE;
DROP TABLE foo CASCADE;