Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Critical |
| Complexity | Unknown |
| Component | App - General |
| Version | 17.0 |
Postgresql version 9.5 removed 'usecatupd' column from the system table pg_users. This column was extracted in conjunction with the 'usesuper' column to determine if the user had CreateUser privilege.
|
|
66 KB
|
93 KB
|
|
88 KB
We will no longer attempt to extract 'usecatupd' column for versions 9.5 and the CreateUser privilege will be determined only by the usesuper column for versions 9.5. This will fix it so data studio will be functional again for this version of postgresql. I will file a seperate issue to have PM work done to support version 9.5 of postgres and its enhancements.
For PostgreSQL 9.5.3 version :
In ADS 17.0.7, When we try to extract(Alter or Drop) a User no exception occurs. User Altered and dropped successfully.
In Previous ADS builds, "org.postgresql.util.PSQLException: ERROR: column "usecatupd" does not exist" exception occurs in view log when we try to extract a User.
Please refer attached screen-shots "14475_ADS17.0.7.png" and "14475_ADS17.0.4-8.png" .
I have also verified other user scenarios for verifying this issue, they are mentioned in attached "14475_Test cases.xlsx" file.
For PostgreSQL 9.5.3 version :
In ADS 17.0.7, When we try to extract(Alter or Drop) a User no exception occurs. User Altered and dropped successfully.
In Previous ADS builds, "org.postgresql.util.PSQLException: ERROR: column "usecatupd" does not exist" exception occurs in view log when we try to extract a User.
Please refer attached screen-shots "14475_ADS17.0.7.png" and "14475_ADS17.0.4-8.png" .
I have also verified other user scenarios for verifying this issue, they are mentioned in attached "14475_Test cases.xlsx" file.
Issue #14475 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v17.0.7 |
| No time estimate |
We will no longer attempt to extract 'usecatupd' column for versions 9.5 and the CreateUser privilege will be determined only by the usesuper column for versions 9.5. This will fix it so data studio will be functional again for this version of postgresql. I will file a seperate issue to have PM work done to support version 9.5 of postgres and its enhancements.