Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> 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 majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly