Hi,
I am currently in the middle of porting a custom package to work with oracle. This custom package was created with postgresql as the db backend.
One little and possibly trivial issue I encountered is with the limit Oracle imposes on view and table names. Table and view names greater than 30 characters return "identifier too long" errors.
As much as possible I would not like to shorten or change any of these view or table names on fear of breaking it when it runs in pg.
Has anyone encountered this ?
Comments and suggestions ?
Thanks