aboutsummaryrefslogtreecommitdiff
path: root/contrib
Commit message (Collapse)AuthorAge
* It includesBruce Momjian2002-10-19
| | | | | | | | -Support for mirroring tables in different Schema's -Improved documentation for compiling with 7.1.x and 7.2.x -Fixes a buffer overrun bug. Steven Singer
* Clean up for dblink autocommit OFF handling.Bruce Momjian2002-10-18
|
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-18
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* This trivial patch fixes a bunch of spelling mistakes in theBruce Momjian2002-10-14
| | | | | | contrib/dbmirror/README.dbmirror doc file. Neil Conway
* Update README for oid2name.Bruce Momjian2002-10-12
|
* Well, this patch makes Makefile for contrib/rserv use theBruce Momjian2002-10-09
| | | | | | | | | | | | | | | contrib/contrib-global.mk library and _generally_ behave like Makefiles for other contrib modules. Besides it fixes Perl's interpolation of $libdir variable, which should be passed to backend instead. This patch is done against PostgreSQL 7.3b2 Besides, I want to thank Peter Eisentraut for his very friendly and helpful attitude and politely ask him to check whether contrib modules actually continue to work after he implements another major change to their build process. Alexey Borzov
* Avoid PQisBusy/PQconsumeInput busy loop in case of PQisBusy returningTatsuo Ishii2002-10-07
| | | | | | | | | | | | false. per Tom Lane's suggestion. See: Subject: Suggested change to pgbench From: Tom Lane <tgl@sss.pgh.pa.us> To: Tatsuo Ishii <t-ishii@sra.co.jp> Cc: pgsql-patches@postgreSQL.org Date: Sun, 06 Oct 2002 12:37:27 -0400 for more details.
* Restore NOTICEs that were mistakenly removed from triggers regressionTom Lane2002-10-03
| | | | | test expected output. Tweak contrib/spi Makefile so that refint.so is by default built with appropriate NOTICE support for regression testing.
* It's just a cosmetic change, fixes the help screen. Should be applied inBruce Momjian2002-10-03
| | | | | | /contrib/vacuumlo Mario Weilguni
* This is small README fix for contrib/intarray. Thank you.Bruce Momjian2002-10-03
| | | | Teodor Sigaev
* The attached adds a bit to the contrib/tablefunc regression test forBruce Momjian2002-10-03
| | | | | | | behavior of connectby() in the presence of infinite recursion. Please apply this one in addition to the one sent earlier. Joe Conway
* > The previous patch fixed an infinite recursion bug inBruce Momjian2002-10-03
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > contrib/tablefunc/tablefunc.c:connectby. But, other unmanageable error > seems to occur even if a table has commonplace tree data(see below). > > I would think the patch, ancestor check, should be > > if (strstr(branch_delim || branchstr->data || branch_delim, > branch_delim || current_key || branch_delim)) > > This is my image, not a real code. However, if branchstr->data includes > branch_delim, my image will not be perfect. Good point. Thank you Masaru for the suggested fix. Attached is a patch to fix the bug found by Masaru. His example now produces: regression=# SELECT * FROM connectby('connectby_tree', 'keyid', 'parent_keyid', '11', 0, '-') AS t(keyid int, parent_keyid int, level int, branch text); keyid | parent_keyid | level | branch -------+--------------+-------+---------- 11 | | 0 | 11 10 | 11 | 1 | 11-10 111 | 11 | 1 | 11-111 1 | 111 | 2 | 11-111-1 (4 rows) While making the patch I also realized that the "no show branch" form of the function was not going to work very well for recursion detection. Therefore there is now a default branch delimiter ('~') that is used internally, for that case, to enable recursion detection to work. If you need a different delimiter for your specific data, you will have to use the "show branch" form of the function. Joe Conway
* Attached is a patch to contrib/dbmirror that fixes a bug that wasBruce Momjian2002-09-26
| | | | | | | | | | causing the postmaster to crash when the trigger was running on a table without a primary key. I've also updated the docs to explicitly say that tables need primary keys. Steven Singer
* Shouldn't be here ...Tom Lane2002-09-25
|
* Install proper earthdistance file, regression passes.Bruce Momjian2002-09-25
|
* Add missing earthdistance regression test files.Bruce Momjian2002-09-25
|
* Add earthdistance regression file.Bruce Momjian2002-09-24
|
* Tweak dblink functions to use int4 arguments instead of int2,Tom Lane2002-09-23
| | | | to avoid having to write explicit casts. From Joe Conway.
* Remove extraneous | ... while bison 1.28 doesn't object, newer versionsTom Lane2002-09-22
| | | | do.
* I haven't seen any objections, so here is a patch. It removes "#defineTom Lane2002-09-22
| | | | | | | | YYERROR_VERBOSE" from contrib/cube and contrib/seg, and adjusts the expected output accordingly. Hopefully this will consistently pass across multiple bison versions. Joe Conway
* Tiny patch fixing small documentation typo.Bruce Momjian2002-09-20
| | | | Oleg Bartunov
* I have included fixes to declare some floating point constants as doubleBruce Momjian2002-09-20
| | | | | | | | | | | | 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
* This grants execute privileges to public for the fti() function. ShouldBruce Momjian2002-09-20
| | | | | | we go through and give all the contribs grants? Christopher Kings-Lynne
* Add 'adddepend' script to handle pre-7.3 object dependencies.Bruce Momjian2002-09-18
|
* Add GRANT EXECUTE ON FUNCTIONTatsuo Ishii2002-09-18
|
* Simplify handling of second database for dblink tests.Tom Lane2002-09-14
|
* Clean up mess from duplicate patches.Tom Lane2002-09-14
|
* The attached adds GRANTs to PUBLIC for dblink functions, removes theTom Lane2002-09-14
| | | | | | | | | | non-standard regression test, and adds standard installcheck regression test support. The test creates a second database (regression_slave) and drops it again, in order to avoid the cheesy-ness of connecting back to the same database ;-) Joe Conway
* The attached adds GRANTs to PUBLIC for contrib/fuzzystringmatch.Tom Lane2002-09-14
| | | | Joe Conway
* Attached is a patch to fix some recently raised issues that exist inTom Lane2002-09-14
| | | | | | | | | contrib/tablefunc. Specifically it replaces the use of VIEWs (for needed composite type creation) with use of CREATE TYPE. It also performs GRANT EXECUTE ON FUNCTION foo() TO PUBLIC for all of the created functions. There was also a cosmetic change to two regression files. Joe Conway
* Fix portability bug in get_normal_pair (RAND_MAX != MAX_RANDOM_VALUE).Tom Lane2002-09-14
| | | | Also try to improve readability and performance.
* This is a comprehensive set of diffs (versus current CVS) that replaces thoseBruce Momjian2002-09-12
| | | | | | | | | | | | attached to the same message with the Earth Distance patches. Recent changes include changing the subscript in one place I forgot in the previous bugfix patch. A couple of added regression tests, which should help catch this mistake if it reappears. I also put in a limit of 100 dimensions in cube_large and cube_in to prevent making it easy to create very large cubes. Changing one define in cubedata.h will raise the limit if some needs more dimensions. Bruno Wolff III
* > intarray and ltree both seem to be mapping their own declarations ontoBruce Momjian2002-09-12
| | | | | | | | | | > arrays using largely-similar code. But while intarray fails its > regression test, I find ltree still passes. So I'm confused about what > that code is really doing and don't want to touch it. Please, apply attached patch, it solves the problem. Teodor Sigaev
* > Now I'm testing connectby() in the /contrib/tablefunc in 7.3b1, which wouldBruce Momjian2002-09-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > be a useful function for many users. However, I found the fact that > if connectby_tree has the following data, connectby() tries to search the end > of roots without knowing that the relations are infinite(-5-9-10-11-9-10-11-) . > I hope connectby() supports a check routine to find infinite relations. > > > CREATE TABLE connectby_tree(keyid int, parent_keyid int); > INSERT INTO connectby_tree VALUES(1,NULL); > INSERT INTO connectby_tree VALUES(2,1); > INSERT INTO connectby_tree VALUES(3,1); > INSERT INTO connectby_tree VALUES(4,2); > INSERT INTO connectby_tree VALUES(5,2); > INSERT INTO connectby_tree VALUES(6,4); > INSERT INTO connectby_tree VALUES(7,3); > INSERT INTO connectby_tree VALUES(8,6); > INSERT INTO connectby_tree VALUES(9,5); > > INSERT INTO connectby_tree VALUES(10,9); > INSERT INTO connectby_tree VALUES(11,10); > INSERT INTO connectby_tree VALUES(9,11); <-- infinite > The attached patch fixes the infinite recursion bug in contrib/tablefunc/tablefunc.c:connectby found by Masaru Sugawara. test=# SELECT * FROM connectby('connectby_tree', 'keyid', 'parent_keyid', '2', 4, '~') AS t(keyid int, parent_keyid int, level int, branch text); keyid | parent_keyid | level | branch -------+--------------+-------+------------- 2 | | 0 | 2 4 | 2 | 1 | 2~4 6 | 4 | 2 | 2~4~6 8 | 6 | 3 | 2~4~6~8 5 | 2 | 1 | 2~5 9 | 5 | 2 | 2~5~9 10 | 9 | 3 | 2~5~9~10 11 | 10 | 4 | 2~5~9~10~11 (8 rows) test=# SELECT * FROM connectby('connectby_tree', 'keyid', 'parent_keyid', '2', 5, '~') AS t(keyid int, parent_keyid int, level int, branch text); ERROR: infinite recursion detected I implemented it by checking the branch string for repeated keys (whether or not the branch is returned). The performance hit was pretty minimal -- about 1% for a moderately complex test case (220000 record table, 9 level tree with 3800 members). Joe Conway
* The attached small patch fixes the cause of the regression test failureBruce Momjian2002-09-12
| | | | | | | | | | for contrib/intarray. The cause was that the library uses its own function to construct a new array, new_intArrayType, and that function did not set the new array struct attribute elemtype. Joe Conway
* The attached removes the current non-standard fileBruce Momjian2002-09-12
| | | | | | | "contrib/tablefunc/tablefunc-test.sql", and adds a standard regression test suite to contrib/tablefunc. Joe Conway
* Fix compile warning.Tom Lane2002-09-05
|
* Fix bit-rotted reference to GetUserName() ...Tom Lane2002-09-05
| | | | it's GetUserNameFromId() now.
* Fix breakage introduced by careless snprintf patching.Tom Lane2002-09-05
|
* Fix unsafe macro definitions (which were producing incorrect code,Tom Lane2002-09-05
| | | | leading to compile warnings).
* Remove compile warnings, ensure consistent build environment forTom Lane2002-09-05
| | | | largefile usage.
* Fix compile warning.Tom Lane2002-09-05
|
* findoidjoins and tsearch are not broken anymore.Tom Lane2002-09-05
|
* Fix compile errors.Tom Lane2002-09-05
|
* findoidjoins is updated for schemas, does not use libpgeasy.Tom Lane2002-09-05
| | | | From Joe Conway.
* Commenting out doesn't work, so move the broken modules out of the list.Peter Eisentraut2002-09-05
|
* Assorted fixes for Cygwin:Peter Eisentraut2002-09-05
| | | | | | | | | | | | | | | | | Eliminate the mysterious games that the Cygwin build plays with the linker flag variables. DLLLIBS is gone, use SHLIB_LINK like everyone else. Detect cygipc in configure, after the linker flags are set up, otherwise configure might not work at all. Make sure everything is covered by make clean. Fix the build of the new conversion procedure modules. Add new DLLIMPORT markers where required. Finally, the compiler complains if we use an explicit -I/usr/local/include, so don't do that. Curiously, -L/usr/local/lib is still necessary.
* Remove include of libpq-int.h --- dblink.c should not be (and was not)Tom Lane2002-09-05
| | | | depending on libpq internals.
* Be careful to include postgres.h *before* any system headers, to ensureTom Lane2002-09-05
| | | | | | that the right flavors of largefile-related definitions are seen. Most of these changes are probably unnecessary, but better safe than sorry.
* Fix compile warning.Peter Eisentraut2002-09-04
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 21:51:03 +0000