[Checkins] SVN: relstorage/trunk/notes/migrate-to-1.5.txt Combine ALTER TABLE operations where possible.

Martijn Pieters mj at zopatista.com
Wed Jun 15 13:47:59 EDT 2011


Log message for revision 121954:
  Combine ALTER TABLE operations where possible.

Changed:
  U   relstorage/trunk/notes/migrate-to-1.5.txt

-=-
Modified: relstorage/trunk/notes/migrate-to-1.5.txt
===================================================================
--- relstorage/trunk/notes/migrate-to-1.5.txt	2011-06-15 17:40:27 UTC (rev 121953)
+++ relstorage/trunk/notes/migrate-to-1.5.txt	2011-06-15 17:47:59 UTC (rev 121954)
@@ -31,8 +31,9 @@
         SELECT oid FROM (
             SELECT oid, lowrite(lo_open(oid, 131072), bc.oldbytea)
             FROM lo_create(0) o(oid)) x);
-    ALTER TABLE blob_chunk ALTER COLUMN chunk SET NOT NULL;
-    ALTER TABLE blob_chunk DROP COLUMN oldbytea;
+    ALTER TABLE blob_chunk 
+        ALTER COLUMN chunk SET NOT NULL
+        DROP COLUMN oldbytea;
     COMMIT;
 
 MySQL history-preserving



More information about the checkins mailing list