X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7F62F4753A1
	for <pgsql-sql@postgresql.org>; Thu, 20 Feb 2003 11:47:40 -0500 (EST)
Received: from postgresql.org ([64.49.215.8])
	by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with
	SMTP id 34338-07 for <pgsql-sql@postgresql.org>;
	Thu, 20 Feb 2003 11:47:27 -0500 (EST)
Received: from smtp013.mail.yahoo.com (smtp013.mail.yahoo.com
 [216.136.173.57])
	by postgresql.org (Postfix) with SMTP id 05A7E475B33
	for <pgsql-sql@postgresql.org>; Thu, 20 Feb 2003 11:40:44 -0500 (EST)
Received: from 219-88-55-118.dialup.xtra.co.nz (HELO singlarc01)
	(arun?jaisankar@219.88.55.118 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 20 Feb 2003 16:40:48 -0000
Message-ID: <00fa01c2d8fe$c7918210$020000c0@singlarc01>
From: "Arunachalam Jaisankar" <arun_jaisankar@yahoo.com>
To: <pgsql-sql@postgresql.org>
Subject: How to drop all the sequences
Date: Fri, 21 Feb 2003 05:40:27 +1300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00F5_01C2D96B.BD008090"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200302/462
X-Sequence-Number: 11860

This is a multi-part message in MIME format.

------=_NextPart_000_00F5_01C2D96B.BD008090
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I found sequences are not getting dropped when tables are dropped. It is to=
o difficult to drop all sequences one by one manually. Is there any command=
 to drop all sequences in a database? Looking for help.

regards
Jaisankar

------=_NextPart_000_00F5_01C2D96B.BD008090
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>I found sequences are not getting dropped =
when=20
tables are dropped. It is too difficult to drop all sequences one by one=20
manually. Is there any command to drop all sequences in a database? Looking=
 for=20
help.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jaisankar</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></FONT></DIV></BODY></H=
TML>

------=_NextPart_000_00F5_01C2D96B.BD008090--