Sfrgttk

How do living politicians protect their readily obtainable signatures from misuse?

Co-worker has annoying ringtone

What is Adi Shankara referring to when he says "He has Vajra marks on his feet"?

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

Sentence order: Where to put もう

Is there any word for a place full of confusion?

Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?

Who can remove European Commissioners?

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

Strange behavior of Object.defineProperty() in JavaScript

How to plot logistic regression decision boundary?

Sum letters are not two different

One-one communication

How to add group product into the cart individually?

How to play a character with a disability or mental disorder without being offensive?

How does the math work when buying airline miles?

How were pictures turned from film to a big picture in a picture frame before digital scanning?

What would you call this weird metallic apparatus that allows you to lift people?

Generate an RGB colour grid

Why weren't discrete x86 CPUs ever used in game hardware?

File name problem(?)

What was the first language to use conditional keywords?

Aligning an equation at multiple points, with both left and right alignment, as well as equals sign alignment

Belief In God or Knowledge Of God. Which is better?

Installing Postgresql parray_gin extension on mac, include not found

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

1

I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build.

I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode command line tools, and now it's complaining about

/Library/PostgreSQL/10/include/postgresql/server/utils/pg_locale.h:19:10: 

fatal error: 'unicode/ucol.h' file not found

After some Googling it appeared I needed to install an extra library, which I did through brew install icu4c

This printed:

This formula is keg-only, which means it was not symlinked into /usr/local,

because macOS provides libicucore.dylib (but nothing else).



If you need to have this software first in your PATH run:

    echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile

    echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile



For compilers to find this software you may need to set:

    LDFLAGS:  -L/usr/local/opt/icu4c/lib

    CPPFLAGS: -I/usr/local/opt/icu4c/include

But it didn't change a thing and I have no idea how to pass /usr/local/opt/icu4c/include to pgxn

postgresql installation mac-os-x postgresql-10 postgresql-extensions

share|improve this question

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

bumped to the homepage by Community♦ 3 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

1

I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build.

I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode command line tools, and now it's complaining about

/Library/PostgreSQL/10/include/postgresql/server/utils/pg_locale.h:19:10: 

fatal error: 'unicode/ucol.h' file not found

After some Googling it appeared I needed to install an extra library, which I did through brew install icu4c

This printed:

This formula is keg-only, which means it was not symlinked into /usr/local,

because macOS provides libicucore.dylib (but nothing else).



If you need to have this software first in your PATH run:

    echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile

    echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile



For compilers to find this software you may need to set:

    LDFLAGS:  -L/usr/local/opt/icu4c/lib

    CPPFLAGS: -I/usr/local/opt/icu4c/include

But it didn't change a thing and I have no idea how to pass /usr/local/opt/icu4c/include to pgxn

postgresql installation mac-os-x postgresql-10 postgresql-extensions

share|improve this question

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

bumped to the homepage by Community♦ 3 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I am trying to install parray_gin in PostgreSQL 10 on macOS, but I can't get it to build.

I'm running pgxn install parray_gin. This first gave me a missing stdio.h error, so I installed the xcode command line tools, and now it's complaining about

/Library/PostgreSQL/10/include/postgresql/server/utils/pg_locale.h:19:10: 

fatal error: 'unicode/ucol.h' file not found

After some Googling it appeared I needed to install an extra library, which I did through brew install icu4c

This printed:

This formula is keg-only, which means it was not symlinked into /usr/local,

because macOS provides libicucore.dylib (but nothing else).



If you need to have this software first in your PATH run:

    echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile

    echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile



For compilers to find this software you may need to set:

    LDFLAGS:  -L/usr/local/opt/icu4c/lib

    CPPFLAGS: -I/usr/local/opt/icu4c/include

But it didn't change a thing and I have no idea how to pass /usr/local/opt/icu4c/include to pgxn

postgresql installation mac-os-x postgresql-10 postgresql-extensions

share|improve this question

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

/Library/PostgreSQL/10/include/postgresql/server/utils/pg_locale.h:19:10: 

fatal error: 'unicode/ucol.h' file not found

This formula is keg-only, which means it was not symlinked into /usr/local,

because macOS provides libicucore.dylib (but nothing else).



If you need to have this software first in your PATH run:

    echo 'export PATH="/usr/local/opt/icu4c/bin:$PATH"' >> ~/.bash_profile

    echo 'export PATH="/usr/local/opt/icu4c/sbin:$PATH"' >> ~/.bash_profile



For compilers to find this software you may need to set:

    LDFLAGS:  -L/usr/local/opt/icu4c/lib

    CPPFLAGS: -I/usr/local/opt/icu4c/include

share|improve this question

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

share|improve this question

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

edited Feb 28 '18 at 9:27

Paul White♦

54.3k14288461

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

asked Feb 28 '18 at 8:16

Joris MansJoris Mans

1062

1 Answer
1

active

oldest

votes

0

You need to manually download the sources and edit the Makefile

Add this:

PG_CPPFLAGS = "-I/usr/local/opt/icu4c/include"

SHLIB_LINK =  "-L/usr/local/opt/icu4c/lib"

and it works

https://github.com/theirix/parray_gin/issues/5

share|improve this answer

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f199000%2finstalling-postgresql-parray-gin-extension-on-mac-include-not-found%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

You need to manually download the sources and edit the Makefile

Add this:

PG_CPPFLAGS = "-I/usr/local/opt/icu4c/include"

SHLIB_LINK =  "-L/usr/local/opt/icu4c/lib"

and it works

https://github.com/theirix/parray_gin/issues/5

share|improve this answer

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

add a comment | 

0

You need to manually download the sources and edit the Makefile

Add this:

PG_CPPFLAGS = "-I/usr/local/opt/icu4c/include"

SHLIB_LINK =  "-L/usr/local/opt/icu4c/lib"

and it works

https://github.com/theirix/parray_gin/issues/5

share|improve this answer

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

add a comment | 

You need to manually download the sources and edit the Makefile

Add this:

PG_CPPFLAGS = "-I/usr/local/opt/icu4c/include"

SHLIB_LINK =  "-L/usr/local/opt/icu4c/lib"

and it works

https://github.com/theirix/parray_gin/issues/5

share|improve this answer

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

PG_CPPFLAGS = "-I/usr/local/opt/icu4c/include"

SHLIB_LINK =  "-L/usr/local/opt/icu4c/lib"

share|improve this answer

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062

answered Feb 28 '18 at 13:04

Joris MansJoris Mans

1062