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