Re: Unable to drop sequence due to dependency? - Mailing list pgsql-general

From Glen Parker
Subject Re: Unable to drop sequence due to dependency?
Date
Msg-id 49AF2FF9.3040807@nwlink.com
Whole thread Raw
In response to Re: Unable to drop sequence due to dependency?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Glen Parker <glenebob@nwlink.com> writes:
>> For some reason I got into my head the notion that a sequence could be
>> dropped even if reference by a field default.  This seems pretty silly now.
>
> It was true once upon a time, but we have an enforcement mechanism now
> to catch that.  Did you find the default you needed to get rid of?
> That 2604 row should be it.


I did find it.  2604 is "pg_attrref", which now that you point it out
makes a certain amount of sense, but I would have had no idea what to do
with that an hour ago.

Thanks :-)

-Glen


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to drop sequence due to dependency?
Next
From: Ow Mun Heng
Date:
Subject: Re: Smartest way to resize a column?