Problem with old relation

From: Rado Petrik <r(dot)p(at)szm(dot)sk>
To: PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org>
Subject: Problem with old relation
Date: 2003-05-02 12:20:34
Message-ID: 1051878034.29270.7.camel@caj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)p(at)szm(dot)sk>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A.Bhuvaneswaran 2003-05-02 12:54:27 Re: Problem with old relation
Previous Message Andreas Schmitz 2003-05-02 12:08:07 Re: Problem with old relation