Re: Installing temporal "period" data type and support functions

"Turner, John J" <JJTurner(at)statestreet(dot)com> writes:
> I've since installed the postgreSQL 9.0 Beta version and have it running
> on my workstation.

> I found the temporal package at http://pgfoundry.org/projects/temporal
> which I downloaded. My question is "What do I need to do with these
> files in order to integrate the temporal support with my version of
> PostgreSQL?"

> I see some .c files, .html files, etc., but I'm at a loss as to how to
> get these tied into the platform. Any help greatly appreciated.

How did you install Postgres ... build from source, or install a
distribution's package? If the former, you probably have everything
you need, if the latter, maybe not. You will need Postgres' developer
support files (typically in a separate subpackage such as
postgresql-devel), as well as a C compiler and related tools. Make
sure you have a program called pg_config in your path, and that the
directory "pg_config --includedir-server" points to contains a bunch of
files.

Once you've got everything, building the extension from source code
should be a matter of "make" and "make install". You might have to do
the "make install" as root depending on where the files are going.
If "make" fails it's most likely because you're missing some tools.

After that, run the installed temporal.sql file in whichever database(s)
you want the datatype and functions available in. This part needs to be
done as database superuser.

regards, tom lane