Re: Problem with old relation

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Rado Petrik <r(dot)p(at)szm(dot)sk>
Cc: PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with old relation
Date: 2003-05-02 12:54:27
Message-ID: Pine.LNX.4.44.0305021820400.3847-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> PostgreSQL said: ERROR: Relation 'kokot_kokot_seq' already exists

In pre 7.3, you should drop the sequence as well. It is fixed in 7.3. Thus
in 7.3, if you drop a table its dependent objects like sequences, FKs are
dropped automatically.

regards,
bhuvaneswaran

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-05-02 13:14:35 timeofday() and now() issue..
Previous Message Rado Petrik 2003-05-02 12:20:34 Problem with old relation