Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with old relation - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: Problem with old relation
Date
Msg-id Pine.LNX.4.44.0305021820400.3847-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Problem with old relation  (Rado Petrik <r.p@szm.sk>)
List pgsql-sql
Tree view 
> 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

pgsql-sql by date:

Previous
From: Andreas Schmitz
Date:
Subject: Re: Problem with old relation
Next
From: Rajesh Kumar Mallah
Date:
Subject: timeofday() and now() issue..