Re: I am done - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: I am done
Date
Msg-id 1030985127.8617.121.camel@jester
Whole thread Raw
In response to Re: I am done  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > * 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.




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: I am done
Next
From: Bruce Momjian
Date:
Subject: Re: I am done