summaryrefslogtreecommitdiff
path: root/contrib
Commit message (Collapse)AuthorAgeFilesLines
* OpenFTS vs Tsearch2 commentTeodor Sigaev2003-08-061-1/+12
|
* Add documentation about ts_debugTeodor Sigaev2003-08-061-28/+27
|
* Add ts_debug function for debugging configurationsTeodor Sigaev2003-08-064-0/+52
|
* Fix some copyright notices that weren't updated. Improve copyright toolTom Lane2003-08-0410-11/+11
| | | | so it won't miss 'em again.
* Update vacuumlo to be properly schema-aware. Improve documentation.Tom Lane2003-08-042-20/+31
|
* Sub-Makefiles need to explicitly add CFLAGS_SL to CFLAGS, else theirTom Lane2003-08-043-0/+3
| | | | object files do not get built with -fpic.
* Fix to build correctly outside source tree.Tom Lane2003-08-044-5/+5
|
* make sub-Makefiles in the sub-directoriesTeodor Sigaev2003-08-044-12/+86
|
* Docs fixesTeodor Sigaev2003-08-041-127/+137
|
* Update copyrights to 2003.Bruce Momjian2003-08-041-2/+2
|
* pgindent run.Bruce Momjian2003-08-0472-6138/+7778
|
* Fix for Alpha portability.Tom Lane2003-08-011-5/+5
|
* Update contrib regression tests for recent error message editing.Tom Lane2003-08-018-22/+22
|
* Add missing #include.Tom Lane2003-08-011-0/+1
|
* Fix some minor portability issues, per Chris K-L.Tom Lane2003-08-012-12/+12
|
* dbf2pg - Insert xBase-style .dbf-files into a PostgreSQL-tableBruce Momjian2003-07-313-11/+23
| | | | | | | | | | | | | | | | | | | | | | | | There is an option "-s oldname=newname", which changes the old field name of the dbf-file to the newname in PostgeSQL. If the length of the new name is 0, the field is skiped. If you want to skip the first field of the dbf-file, you get the wildest error-messages from the backend. dbf2pg load the dbf-file via "COPY tablename FROM STDIN". If you skip the first field, it is an \t to much in STDIN. A fix could be an counter j=0, which increments only, if a field is imported (IF (strlen(fields[h].db_name)> 0) j++. And only if j > 1 (if an other field is imported) the \t is printed. An other small bug in the README: -s start Specify the first record-number in the xBase-file we will insert. should be -e start Specify the first record-number in the xBase-file we will insert. Thomas Behr
* A visit from the message-style police ...Tom Lane2003-07-281-2/+3
|
* Updatge to skip composite types.Bruce Momjian2003-07-271-1/+1
|
* Adjust oid2name to skip certain row types, per Tom.Bruce Momjian2003-07-271-1/+1
|
* elog mop-up.Tom Lane2003-07-272-6/+1
|
* elog mop-up.Tom Lane2003-07-278-19/+3
|
* Remove unportable // comments.Tom Lane2003-07-271-6/+7
|
* Cleanup of timetravel compile warnings.Bruce Momjian2003-07-271-4/+3
|
* Here is 4 file in tgz:Bruce Momjian2003-07-275-209/+432
| | | | | | | | | | | | | | | | | | | | | | | | the new timetravel.c, new timetravel.README (cut from spi/README and modified), modified timetravel.sql.in and modified timetravel.example. Features: - optionally 3 parameter for insert/update/delete user name - work with CREATE UNIQUE INDEX ixxx on table xxx (unique_field,time_off); (the original version was work with unique index on 6.5.0-6.5.3, and not work on 7.3.2,7.3.3) (before 6.5.0 and between 6.5.3 and 7.3.2 I dont know) - get_timetravel(tablename) function for check timetravel-status. - timetravel trigger not change oid of the active record. (it is not a good feature, because the old version is automatice prevent the paralel update with "where oid=nnn") B?jthe Zolt?n
* > Am Son, 2003-06-22 um 02.09 schrieb Joe Conway:Bruce Momjian2003-07-277-61/+309
| | | | | | | | | | | | | | | | | | | >>Sounds like all that's needed for your case. But to be complete, in >>addition to changing tablefunc.c we'd have to: >>1) come up with a new function call signature that makes sense and does >>not cause backward compatibility problems for other people >>2) make needed changes to tablefunc.sql.in >>3) adjust the README.tablefunc appropriately >>4) adjust the regression test for new functionality >>5) be sure we don't break any of the old cases >> >>If you want to submit a complete patch, it would be gratefully accepted >>-- for review at least ;-) > > Here's the patch, at least for steps 1-3 Nabil Sayegh Joe Conway
* Fix for Linux startup script.Bruce Momjian2003-07-261-1/+2
| | | | Slawomir Sudnik
* Fix a few portability issues, adjust error messages.Tom Lane2003-07-243-7/+1
|
* Error message editing in contrib (mostly by Joe Conway --- thanks Joe!)Tom Lane2003-07-2473-652/+1447
|
* Add tsearch2.Tom Lane2003-07-242-1/+7
|
* Remove link of tarballTeodor Sigaev2003-07-221-2/+1
|
* Mark tsearch v1 as deprecatedTeodor Sigaev2003-07-221-0/+6
|
* Fix output to psql:tsearch2.sql:13: NOTICE: ... "pg_ts_dict_pkey"Teodor Sigaev2003-07-211-10/+13
|
* tsearch2 moduleTeodor Sigaev2003-07-2163-0/+16908
|
* Fix subpath and subltree. Allow to return '' value.Teodor Sigaev2003-07-182-8/+9
| | | | subpath(ltree,0,0) returns ''.
* Update contrib/Makefile's list of subdirectories that it does not tryTom Lane2003-06-301-1/+4
| | | | to build.
* Put back inappropriately-removed entry for earthdistance subdirectory.Tom Lane2003-06-301-1/+2
|
* Group ISBN/ISSN definitions.Bruce Momjian2003-06-281-36/+24
|
* Back out rserv changes that would allow limit of replicated tables ---Bruce Momjian2003-06-252-19/+5
| | | | not ready yet.
* 'third' -> 'fourth' where needed, per Joe Conway.Tom Lane2003-06-251-2/+2
|
* Includes:Bruce Momjian2003-06-251-2/+1
| | | | | | | | | | | | | | | | - LIKE <subtable> [ INCLUDING DEFAULTS | EXCLUDING DEFAULTS ] - Quick cleanup of analyze.c function prototypes. - New non-reserved keywords (INCLUDING, EXCLUDING, DEFAULTS), SQL 200X Opted not to extend for check constraints at this time. As per the definition that it's user defined columns, OIDs are NOT inherited. Doc and Source patches attached. -- Rod Taylor <rbt@rbt.ca>
* Attached is a patch that provides *VERY* limited support for multipleBruce Momjian2003-06-252-5/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | slave servers. I haven't tested it very well, so use at your own risk (and I recommend against using it in production). Basically, I have a central database server that has 4 summary tables inside it replicated to a remote slave (these database tables are for my mail server authentication, so these are replicated to another server tuned for many connections, and so I don't have postgres connections opened straight to my back-end database server). Unfortunately, I also wanted to implement a replication database server for hot-backups. I realized, too late, that the replication process is pretty greedy and will try to replicate all tables marked as a "MasterAddTable". To make a long story, I made a patch to RServ.pm and Replicate that allows you to specify, on the command line, a list of tables that you want to replicate...it'll ignore all others. I haven't finished, since this has to be integrated with CleanLog for instance, but this should (and does) suffice for the moment. I have yet to test it with two slaves, but at least my mail server replication database now works (it was failing every time it tried to replicate, for a variety of reasons). Anyone have any suggestions on how to improve on this? (or, if someone more familiar with this code wants to take the ball and run with it, you're welcome to). -- Michael A Nachbaur <mike@nachbaur.com>
* - Corrections for tables, columns with uppercase charactersBruce Momjian2003-06-252-31/+95
| | | | | | | | | | | | | | | | | | | | | | | - Don't attempt to convert partial or expressional unique indexes - Don't attempt to convert unique indexes based on a non-default opclasses - Untested prevention of conversion of non-btree indexes unique indexes. Untested as postgresql doesn't allow hash, gist, or rtree based indexes to be unique. rbt=# create unique index t on a using hash (col); ERROR: DefineIndex: access method "hash" does not support UNIQUE indexes rbt=# create unique index t on a using gist (col); ERROR: DefineIndex: access method "gist" does not support UNIQUE indexes rbt=# select version(); version ------------------------------------------------------------------------ PostgreSQL 7.4devel on i386-unknown-freebsd4.8, compiled by GCC 2.95.4 Rod Taylor
* Please apply attached patch to contrib/dblink. It adds named persistentBruce Momjian2003-06-2510-614/+855
| | | | | | connections to dblink. Shridhar Daithanka
* Jim C. Nasby wrote:Bruce Momjian2003-06-243-7/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > Second argument to metaphone is suposed to set the limit on the > number of characters to return, but it breaks on some phrases: > > usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from > (select 'Hello world'::varchar AS a) a; > HLW | HLWR | HLWRLT > > usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from > (select 'A A COMEAUX MEMORIAL'::varchar AS a) a; > AKM | AKMKS | AKMKSMMRL > > In every case I've found that does this, the 4th and 5th letters are > always 'KS'. Nice catch. There was a bug in the original metaphone algorithm from CPAN. Patch attached (while I was at it I updated my email address, changed the copyright to PGDG, and removed an unnecessary palloc). Here's how it looks now: regression=# select metaphone(a,4) from (select 'A A COMEAUX MEMORIAL'::varchar AS a) a; metaphone ----------- AKMK (1 row) regression=# select metaphone(a,5) from (select 'A A COMEAUX MEMORIAL'::varchar AS a) a; metaphone ----------- AKMKS (1 row) Joe Conway
* Replace cryptic 'Unknown kind of return type' messages with somethingTom Lane2003-06-152-9/+3
| | | | hopefully a little more useful.
* New patch with corrected README attached.Bruce Momjian2003-06-123-12/+56
| | | | | | Also quickly added mention that it may be a qualified schema name. Rod Taylor
* Add Linux restart --- Slawomir SudnikBruce Momjian2003-06-121-3/+7
| | | | Add "-l $PGLOG" for restart --- Darko Prenosil
* This patch updates pg_autovacuum in several ways:Bruce Momjian2003-06-124-656/+1049
| | | | | | | | | | | | | | | | | | | | | | | | | * A few bug fixes * fixes solaris compile and crash issue * decouple vacuum analyze and analyze thresholds * detach from tty (dameonize) * improved logging layout * more conservative default configuration * improved, expanded and updated README please apply and 1st convenience, or before code freeze which ever comes first :-) At this point I think I have brought pg_autovacuum and its client side design as far as I think it should go. It works, keeping file sizes in check, helps performance and give the administrator a fair amount flexibility in configuring it. Next up is to do the FSM based design that is integrated into the back end. p.s. Thanks to Christopher Browne for his help. Matthew T. O'Connor
* Update expected file to match new _int.sql.Tom Lane2003-06-111-2/+2
|
* Add missing intarray files.Bruce Momjian2003-06-116-0/+2750
|
View Lorry Controller Status