Rod Taylor <[EMAIL PROTECTED]> writes: > Might get somewhere by making a special domain thats marked as being > serial, and using that in the column.
I recall some discussion last year about making serial et al. into domains over int4 and int8, rather than their current utter-hack implementation. Can't recall if we found a problem with the idea, or no one got around to doing it, or it just didn't seem to clean things up enough to be worth the trouble. (AFAICS you'd still need special-case code to set up the appropriate default expression for each column; the domain constraint mechanism wouldn't handle that for you.) Seems worth looking at, though. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])