summaryrefslogtreecommitdiff
path: root/contrib/earthdistance
Commit message (Collapse)AuthorAgeFilesLines
* Refer to ll_to_earth() function by its actual name.Tom Lane2004-10-041-2/+3
|
* > Please find enclose a submission to fix these problems.Bruce Momjian2004-08-201-5/+9
| | | | | | | | | | | | | | | | | | | | | | > > The patch adds missing the "libpgport.a" file to the installation under > "install-all-headers". It is needed by some contribs. I install the > library in "pkglibdir", but I was wondering whether it should be "libdir"? > I was wondering also whether it would make sense to have a "libpgport.so"? > > It fixes various macros which are used by contrib makefiles, especially > libpq_*dir and LDFLAGS when used under PGXS. It seems to me that they are > needed to > > It adds the ability to test and use PGXS with contribs, with "make > USE_PGXS=1". Without the macro, this is exactly as before, there should be > no difference, esp. wrt the vpath feature that seemed broken by previous > submission. So it should not harm anybody, and it is useful at least to me. > > It fixes some inconsistencies in various contrib makefiles > (useless override, ":=" instead of "="). Fabien COELHO
* Remove incorrect remark about having to restart backend to load a newTom Lane2003-12-271-6/+0
| | | | version of a shared library.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* pgindent run.Bruce Momjian2003-08-041-6/+7
|
* Update contrib regression tests for recent error message editing.Tom Lane2003-08-011-1/+1
|
* Error message editing in contrib (mostly by Joe Conway --- thanks Joe!)Tom Lane2003-07-242-15/+12
|
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-142-4/+2
| | | | | | only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
* The attached patches change earthdistance to use the new cube functionsBruce Momjian2003-02-132-24/+24
| | | | | | | | | | | | | | | in one of the earth functions so that latitude and longitude to cartesian coordinates conversion will be more accurrate. (Previously a text string was built to provide as input which limited the accuracy to the number of digits printed.) The new functions were included in a recent patch to contrib/cube that has not as yet been accepted as of yet. I also added check constraints to the domain 'earth' since they are now working in 7.4. Bruno Wolff III
* Clean up format of SQL.Bruce Momjian2002-11-082-274/+274
|
* The attached patch defines functions for getting distances betweenBruce Momjian2002-11-085-57/+1266
| | | | | | | | | | | | points on the surface of the earth and locating points within a specified distance using an index based on the contrib/cube package. The new functions are all of language type sql. A couple of bugs in the old earthdistance function based on the point datatype are fixed. A regression test has been added for both sets of functions. The README file has been updated to include documentation on the new stuff. There are comments about how this package is also useful for Astronomers. Bruno Wolff III
* When I removed the cube based stuff from eathdistance I accidentallyBruce Momjian2002-10-212-2/+2
| | | | | | | | | left a reference to cube in a comment in the regression test (that also shows up in the expected output). This doesn't cause any real problem, but people who read the comment might be confused. Attached is a diff to remove the reference. Bruno Wolff III
* SET autocommit no longer needed in /contrib because pg_regress.sh doesBruce Momjian2002-10-211-1/+0
| | | | it automatically now on regression session startup.
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-183-64/+60
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Shouldn't be here ...Tom Lane2002-09-251-158/+0
|
* Install proper earthdistance file, regression passes.Bruce Momjian2002-09-251-255/+0
|
* Add missing earthdistance regression test files.Bruce Momjian2002-09-252-0/+458
|
* Add earthdistance regression file.Bruce Momjian2002-09-241-0/+158
|
* I have included fixes to declare some floating point constants as doubleBruce Momjian2002-09-204-16/+30
| | | | | | | | | | | | instead of int, change the calculation method to use the haversine formula which is more accurrate for short distances, added a grant to public for geo_distance and added a regression test. I will resubmit the earth distance stuff based on cube after 7.3 is released. Bruno Wolff III
* To fix the perpetually broken makefiles in the contrib tree, I havePeter Eisentraut2001-09-061-35/+6
| | | | | | written a generic framework of rules that the contrib makefiles can use instead of writing their own each time. You only need to set a few variables and off you go.
* geo_distance function needs to be marked strict.Tom Lane2001-08-161-1/+2
| | | | From Mark Stosberg.
* The attached patch enables the contrib subtree to build cleanly underBruce Momjian2001-06-181-1/+2
| | | | | | | | | | | | | | | | | | | | | Cygwin with the possible exception of mSQL-interface. Since I don't have mSQL installed, I skipped this tool. Except for dealing with a missing getopt.h (oid2name) and HUGE (seg), the bulk of the patch uses the standard PostgreSQL approach to deal with Windows DLL issues. I tested the build aspect of this patch under Cygwin and Linux without any ill affects. Note that I did not actually attempt to test the code for functionality. The procedure to apply the patch is as follows: $ # save the attachment as /tmp/contrib.patch $ # change directory to the top of the PostgreSQL source tree $ patch -p0 </tmp/contrib.patch Jason
* Playing with the earthdistance stuff, and found I needed the followingBruce Momjian2001-05-301-2/+2
| | | | | | patch: Larry Rosenman
* pgindent run. Make it all clean.Bruce Momjian2001-03-221-1/+1
|
* Make sure -L and -I's for our source tree are always before system includePeter Eisentraut2001-02-201-2/+2
| | | | or library directories on the command line.
* Restructure the key include files per recent pghackers discussion: thereTom Lane2001-02-101-5/+4
| | | | | | | | | | | are now separate files "postgres.h" and "postgres_fe.h", which are meant to be the primary include files for backend .c files and frontend .c files respectively. By default, only include files meant for frontend use are installed into the installation include directory. There is a new make target 'make install-all-headers' that adds the whole content of the src/include tree to the installed fileset, for use by people who want to develop server-side code without keeping the complete source tree on hand. Cleaned up a whole lot of crufty and inconsistent header inclusions.
* Add support for VPATH builds, that is, building somewhere else than in thePeter Eisentraut2000-10-201-2/+3
| | | | | | | | | source directory. This involves mostly makefiles using $(srcdir) when they might have used ".". (Regression tests don't work with this, yet.) Sort out usage of CPPFLAGS, CFLAGS (and CXXFLAGS). Add "override" keyword in most places, to preserve necessary flags even when the user overrode the flags.
* Another round of those unportable config/build changes :-/Peter Eisentraut2000-07-091-34/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Add option to build with OpenSSL out of the box. Fix thusly exposed bit rot. Although it compiles now, getting this to do something useful is left as an exercise. * Fix Kerberos options to defer checking for required libraries until all the other libraries are checked for. * Change default odbcinst.ini and krb5.srvtab path to PREFIX/etc. * Install work around for Autoconf's install-sh relative path anomaly. Get rid of old INSTL_*_OPTS variables, now that we don't need them anymore. * Use `gunzip -c' instead of g?zcat. Reportedly broke on AIX. * Look for only one of readline.h or readline/readline.h, not both. * Make check for PS_STRINGS cacheable. Don't test for the header files separately. * Disable fcntl(F_SETLK) test on Linux. * Substitute the standard GCC warnings set into CFLAGS in configure, don't add it on in Makefile.global. * Sweep through contrib tree to teach makefiles standard semantics. ... and in completely unrelated news: * Make postmaster.opts arbitrary options-aware. I still think we need to save the environment as well.
* Makefile cleanup from Karel.Bruce Momjian2000-07-041-2/+2
|
* Remove old README files.Bruce Momjian2000-06-191-0/+0
|
* Add missing /contrib filesBruce Momjian2000-06-191-0/+31
|
* Update to /contrib from Karel.Bruce Momjian2000-06-193-34/+3
|
* Cleanup README Makefile installs.Bruce Momjian2000-06-161-3/+3
|
* Add missing /contrib files to CVS.Bruce Momjian2000-06-151-0/+23
|
* /contrib patch from Karel.Bruce Momjian2000-06-153-35/+53
|
* pgindent run over code.Bruce Momjian1999-05-251-22/+27
|
* Add FAQ_CVS.Bruce Momjian1998-06-164-0/+134