apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

Constraint missing after COPY

Open tdtappe opened this issue 9 years ago • 0 comments

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;
...
...

tdtappe avatar Feb 11 '16 12:02 tdtappe