PostgreSQL 9.1 SPI

[Puneet Kishor]

On Apr 2, 2012, at 3:38 PM, Phil Dobbin wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 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.


--
Puneet Kishor