Re: sequence indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: sequence indexes
Date
Msg-id 5238.1011991182@sss.pgh.pa.us
Whole thread Raw
In response to sequence indexes  (Vince Vielhaber <vev@michvhf.com>)
Responses Re: sequence indexes  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-hackers
Vince Vielhaber <vev@michvhf.com> writes:
> Is it safe to drop and recreate an index used by a sequence?

Uh, sequences haven't got indexes.  You mean an index on a "serial"
column, no?  Sure, there's no magic there.  Don't forget it's a
unique index, though, if you want to have the same error checking
as before.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: sequence indexes
Next
From: Vince Vielhaber
Date:
Subject: Re: sequence indexes