Hannu Krosing <[EMAIL PROTECTED]> writes:
> I remember that discussion, but I'm surprised that something got
> implemented and accepted into core with so many unsolvable
> problems/logical inconsistencies/new pitfalls.
The current behavior of ALTER ADD COLUMN & SET DEFAULT is per SQL spec.
If you feel it's inconsistent, take it up with the standards committee.
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
