X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F30sqlt-new-diff-pgsql.t;h=48cb32b5a77ec29be8c22969c7e649f8a3af92de;hb=aee4b66eb2152b7066ced4def46e0223eb1649b1;hp=eb39f015fcd5e868f04e16ffbe1c42c1727a9e2d;hpb=c50d1a0afe9acf17c421acdfae25cf050b1da92e;p=dbsrgits%2FSQL-Translator.git diff --git a/t/30sqlt-new-diff-pgsql.t b/t/30sqlt-new-diff-pgsql.t index eb39f01..48cb32b 100644 --- a/t/30sqlt-new-diff-pgsql.t +++ b/t/30sqlt-new-diff-pgsql.t @@ -25,7 +25,7 @@ my ( $source_schema, $target_schema, $parsed_sql_schema ) = map { or die $tr->error; my $out = $t->translate( catfile($Bin, qw/data diff pgsql/, $_ ) ) or die $tr->error; - + my $schema = $t->schema; unless ( $schema->name ) { $schema->name( $_ ); @@ -57,7 +57,7 @@ CREATE TABLE added ( ALTER TABLE old_name RENAME TO new_name; -ALTER TABLE employee DROP CONSTRAINT employee_employee_id_fkey; +ALTER TABLE employee DROP CONSTRAINT FK5302D47D93FE702E; ALTER TABLE person DROP CONSTRAINT UC_age_name; @@ -81,7 +81,7 @@ ALTER TABLE person RENAME COLUMN description TO physical_description; ALTER TABLE person ADD CONSTRAINT unique_name UNIQUE (name); -ALTER TABLE employee ADD FOREIGN KEY (employee_id) +ALTER TABLE employee ADD CONSTRAINT FK5302D47D93FE702E_diff FOREIGN KEY (employee_id) REFERENCES person (person_id) DEFERRABLE; ALTER TABLE person ADD CONSTRAINT UC_person_id UNIQUE (person_id);