[SQL] Problem with old relation

[Rado Petrik]

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 <[EMAIL PROTECTED]>


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [SQL] Problem with old relation

[Andreas Schmitz]

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

-- 
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email [EMAIL PROTECTED]


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])