"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> And if your 'name prediction' code can't deal with collisions, then
> it needs help.
THe point is that right now, if you know the CREATE TABLE command, then
you can compute exactly what index names it will assign --- no outside
knowledge about the previous state of the database is required.
I'm not sure how significant that really is to anyone, but it is
something that we'd be giving up.
And as I said, I don't have a better answer. I'm just expressing
vague unease, in hopes that it might spur someone to think of another
way. I'm willing to go with this way if we don't find another.
regards, tom lane