test + fix for Oracle multi-column constraint generation

[dbsrgits/SQL-Translator.git] / t / 30sqlt-new-diff-pgsql.t

diff --git a/t/30sqlt-new-diff-pgsql.t b/t/30sqlt-new-diff-pgsql.t
index 5fd1440..052f58d 100644 (file)
--- a/t/30sqlt-new-diff-pgsql.t
+++ b/t/30sqlt-new-diff-pgsql.t
@@ -40,7 +40,7 @@ my $out = SQL::Translator::Diff::schema_diff(
     $target_schema,
    'PostgreSQL',
    {
-     producer_options => {
+     producer_args => {
          quote_table_names => 0,
      }
    }
@@ -66,7 +66,7 @@ ALTER TABLE employee DROP COLUMN job_title;
 
 ALTER TABLE new_name ADD COLUMN new_field integer;
 
-ALTER TABLE person ADD COLUMN is_rock_star smallint DEFAULT '1';
+ALTER TABLE person ADD COLUMN is_rock_star smallint DEFAULT 1;
 
 ALTER TABLE person ALTER COLUMN person_id TYPE serial;
 
@@ -98,7 +98,7 @@ $out = SQL::Translator::Diff::schema_diff(
     $source_schema, 'PostgreSQL', $target_schema, 'PostgreSQL',
     { ignore_index_names => 1,
       ignore_constraint_names => 1,
-      producer_options => {
+      producer_args => {
          quote_table_names => 0,
          quote_field_names => 0,
       }
@@ -121,7 +121,7 @@ ALTER TABLE employee DROP COLUMN job_title;
 
 ALTER TABLE new_name ADD COLUMN new_field integer;
 
-ALTER TABLE person ADD COLUMN is_rock_star smallint DEFAULT '1';
+ALTER TABLE person ADD COLUMN is_rock_star smallint DEFAULT 1;
 
 ALTER TABLE person ALTER COLUMN person_id TYPE serial;
 
@@ -133,9 +133,9 @@ ALTER TABLE person ALTER COLUMN iq TYPE bigint;
 
 ALTER TABLE person RENAME COLUMN description TO physical_description;
 
-ALTER TABLE person ADD CONSTRAINT "UC_person_id3" UNIQUE (person_id);
+ALTER TABLE person ADD CONSTRAINT "UC_person_id" UNIQUE (person_id);
 
-ALTER TABLE person ADD CONSTRAINT "UC_age_name3" UNIQUE (age, name);
+ALTER TABLE person ADD CONSTRAINT "UC_age_name" UNIQUE (age, name);
 
 DROP TABLE deleted CASCADE;