From ef7a5cf274fd9ed999b3b5968a6bdb9da70d4d1f Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Sun, 2 Mar 2008 16:41:29 +0000 Subject: [PATCH] Don't CASCADE on TRUNCATE, not available in old versions of Postgres. --- maintenance/postgres/mediawiki_mysql2postgres.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/maintenance/postgres/mediawiki_mysql2postgres.pl b/maintenance/postgres/mediawiki_mysql2postgres.pl index 8a3bb2c488..eb87eebf51 100644 --- a/maintenance/postgres/mediawiki_mysql2postgres.pl +++ b/maintenance/postgres/mediawiki_mysql2postgres.pl @@ -9,7 +9,6 @@ ## If having UTF-8 problems, there are reports that adding --compatible=postgresql ## may help. - use strict; use warnings; use Data::Dumper; @@ -275,7 +274,7 @@ $verbose and warn qq{Writing truncates to empty existing tables\n}; for my $t (@torder, 'objectcache', 'querycache') { next if $t eq '---'; my $tname = $special{$t}||$t; - printf qq{TRUNCATE TABLE %-20s CASCADE;\n}, qq{"$tname"}; + printf qq{TRUNCATE TABLE %-20s\n}, qq{"$tname"}; } print "\n\n"; -- 2.20.1