Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> ... BTW I saw there is no OWNED BY in 8.1, is there any other way to
> auto-drop sequences when columns get dropped?
In previous versions, a sequence object that was auto-created as a
result of a SERIAL column declaration will be auto-dropped when that
column is dropped. 8.2's OWNED BY syntax is just a way of exposing
that mechanism more formally, and letting you tweak the state.
regards, tom lane