Cascade drop pg tables to overcome key constraints when dropping

[dbsrgits/SQL-Translator.git] / t / 49xml-to-pg-samefield.t

diff --git a/t/49xml-to-pg-samefield.t b/t/49xml-to-pg-samefield.t
index 4fb029d..4ec2644 100644 (file)
--- a/t/49xml-to-pg-samefield.t
+++ b/t/49xml-to-pg-samefield.t
@@ -33,14 +33,14 @@ my $sql = $sqlt->translate(
 ) or die $sqlt->error;
 
 is($sql, << "SQL");
-DROP TABLE "one";
+DROP TABLE "one" CASCADE;
 CREATE TABLE "one" (
   "same" character varying(100) DEFAULT 'hello' NOT NULL
 );
 
 
 
-DROP TABLE "two";
+DROP TABLE "two" CASCADE;
 CREATE TABLE "two" (
   "same" character varying(100) DEFAULT 'hello' NOT NULL
 );