cancel
Showing results for 
Search instead for 
Did you mean: 

Case Insensitive

SOLVED
Adventurer

Case Insensitive

Hi,

After converting the entire schema from Oracle to EDB Postgres using EDB Migration toolkit, kept the Oracase for all identifiers except for packages, functions, procedures, and inserted into database,

 

1.) Is there ways to keep the references of identifiers (table names, column names, views, etc.) in the packages, functions, procedures case-insensitive or all upper case instead of having to double quotes every identifiers (table names, column names, views) in the pl/pgsql scripts so that there is no references issues.  

 

2.)  Is there ways to enable/disable case sensitivity in EDB Postgres?

 

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
EDB Team Member

Re: Case Insensitive

Hi Angie,

 

Please find the answers inline :

 

1.) Is there ways to keep the references of identifiers (table names, column names, views, etc.) in the packages, functions, procedures case-insensitive or all upper case instead of having to double quotes every identifiers (table names, column names, views) in the pl/pgsql scripts so that there is no references issues.  

>> If the reference objects in the function, procedure or package are migrated keeping the ORACASE, then you need to also call them using that case only. Otherwise, it may give you an error like table or that object not found while calling it. 

 

2.)  Is there ways to enable/disable case sensitivity in EDB Postgres?

>> No, as far as I know, there is no upfront way or setting that can be used to enable or disable the case sensitivity on Postgres.

 
1 REPLY 1
EDB Team Member

Re: Case Insensitive

Hi Angie,

 

Please find the answers inline :

 

1.) Is there ways to keep the references of identifiers (table names, column names, views, etc.) in the packages, functions, procedures case-insensitive or all upper case instead of having to double quotes every identifiers (table names, column names, views) in the pl/pgsql scripts so that there is no references issues.  

>> If the reference objects in the function, procedure or package are migrated keeping the ORACASE, then you need to also call them using that case only. Otherwise, it may give you an error like table or that object not found while calling it. 

 

2.)  Is there ways to enable/disable case sensitivity in EDB Postgres?

>> No, as far as I know, there is no upfront way or setting that can be used to enable or disable the case sensitivity on Postgres.