apgdiff
apgdiff copied to clipboard
Constraint missing after COPY
If the dump file contains COPY commands for data the following DDL command is ignored.
In the following example the constraint ixlicensecode is ignored/skipped. If I remove "." then it works as expected.
...
...
--
-- Data for Name: zoneschema; Type: TABLE DATA; Schema: me; Owner: me
--
COPY zoneschema (id, lockcount, tenant, createdby, createdon, updatedby, updatedon, zonechart, rootorgunitid, orguniturl, orgunitid) FROM stdin;
\.
--
-- Name: ixlicensecode; Type: CONSTRAINT; Schema: me; Owner: me; Tablespace:
--
ALTER TABLE ONLY license
ADD CONSTRAINT ixlicensecode UNIQUE (code, tenant) DEFERRABLE INITIALLY DEFERRED;
...
...