Ivan Sergio Borgonovo <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to