summaryrefslogtreecommitdiff
path: root/contrib
AgeCommit message (Collapse)Author
2002-07-05Add a few new lines to display recently added fields in the ControlFileThomas G. Lockhart
structure. Now includes the following new fields: integer/float date/time storage maximum length of names (+1; they must also include a null termination) maximum number of function arguments maximum length of locale name
2002-07-05Cleanup.Bruce Momjian
2002-07-03Disable pg_upgrade for 7.3.Bruce Momjian
2002-06-23Link dbmirror into /contrib system.Bruce Momjian
2002-06-23Add dbmirror to /contrib. Minor C cleanups and Makefile.Bruce Momjian
Steven Singer
2002-06-23Add indexing for isbn and issn.Bruce Momjian
Dan Weston
2002-06-23Update dbsize documentation with:Bruce Momjian
Copy this directory to contrib/dbsize in your PostgreSQL source tree. Then just run make; make install. Finally, load the functions into any database using dbsize.sql. When computing the size of a table, it does not include TOAST or index disk space.
2002-06-23Rename command to reindexdb, for consistency.Bruce Momjian
2002-06-23Handle mixed-case names in reindex script.Bruce Momjian
Document need for reindex in SGML docs.
2002-06-22uint -> uint32, portability.Bruce Momjian
2002-06-21Add mention of segmented files to oid2name.Bruce Momjian
2002-06-21Add reindex utility to /contrib.Bruce Momjian
Shaun Thomas <sthomas@townnews.com>
2002-06-20Update copyright to 2002.Bruce Momjian
2002-06-13Mention vacuum for relpages.Bruce Momjian
2002-06-13Add script to show disk space per db.Bruce Momjian
2002-06-12Improve query.Bruce Momjian
2002-06-12Add mention of query showing pages used.Bruce Momjian
2002-06-12Add -q option to oid2name. Add sample session to README.Bruce Momjian
2002-06-07Please apply attached patch to contrib/intarray (7.2, 7.3).Bruce Momjian
Fixed bug with '=' operator for gist__int_ops and define '=' operator for gist__intbig_ops opclass. Now '=' operator is consistent with standard 'array' type. Thanks Achilleus Mantzios for bug report and suggestion. Oleg Bartunov
2002-05-28Fix a bug with building rtree_gist indexes.Tom Lane
Patch from Teodor Sigaev.
2002-05-27Update dblink to work with qualified relation names.Tom Lane
From Joe Conway.
2002-05-20Restructure indexscan API (index_beginscan, index_getnext) perTom Lane
yesterday's proposal to pghackers. Also remove unnecessary parameters to heap_beginscan, heap_rescan. I modified pg_proc.h to reflect the new numbers of parameters for the AM interface routines, but did not force an initdb because nothing actually looks at those fields.
2002-05-20Update docs about new -N optionTatsuo Ishii
2002-05-03Remove the last traces of datatypes datetime and timespan.Tom Lane
2002-04-25Implement types regprocedure, regoper, regoperator, regclass, regtypeTom Lane
per pghackers discussion. Add some more typsanity tests, and clean up some problems exposed thereby (broken or missing array types for some built-in types). Also, clean up loose ends from unknownin/out patch.
2002-04-24I've improved the contributed vacuumlo command, now it behaves like all otherBruce Momjian
postgres command line utilites e.g. supports -U, -p, -h, -?, -v, password prompt and has a "test mode". In test mode, no large objects are removed, just reported. Mario Weilguni
2002-04-24Attached is an update to contrib/dblink. Please apply if there are noBruce Momjian
objections. Major changes: - removed cursor wrap around input sql to allow for remote execution of INSERT/UPDATE/DELETE - dblink now returns a resource id instead of a real pointer - added several utility functions I'm still hoping to add explicit cursor open/fetch/close support before 7.3 is released, but I need a bit more time on that. On a somewhat unrelated topic, I never got any feedback on the unknownin/out patch and the mb_substring patch. Is there anything else I need to do to get those applied? Joe Conway
2002-04-24Update to my2pg 1.24.Bruce Momjian
2002-04-17Opclasses live in namespaces. I also took the opportunity to createTom Lane
an 'opclass owner' column in pg_opclass. Nothing is done with it at present, but since there are plans to invent a CREATE OPERATOR CLASS command soon, we'll probably want DROP OPERATOR CLASS too, which suggests that a notion of ownership would be a good idea.
2002-04-09Update pg_upgrade for 7.3.Bruce Momjian
2002-04-04Update to new version of Oracle conversion utility, version 1.8.Bruce Momjian
Gilles DAROLD
2002-04-02Fix contrib/dbsize for schema-qualified table names.Tom Lane
2002-03-30Further cleanups for relations in schemas: teach nextval and otherTom Lane
sequence functions how to cope with qualified names. Same code is also used for int4notin, currtid_byrelname, pgstattuple. Also, move TOAST tables into special pg_toast namespace.
2002-03-19> > Users of contrib/tsearch needs after upgrading of module (compiling, ↵Bruce Momjian
installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov
2002-03-19> > Users of contrib/tsearch needs after upgrading of module (compiling, ↵Bruce Momjian
installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov
2002-03-11Pleas apply it for 7.2.1 and current CVS.Bruce Momjian
Patch fixes using lc.lang instead of lc.lc_ctype. Teodor Sigaev
2002-03-11Back out this for Peter:Bruce Momjian
> This simple patch fixes broken Makefile, broken ApplySnapshot and > makes all utilities honour --verbose command line option. > > -- > Yours, Alexey V. Borzov, Webmaster of RDW.ru >
2002-03-06This simple patch fixes broken Makefile, broken ApplySnapshot andBruce Momjian
makes all utilities honour --verbose command line option. -- Yours, Alexey V. Borzov, Webmaster of RDW.ru
2002-03-06Change made to elog:Bruce Momjian
o Change all current CVS messages of NOTICE to WARNING. We were going to do this just before 7.3 beta but it has to be done now, as you will see below. o Change current INFO messages that should be controlled by client_min_messages to NOTICE. o Force remaining INFO messages, like from EXPLAIN, VACUUM VERBOSE, etc. to always go to the client. o Remove INFO from the client_min_messages options and add NOTICE. Seems we do need three non-ERROR elog levels to handle the various behaviors we need for these messages. Regression passed.
2002-03-05Please, apply attached patch for contrib/tsearch to 7.2.1 and currentBruce Momjian
CVS. It fix english stemmer's problem with ending words like 'technology'. We have found one more bug in english stemmer. The bug is with 'irregular' english words like 'skies' -> 'sky'. Please, apply attached cumulative patch to 7.2.1 and current CVS instead previous one. Thank to Thomas T. Thai <tom@minnesota.com> for hard testing. This kind of bug has significance only for dump/reload database and viewing, but searching/indexing works right. Teodor Sigaev
2002-03-05Currently, contrib/oid2name doesn't bother to free() the memory that itBruce Momjian
malloc()'s. This isn't too serious (because oid2name is a short-lived utility, so the memory will soon be returned to the OS on process termination), but I still think it's poor style. This patch changes oid2name so that it allocates memory on the stack where possible and free()s the remaining heap-allocated memory. The patch also fixes a typo a comment and adds 'const' qualifiers to a few 'char *' function parameters. Neil Conway
2002-02-25Try to make makefile actually work ...Tom Lane
2002-02-25Fix typo in Makefile.Bruce Momjian
2002-02-25Fix typo in filename.Bruce Momjian
2002-02-25Add integer aggregator to /contrib.Bruce Momjian
mlw
2002-02-24Add -N option which disables updation of branches and tellers tables.Tatsuo Ishii
So there would be less contention with -N, that might be more realistic test.
2002-02-22I've written on like that a while ago:Bruce Momjian
http://webmail.postgresql.org/~petere/dbsize.html The tarball can be rolled into contrib -- now that I think of it I don't know why I never did that. Never imagined this would have anything to do with that TODO item, though. I figured oid2name accomplished that. Peter Eisentraut peter_e@gmx.net
2002-02-22Please, apply attached patch of contrib/btree_gist to 7.2.1 and currentBruce Momjian
cvs. The patch fixes memory leak during creation GiST index on timestamp column. Thank you. -- Teodor Sigaev teodor@stack.net
2002-02-22More wording improvement.Bruce Momjian
2002-02-22Improve wording of meaning of /contrib directory.Bruce Momjian