I don't know why i wrote the '+1' in there when I wrote the email. I'm not using it in the actual statement. The specific syntax error is that the ( is invalid.
On 1/12/07, Matt Quackenbush <[EMAIL PROTECTED]> wrote: > > Okay, so far I'm *really* liking Pg. I have successfully imported all of > my tables and data, and have everything fixed with one exception: updating > the currval() of the sequence for the 'auto_number' fields. I can go > through each sequence one at a time with the GUI and update it, but I'd > obviously prefer to do so via script. Here's what I've tried, but it throws > a syntax error: > > ALTER SEQUENCE seq_name RESTART WITH (SELECT max(id) + 1 FROM table_name); > > Apparently it does not like the query to be used as the value. I'm still > reading through the docs to see if I can find where/how to do what I'm > trying to do, but figured I'd cheat and post back to you guys as well. > > > Thanks, > > Matt > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
