X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 14548474E5C for ; Fri, 21 Feb 2003 03:04:29 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 38563-07 for ; Fri, 21 Feb 2003 03:04:18 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 5BFF7474E4F for ; Fri, 21 Feb 2003 03:04:18 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 85DC143A670; Fri, 21 Feb 2003 03:04:17 -0500 (EST) From: Oleg Samoylov X-Newsgroups: comp.databases.postgresql.sql Subject: Re: How to drop all the sequences Date: Fri, 21 Feb 2003 11:04:16 +0300 Organization: MIPT Telecom Lines: 11 Message-ID: <3E55DD80.3010900@telecom.mipt.ru> References: <00fa01c2d8fe$c7918210$020000c0@singlarc01> Mime-Version: 1.0 Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 X-Accept-Language: ru, en To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/472 X-Sequence-Number: 11870 Arunachalam Jaisankar wrote: > I found sequences are not getting dropped when tables are dropped. It is to= > regards > Jaisankar In 7.3 sequence created automatically by serial field must be dropped with table. -- Olleg Samoylov