Hi guys,
Sorry, but I don't have any time to look at this right now... I found a quoting bug in the sequence dialogue that prevents modification of them (such as resetting the value) - should be trivial to sort. I also suspect that resetting to zero won't work correctly because we need to use something like setval('foo', $INCREMENT, false) to do that, however that might require some more thought.
I found two issues, but not for the same version. ALTER SEQUENCE "TestSequenz" RESTART WITH 1; is perfectly ok for 7.4+. (but changing owner had some problems).
On 7.3, setval will be used; there, quoting used qtString instead of qtIdent. Also, I added the third setval argument as false, this seems the least surprise for users. Not checked with 7.3, please do that Dave.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
