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

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

Thanks,
John

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, September 01, 2010 5:30 PM
To: Turner, John J
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] 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