Ruslan A Dautkhanov <rusland(at)scn(dot)ru> wrote:
> Hello all,
> PostgreSQL do not remove it's internal dependency when I DROP DEFAULT (it
was nextval(...)),
> so I still can't remove the sequence. Please see the real example bellow:
[ CUTTED ]
you did:
alter table ttPrefixes alter ttid DROP DEFAULT;
may be inded you should do
alter table ttPrefixes alter ttpid DROP DEFAULT;
in order to remove the serial
public.ttprefixes_ttpid_seq
Regards
Gaetano