X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 768E4475A45 for ; Fri, 2 May 2003 08:20:30 -0400 (EDT) Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150]) by postgresql.org (Postfix) with ESMTP id 9C3DB4758F1 for ; Fri, 2 May 2003 08:20:29 -0400 (EDT) Received: from [193.58.192.97] (helo=juice) by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19BZGj-00013Z-00 for ; Fri, 02 May 2003 14:04:01 +0200 Received: from 192.168.1.25 ([192.168.1.25]) by juice for pgsql-sql@postgresql.org; Fri, 2 May 2003 14:20:58 +0200 Subject: Problem with old relation From: Rado Petrik To: PostgreSQL-mailinglist Content-Type: text/plain Organization: Message-Id: <1051878034.29270.7.camel@caj> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.3 Date: 02 May 2003 14:20:34 +0200 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-11.5 required=5.0 tests=BAYES_10,UPPERCASE_25_50,USER_AGENT_XIMIAN 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/17 X-Sequence-Number: 13182 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 -- Rado Petrik