Re: Problem with old relation

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 a.schmitz@cityweb.de