X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F30sqlt-new-diff-pgsql.t;h=ba61ee5b10b7d752d89945f3f2115682b16b9092;hb=f19edf3642e7e41b090683ff00c87c6e3cf2094e;hp=24086ea099cb988bb47601a06ab5374cdf3b5477;hpb=8953d9e7977191db443a7b110971793e02bf92dc;p=dbsrgits%2FSQL-Translator.git diff --git a/t/30sqlt-new-diff-pgsql.t b/t/30sqlt-new-diff-pgsql.t index 24086ea..ba61ee5 100644 --- a/t/30sqlt-new-diff-pgsql.t +++ b/t/30sqlt-new-diff-pgsql.t @@ -78,6 +78,7 @@ ALTER TABLE person ALTER COLUMN age SET DEFAULT 18; ALTER TABLE person ALTER COLUMN iq TYPE bigint; ALTER TABLE person ALTER COLUMN nickname SET NOT NULL; + ALTER TABLE person ALTER COLUMN nickname TYPE character varying(24); ALTER TABLE person RENAME COLUMN description TO physical_description; @@ -136,6 +137,7 @@ ALTER TABLE person ALTER COLUMN age SET DEFAULT 18; ALTER TABLE person ALTER COLUMN iq TYPE bigint; ALTER TABLE person ALTER COLUMN nickname SET NOT NULL; + ALTER TABLE person ALTER COLUMN nickname TYPE character varying(24); ALTER TABLE person RENAME COLUMN description TO physical_description;