Mohit Sabharwal created HIVE-9309:
-------------------------------------
Summary: schematool fails on Postgres 8.1
Key: HIVE-9309
URL: https://issues.apache.org/jira/browse/HIVE-9309
Project: Hive
Issue Type: Bug
Components: Database/Schema
Reporter: Mohit Sabharwal
Assignee: Mohit Sabharwal
Postgres upgrade scripts set {{standard_conforming_strings}} which is not
allowed in 8.1:
{code}
ERROR: parameter "standard_conforming_strings" cannot be changed
(state=55P02,code=0)
{code}
Postgres [8.1 Release
notes|http://www.postgresql.org/docs/8.2/static/release-8-1.html] say that
"standard_conforming_strings value is read-only"
Postgres [8.2 notes|http://www.postgresql.org/docs/8.2/static/release-8-2.html]
say that it can be set at runtime.
It'd be nice to address this for those still using Postgres 8.1
This patch provides a schemaTool db option "postgres.filter.81" which, if set,
filters out the "standard_conforming_strings" statement from upgrade scripts.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
