Re: Installing temporal "period" data type and support functions - Mailing list pgsql-novice

From Chris Browne
Subject Re: Installing temporal "period" data type and support functions
Date
Msg-id 87occhumwo.fsf@cbbrowne.afilias-int.info
Whole thread Raw
In response to Installing temporal "period" data type and support functions  ("Turner, John J" <JJTurner@statestreet.com>)
List pgsql-novice
JJTurner@statestreet.com ("Turner, John J") writes:
> You've run into an extreme greenhead here, so my thanks to you for your
> consideration.  I'm also at sea with this forum, so I'm not sure how my
> replies need to be addressed/directed in order to maintain the thread
> online?
>
> Re: postgres, I simply installed the package, not the source code.
>
> So based on that and your advice, I would need to install the
> Development package (postgresql-devel)?  I don't see anything directly
> relating to that on the Downloads site...
>
> I have a "pg_config.exe" located in c:\program
> files\PostgreSQL\9.0\bin... beyond that I'm stumped at the moment, I'm
> afraid

You shouldn't need the whole PostgreSQL source code tree.

PGTemporal, if it's code similar to...
   <http://github.com/davidfetter/PostgreSQL-Temporal>
  or
   <http://temporal.projects.postgresql.org/>
uses what's called "PGXS" to minimize the profile of how much of the
PostgreSQL sources you need around.

You can find docs on PGXS here:
    http://www.postgresql.org/docs/current/static/xfunc-c.html

It certainly does need pg_config to know how to get stuff linked into
the PostgreSQL instance; the fact you have that seems promising.

You probably want to add a line to the PGTemporal Makefile to tell it to
use PGXS.   See the one marked "cbbrowne" :-).

-----------------------------------------------
MODULES = period
DATA_built = period.sql
DATA = uninstall_period.sql

USE_PGXS=yes    # cbbrowne sez add this.  This says to use PGXS

ifdef USE_PGXS
PG_CONFIG = pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)
else
subdir = contrib/temporal
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
include $(top_srcdir)/contrib/contrib-global.mk
endif
-----------------------------------------------

You need some dev tools installed, notably suitable C compiler, GNU
Make.  I don't know how one arranges that on Windows, alas.
--
(format nil "~S@~S" "cbbrowne" "gmail.com")
The statistics on  sanity are that one out of  every four Americans is
suffering from some  form of mental illness. Think  of your three best
friends. If they're okay, then it's you. -- Rita Mae Brown

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Installing temporal "period" data type and support functions
Next
From: "Charles Holleran "
Date:
Subject: Create or replace row in table