[ 
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)

Reply via email to