pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Rado Petrik <r.p@szm.sk>
To: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Subject: Problem with old relation
Date: 02 May 2003 14:20:34 +0200
Message-ID: <1051878034.29270.7.camel@caj> (raw)

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>

view thread (3+ messages)  latest in thread

Message-ID: <1051878034.29270.7.camel@caj>
Permalink:  ../1051878034.29270.7.camel@caj/
Also on:    postgresql.org/message-id/1051878034.29270.7.camel@caj

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: r.p@szm.sk
  Subject: Re: Problem with old relation
  In-Reply-To: <1051878034.29270.7.camel@caj>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox