hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-9309) schematool fails on Postgres 8.1
Date Tue, 13 Jan 2015 00:19:34 GMT

     [ https://issues.apache.org/jira/browse/HIVE-9309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Brock Noland updated HIVE-9309:
-------------------------------
       Resolution: Fixed
    Fix Version/s: 0.15.0
           Status: Resolved  (was: Patch Available)

Thank you Mohit! I have committed this to trunk!

> 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
>             Fix For: 0.15.0
>
>         Attachments: HIVE-9309.patch
>
>
> 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)

Mime
View raw message