[GENERAL] reindexing sequences

2001-04-02 Thread mike
is there a way to reindex a sequence? if so how and is it in the curent docs? Mike

Re: [GENERAL] reindexing sequences

2001-04-02 Thread Tom Lane
"mike" [EMAIL PROTECTED] writes: is there a way to reindex a sequence? Sequences don't have indexes, so they don't need reindexing. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [GENERAL] reindexing sequences

2001-04-02 Thread Richard Huxton
From: "mike" [EMAIL PROTECTED] is there a way to reindex a sequence? if so how and is it in the curent docs? Mike Reindex a sequence? Not sure what you mean by that. You can set the value to something else: select setval('mysequence',12345); If you mean compact the values used so there