pentaho timestamp issue

2018-03-18 Thread PropAAS DBA
Pinging the list on the off chance someone has dealt with this and knows of a workaroud. We have pentaho pointing to a PostgreSQL v10.3 database, getting this error: 2018/03/18 15:06:37 - INPUT STEP - Fact.0 - Timestamp : Unable to get timestamp from resultset at index 55 2018/03/18 15:06:3

system catalog permissions

2018-02-26 Thread PropAAS DBA
All; We have a client which is segmenting their multi-tenant cluster (PostgreSQL 9.6) by schema, however if one of their clients connects via pgadmin they see ALL schemas, even the ones they don't have access to read. I assume pgadmin is pulling the list from the system catalogs. What's th