Re: Bug in sequence dependency checking - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in sequence dependency checking
Date
Msg-id 28840.1053442515@sss.pgh.pa.us
Whole thread Raw
In response to Bug in sequence dependency checking  (Ruslan A Dautkhanov <rusland@scn.ru>)
List pgsql-bugs
Ruslan A Dautkhanov <rusland@scn.ru> writes:
>  PostgreSQL do not remove it's internal dependency when I DROP DEFAULT
>  (it was nextval(...)), so I still can't remove the sequence.

Ideally we'd prevent you from doing DROP DEFAULT, too.  That's mucking
with the internals of the SERIAL implementation.  Drop the column if you
don't want it anymore.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Ruslan A Dautkhanov
Date:
Subject: Bug in sequence dependency checking
Next
From: "Gaetano Mendola"
Date:
Subject: Primary key duplicated: NUMBER OF INDEX' TUPLES (21539) IS NOT THE SAME AS HEAP (18607)'