Vince Vielhaber <vev(at)michvhf(dot)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