"mike" wrote:
>is there a way to reindex a sequence?
>if so how and is it in the curent docs?
If you wish to reset its value, the function is setval().
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
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 are
"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, pl
is there a way to reindex a sequence?
if so how and is it in the curent
docs?
Mike
