2011/11/6 Andrus <kobruleht2(at)hot(dot)ee>:
> in 8.1+ many char(n) type columns must be in uppercase in database.
> What is best way to force this ?
>
> Should insert and update triggers created for every table or is there better
> way,
> for example by creation domain or adding some attribute to column and
> creating global trigger?
A simple trigger like this should work fine. You're basically throwing
an upper() around the field in a function and calling that a trigger.
If you decided to do it in the application, then throwing a constraint
around each updated / inserted text col is pretty easy too.