is there a way to reindex a sequence?
if so how and is it in the curent
docs?
Mike
"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,
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