Re: How to drop all the sequences

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Arunachalam Jaisankar <arun_jaisankar(at)yahoo(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to drop all the sequences
Date: 2003-03-06 04:36:20
Message-ID: 200303060436.h264aLS12419@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Neil Conway wrote:
> On Thu, 2003-02-20 at 11:40, Arunachalam Jaisankar wrote:
> > I found sequences are not getting dropped when tables are dropped.
>
> SERIAL sequences should automatically be dropped with their
> corresponding table in PostgreSQL 7.3.0 and later.
>
> > It is too difficult to drop all sequences one by one manually. Is
> > there any command to drop all sequences in a database?
>
> No. You could try iterating through pg_class, picking out the sequence
> relations (relkind = 'S') in the right database, and then dropping the
> sequences that way.

As I remember, a 7.2 database loaded into 7.3 doesn't have the
dependency linkage. /contrib/adddepend adds such linkage in 7.3 for
pre-7.3 database loaded into 7.3.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-03-06 05:20:21 Re: [HACKERS] problems with dropped columns
Previous Message Madhavi Daroor 2003-03-06 04:07:41 Sequence Of Dates ( Posting 2nd Time)