[
https://issues.apache.org/jira/browse/MADLIB-1191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16295868#comment-16295868
]
Rahul Iyer commented on MADLIB-1191:
------------------------------------
Hi [~m_____z], thanks for bringing this to our notice.
The issue is due to a missing newline at the end of one of the files. There are
two ways for you to proceed further:
1. Wait for the v1.13 release which will have this issue fixed. The release is
in its last stages and should be available in a week or so.
2. Make a minor change in {{madlib--1.12.0.sql}} which should be available at
{{$PGHOME/share/postgresql/extension/}}, where {{$PGHOME}} is the install
location of postgres.
Around line 40464 (below the definition of function {{graph_apsp()}}) there
should be a line that has a comment like below
{code}
--------------------------------------------------------------------------------
/* -----------------------------------------------------------------------
*//**
{code}
Please add a new line before the {{/*}}:
{code}
--------------------------------------------------------------------------------
/* ----------------------------------------------------------------------- *//**
{code}
If you run {{pgxn load madlib}} after this change, I expect it to go through.
> Syntax error during pgxn load madlib
> ------------------------------------
>
> Key: MADLIB-1191
> URL: https://issues.apache.org/jira/browse/MADLIB-1191
> Project: Apache MADlib
> Issue Type: Bug
> Components: Build System
> Affects Versions: v1.12
> Reporter: Mateusz
> Assignee: Rahul Iyer
> Priority: Minor
> Fix For: v1.13
>
>
> Hi all,
> I'm trying to install MADlib on Ubuntu Server 16.04 LTS and PostgreSQL 9.5
> from PGXN:
> [https://cwiki.apache.org/confluence/display/MADLIB/Installation+Guide#InstallationGuide-PGXNInstallingfromPGXN(PostgreSQL)].
> While `{{pgxn install madlib}}` succeeded, `{{pgxn load madlib}}` aborts with
> the following error message:
> {code}
> INFO: best version: madlib 1.12.0
> ERROR: syntax error at or near "*"
> {code}
> I'm happy to provide any further information as required.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)