Thom Brown <thom(at)linux(dot)com> writes:
> I suspected this may have been discussed previously, I just failed to find
> it. And yes, it's purely for simplification, and to auto-clean sequences
> when tables are dropped. I didn't think it would be straightforward, but
> clearly there are show-stoppers abound.
The latest thread I can find on the matter is
http://archives.postgresql.org/pgsql-general/2008-11/msg00825.php
although I seem to remember others.
regards, tom lane