Postgres Pro
Downloads
Home   >   mailing lists

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  (Andreas Schmitz <a.schmitz@cityweb.de>)
Re: Problem with old relation  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-sql
Tree view 
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