Postgres Pro
Downloads
Home   >   mailing lists

drop table failed to drop associated sequence - Mailing list pgsql-admin

From Juan Rojas
Subject drop table failed to drop associated sequence
Date
Msg-id 6D0F8E8EB31A634BB06697807A87942243061A@obiwan.lan.tiba.com
Whole thread Raw
Responses Re: drop table failed to drop associated sequence  (Henry House <hajhouse@houseag.com>)
List pgsql-admin
Tree view

Hi,
I'm running PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96.
I have a problem when I drop a table which contains a serial field. The system drops the table but the associated sequence still remains in the catalog, so if I want to create the table again with the same structure, CREATE TABLE throws an error because the sequence that it's trying to create already exists.

If somebody has the same same problem, or has the solution, please tell me.
Best regards,
Juan

________________________________________
Juan Rojas
mailto: j.rojas@tiba.com

pgsql-admin by date:

Previous
From: Bhuvan A
Date:
Subject: Re: Mirroring ENTIRE DATABASE.
Next
From: Henry House
Date:
Subject: Re: drop table failed to drop associated sequence