> > * Have SERIAL generate non-colliding sequence names when we have > > auto-destruction > > > > They should be pretty well non-colliding now. What's the gripe exactly? > > The issue was that when there were name collisions, we threw an error > instead of trying other sequence names. We had to do that because we > needed the sequence name to be predictable so it could be auto-deleted. > Now with dependency, we don't need to have it be predictable. However, > we still use nextval() on the sequence name, so we can't say it is > arbitrary either. Should we just remove the item?
The names are relied on by pg_dump for setting the next value of the sequence. That is, it relies on the names being generated the exact same way every time. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
