[Checkins] SVN: relstorage/branches/1.2/ PostgreSQL: use the documented ALTER SEQUENCE RESTART WITH

[Shane Hathaway]

Log message for revision 104436:
  PostgreSQL: use the documented ALTER SEQUENCE RESTART WITH
  statement instead of ALTER SEQUENCE START WITH.
  

Changed:
  U   relstorage/branches/1.2/CHANGES.txt
  U   relstorage/branches/1.2/relstorage/adapters/postgresql.py

-=-
Modified: relstorage/branches/1.2/CHANGES.txt
===================================================================
--- relstorage/branches/1.2/CHANGES.txt	2009-09-22 19:24:54 UTC (rev 104435)
+++ relstorage/branches/1.2/CHANGES.txt	2009-09-22 20:17:11 UTC (rev 104436)
@@ -1,7 +1,8 @@
 Next bugfix release
 -------------------
 
-- ...
+- PostgreSQL: use the documented ALTER SEQUENCE RESTART WITH
+  statement instead of ALTER SEQUENCE START WITH.
 
 1.2.0 (2009-09-04)
 ------------------

Modified: relstorage/branches/1.2/relstorage/adapters/postgresql.py
===================================================================
--- relstorage/branches/1.2/relstorage/adapters/postgresql.py	2009-09-22 19:24:54 UTC (rev 104435)
+++ relstorage/branches/1.2/relstorage/adapters/postgresql.py	2009-09-22 20:17:11 UTC (rev 104436)
@@ -167,7 +167,7 @@
             -- Create a special transaction to represent object creation.
             INSERT INTO transaction (tid, username, description) VALUES
                 (0, 'system', 'special transaction for object creation');
-            ALTER SEQUENCE zoid_seq START WITH 1;
+            ALTER SEQUENCE zoid_seq RESTART WITH 1;
             """)
         self._open_and_call(callback)