Re: [BUGS] renaming+recreating table w/default sequence causes dependency seq issue

2012-08-08 Thread Todd Kover
> I don't see any bug there. The ALTER DROP DEFAULT command does not > remove the sequence's dependence on foo.id; nor for that matter > does ALTER SET DEFAULT create an auto-drop dependency on the new > table. See ALTER SEQUENCE OWNED BY if you want to dissociate a > serial column's sequen

[BUGS] renaming+recreating table w/default sequence causes dependency seq issue

2012-08-07 Thread Todd Kover
I saw issues around renaming tables and not renaming sequences in the TODO list but did not see anything about this. Apologies if I missed it. This is with a 9.1.4 server (enterprisedb download on mac os/x lion) and also seen on 9.1.3 built from netbsd pkgsrc. It appears that something is amiss