Problem with old relation - Mailing list pgsql-sql

From Rado Petrik
Subject Problem with old relation
Date
Msg-id 1051878034.29270.7.camel@caj
Whole thread Raw
Responses Re: Problem with old relation
Re: Problem with old relation
List pgsql-sql
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 <r.p@szm.sk>



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: How to write an query to get this result?
Next
From: Andreas Schmitz
Date:
Subject: Re: Problem with old relation