Table soft validation is incorrect

The current soft validation method is defined to block any table that starts with pg_:

CartoDB-SQL-API/app/services/pg-entities-access-validator.js

Lines 52 to 59 in 91cd355

    
           softValidation(tables) { 
        
               for (let table of tables) { 
        
                   if (table.table_name.match(/\bpg_/)) { 
        
                       return false; 
        
                   } 
        
               } 
        
               return true;

So if a user has a table called pg_sth it will be blocked too. A more effective way to block access to the pg_catalog schema is to check the table schema instead (and avoid using regex).

Closing stale ticket

	softValidation(tables) {
	for (let table of tables) {
	if (table.table_name.match(/\bpg_/)) {
	return false;
	}
	}

	return true;