Finger or brain trouble, here is the correction :
>NUMBER -> INTEGER when transporting schemas from Oracle to Pg.>(This needs a little care - as NUMBER in Oracle has
bigger*precision*
than INTEGER in Pg)
Thinking about this a bit more, its probably fine to just substitute
NUMERIC for NUMBER, but obviously INTEGER is going to perform better if
it can be used.
regards
Mark