> > * 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.