Am Montag, 24. Juli 2006 17:13 schrieb Tom Lane: > To my mind, "ONLINE" just doesn't convey any useful information --- > the existing CREATE INDEX functionality could already be said to be > "online", in the sense that you don't have to take down the database > to do it. I thought about "SHARED" but someone could probably raise > the same objection to it. Anyone have a better idea?
CONCURRENTLY > I'm tempted to put the new keyword at the very front: > > SHARED CREATE INDEX .... > > which would probably mean that we'd have to document it as if it were a > completely separate command from CREATE INDEX, but then again that might > not be a bad thing considering how differently the two cases behave. What is so different about them that would justify this? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match