Skip site navigation (1) Skip section navigation (2)

Re: sequence indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vince Vielhaber <vev(at)michvhf(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: sequence indexes
Date: 2002-01-25 20:39:42
Message-ID: 5238.1011991182@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Vince VielhaberDate: 2002-01-25 20:49:33
Subject: Re: sequence indexes
Previous:From: Vince VielhaberDate: 2002-01-25 20:24:10
Subject: sequence indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group