"Sam Mason" <[EMAIL PROTECTED]> writes: > I've just discovered that an index that doesn't refer to any of its table's > columns isn't automatically dropped when its table is.
A straightforward solution would be to ban such "indexes". > p.s. the reason for creating this strange index was to ensure that a maximum > of one row was inserted into the table---I can do this different ways for > now. Please explain how you thought it would help you do that, because without some evidence that there's a use-case, I'm inclined to fix it as above ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq