Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0030338 | Openbravo ERP | A. Platform | public | 2015-07-10 12:49 | 2015-07-20 08:12 |
| Reporter | shuehner | ||||
| Assigned To | shuehner | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | 3.0PR15Q4 | |||
| Merge Request Status | |||||
| Review Assigned To | alostale | ||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0030338: New postgresql 9.5alpha1 has remove pg_authid.rolcatupdate column changed in openbravo install.source | ||||
| Description | Openbravo postgres database user creation done during install.source in src-db/database/build-create.xml has the following extra sql after creating the user (as db superuser) UPDATE pg_authid SET rolcatupdate=true WHERE rolname='${bbdd.user}'; That column is to give that user extra permission going being normal superuser. It was used a long time ago by core code to disable triggers+fk's without deleting them. But no known user is known. Postgres 9.5 now deleted this column as its usefulness was unclear http://www.postgresql.org/docs/devel/static/release-9-5.html [^] Remove pg_authid's rolcatupdate field, as it had no value (Adam Brightwell) However it should be fine to just delete the custom sql from build-create.xml for 2 reasons: 1.) It was not doing anything useful already before as the defaultvalue for rolcatupdate was true already if user is a superuser for all pg versions supported by openbravo 2.) Now normal superuser privs are sufficient to do the same action in case some code should still rely on that. To check this reason1 a 'create user test superuser' + select * from pg_authid i.e. on pg9.1 can be done to verify that default true value. | ||||
| Steps To Reproduce | Run install.source with postgresql 9.5alpha1 [sql] Failed to execute: UPDATE pg_authid SET rolcatupdate=true WHERE rolname='try_full_pgsql' [sql] org.postgresql.util.PSQLException: ERROR: column "rolcatupdate" of relation "pg_authid" does not exist | ||||
| Proposed Solution | Remove the extra SQL modifying that now deleted column. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-07-10 12:49 | shuehner | New Issue | |||
| 2015-07-10 12:49 | shuehner | Assigned To | => platform | ||
| 2015-07-10 12:49 | shuehner | OBNetwork customer | => No | ||
| 2015-07-10 12:49 | shuehner | Modules | => Core | ||
| 2015-07-10 12:49 | shuehner | Triggers an Emergency Pack | => No | ||
| 2015-07-10 12:49 | shuehner | Assigned To | platform => shuehner | ||
| 2015-07-13 13:55 | hgbot | Checkin | |||
| 2015-07-13 13:55 | hgbot | Note Added: 0078775 | |||
| 2015-07-13 13:55 | hgbot | Status | new => resolved | ||
| 2015-07-13 13:55 | hgbot | Resolution | open => fixed | ||
| 2015-07-13 13:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b7bb9b8e82c4430bf99e32c4e1bf2ad9784524a2 [^] | ||
| 2015-07-13 14:09 | shuehner | Review Assigned To | => alostale | ||
| 2015-07-16 12:03 | gorka_gil | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/b7bb9b8e82c4430bf99e32c4e1bf2ad9784524a2 [^] => http://code.openbravo.com/erp/devel/pi/rev/f1de6735fa9f [^] | ||
| 2015-07-16 12:03 | gorka_gil | Note Edited: 0078775 | bug_revision_view_page.php?bugnote_id=0078775#r9050 | ||
| 2015-07-20 08:12 | alostale | Note Added: 0078946 | |||
| 2015-07-20 08:12 | alostale | Status | resolved => closed | ||
| 2015-07-20 08:12 | alostale | Fixed in Version | => 3.0PR15Q4 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||