Changes between Version 151 and Version 152 of RemovingTheMagic

Timestamp:

May 30, 2006, 9:23:23 AM (18 years ago)

Author:

Adrian Holovaty

Comment:

Updated PostgreSQL migration SQL to work for Postgres 7.x

RemovingTheMagic

@@ -186 +186 @@
 
 ALTER TABLE auth_permission DROP COLUMN package;
+
+-- First try this:
 ALTER TABLE django_content_type DROP CONSTRAINT "content_types_package_fkey";
-ALTER TABLE django_content_type RENAME COLUMN package TO app_label;
-ALTER TABLE django_content_type ALTER COLUMN app_label TYPE varchar(100);
+-- If that didn't work, do this:
+ALTER TABLE django_content_type DROP CONSTRAINT "$1";
+
+ALTER TABLE django_content_type ADD COLUMN app_label varchar(100);
+UPDATE django_content_type SET app_label=package;
+ALTER TABLE django_content_type ALTER COLUMN app_label SET NOT NULL;
+ALTER TABLE django_content_type DROP COLUMN package;
 
 DROP TABLE packages;