| From: | Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de> |
|---|---|
| To: | Rado Petrik <r(dot)p(at)szm(dot)sk>, PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Problem with old relation |
| Date: | 2003-05-02 12:08:07 |
| Message-ID: | 200305021408.07667.a.schmitz@cityweb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(dot)schmitz(at)cityweb(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rado Petrik | 2003-05-02 12:20:34 | Problem with old relation |
| Previous Message | Richard Huxton | 2003-05-02 08:48:35 | Re: How to write an query to get this result? |