Toad World® Forums

PostgreSQL 9.0 Sync and Convert bug on primary key generation


I have added an attribute to the primary key of my contact address table in TDM.

The TDM Generate DDL generates correctly the following:
ALTER TABLE “core”.“contact_address” ADD CONSTRAINT “pk_contact_address” PRIMARY KEY (“contact_address_id”,“contact_address_type_id”)
The current definition has:
CREATE TABLE core.contact_address
( contact_address_id uuid …

CONSTRAINT pk_contact_address PRIMARY KEY (contact_address_id)

The Sync and Convert incorrectly generates
ALTER TABLE “core”.“contact_address” ADD CONSTRAINT “pk_contact_address” PRIMARY KEY (“contact_address_type_id”)




can you send us your models to please? We are not able to reproduce it. Thank you,