Andrew Dunstan <[EMAIL PROTECTED]> writes: > Actually, looking back in the email history I see Tom suggested this, > which I'll try instead:
>> prepend _, truncate to less than 64 bytes if necessary, >> then substitute numbers at the end if needed to get something unique. Your idea of multiple underscores seems just as reasonable, maybe more so. Either way, remember that the truncation needs to be multibyte-aware. regards, tom lane ---------------------------(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