PostgreSQL 9.1 SPI

[Phil Dobbin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/04/2012 22:24, Puneet Kishor wrote:
> 
> On Apr 2, 2012, at 3:38 PM, Phil Dobbin wrote:

>> On 02/04/2012 20:54, Puneet Kishor wrote:
>>> I was hoping to try out the SPI extension with Postgres 9.1, which, per the documentation at http://www.postgresql.org/docs/9.1/static/contrib-spi.html is supposed to live under <path>/to/contrib. But, in my /opt/local/share/postgresql91/contrib I don't have spi. Should I be able to get this via macports, or do I just download Pg sourcecode and look within that?
>>
>> If it's not available on Mac Ports, you could try PGXN which is
>> postgresql's answer to CPAN.
>>
>> Haven't checked that it's on there but I should think so. If it is, it's
>> simply a case of installing the module when you've pointed it at the
>> right location by all accounts.
>>
> 
> 
> Interesting... didn't even know of PGXN's existence. Sadly, SPI doesn't seem to exist on PGXN. And, it also requires installing PGXN client written in Python, which, hopefully shouldn't be any more difficult that macports, but I know nothing about Python.
> 
> I downloaded the Pg source code, and that does come with the source for a boatload of contribs. But, to compile any of those extensions, I need to "run configure in the top level directory and then run `gmake all`". Well, I don't know the configure options that macports used when it installed Pg, and I don't have gmake.


I compiled my own pgsql on OS X & it built very easily. The gmake I
used, I installed from Mac Ports. But it would definitely wouldn't be
advisable to re-run configure against the postgresql you have installed
in /opt/local as you say.

Cheers,

  Phil...

- -- 
But masters, remember that I am an ass.
Though it be not written down,
yet forget not that I am an ass.

	Wm. Shakespeare - Much Ado About Nothing


-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: §auto-key-locate cert pka ldap hkp://keys.gnupg.net
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPehy1AAoJEKpMeDHWT5ADzKgIANrVvjWURYb4pFxeNjvm57Qq
zdeKq+wwMWgVd3oikH/ucfGHgbqyVDZgBhMMUoPEDer8zL40g0/AgdrIlev4w9mV
zh5u3GcWIUkTMZAvjsHdZyCZJiGhwjz5J+rPi86pWS1QIW+W0e9/BvNg6VnwvK6s
Hfi1VDXgK1SotDhCsNcwszrEJUiS1733FNqBBnz1xxB9aN6LKYE7eI57ZtmLxGx/
3fi5T/8CmQZpLIFBfbcHO4wccOIvg9S58e/8XzKDNoDLENynk/BNEEKMJ3W5eblY
emvxb1ZfdJGtp0AJLozW+9VqwnuniHbmy4Pv8Ne+RyngNxl17pzyfneS2M+0C0o=
=/ngc
-----END PGP SIGNATURE-----