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