Re: sequence indexes

On Fri, 25 Jan 2002, Tom Lane wrote:

> 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.

It's a serial column.

| vev | newclaim_newclaimid_key | index |
| vev | newclaim_newclaimid_seq | sequence |

577527808 Jan 25 14:50 newclaim_newclaimid_key

select count(*) from newclaim;
count
-----
53747
(1 row)

select max(newclaimid) from newclaim;
max
-------
9907663
(1 row)

A bit much diskspace for that, isn't it? The data turns over alot.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================