X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5E8CB475A45 for ; Fri, 2 May 2003 08:26:23 -0400 (EDT) Received: from linux012.intern.cityweb.de (linux012.intern.cityweb.de [195.71.215.252]) by postgresql.org (Postfix) with ESMTP id 4D5684758F1 for ; Fri, 2 May 2003 08:26:22 -0400 (EDT) Received: from zahedi.intern.cityweb.de (zahedi.intern.cityweb.de [193.189.226.198]) by linux012.intern.cityweb.de (8.12.8/8.12.8) with ESMTP id h42CQNsv022889; Fri, 2 May 2003 14:26:24 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Andreas Schmitz Reply-To: a.schmitz@cityweb.de Organization: Cityweb Network To: Rado Petrik , PostgreSQL-mailinglist Subject: Re: Problem with old relation Date: Fri, 2 May 2003 14:08:07 +0200 User-Agent: KMail/1.4.1 References: <1051878034.29270.7.camel@caj> In-Reply-To: <1051878034.29270.7.camel@caj> MIME-Version: 1.0 Message-Id: <200305021408.07667.a.schmitz@cityweb.de> Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-38.9 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/18 X-Sequence-Number: 13183 Hi, you also have to drop the sequence. drop sequence kokot_kokot_seq; regards -andreas On Friday 02 May 2003 14:20, Rado Petrik wrote: > Hi, > > 1) When I create new table expample. > > CREATE TABLE "kokot" ( > "kokot" SERIAL ); > > > 2) and then DROP table kokot .. > > 3) and then again CREATE table > > CREATE TABLE "kokot" ( > "kokot" SERIAL ); > > PostgreSQL return this error > > PostgreSQL said: ERROR: Relation 'kokot_kokot_seq' already exists > Your query: > CREATE TABLE "kokot" ( > "kokot" SERIAL ); > > Where is problem ? > Thanks > > Rado --=20 Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email a.schmitz@cityweb.de