Re: sequence indexes

On Fri, 25 Jan 2002, Tom Lane wrote:

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

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@michvhf.com    http://www.pop4.net        56K Nationwide Dialup from $16.00/mo
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================