summaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAgeFilesLines
* Add macros for error result fields to libpq.Peter Eisentraut2003-08-244-16/+146
|
* Fix GB18030 to UTF-8 mapping tableTatsuo Ishii2003-08-241-63360/+63360
|
* Bring the makefiles up to our conventions.Peter Eisentraut2003-08-235-24/+19
|
* Enable uninstalling data files that were installed from a subdirectory ofPeter Eisentraut2003-08-231-2/+2
| | | | the source tree.
* Fix uninstall target.Peter Eisentraut2003-08-232-5/+6
|
* Correct uninstall target.Peter Eisentraut2003-08-231-2/+2
|
* Tweak grammar to use FastAppend rather than lappend when constructingTom Lane2003-08-222-4/+21
| | | | | expr_lists. This appears to be the only remaining O(N^2) bottleneck in processing many-way 'x IN (a,b,c,...)' conditions.
* Tweak processing of multiple-index-scan plans to reduce overhead whenTom Lane2003-08-222-31/+153
| | | | | | | handling many-way scans: instead of re-evaluating all prior indexscan quals to see if a tuple has been fetched more than once, use a hash table indexed by tuple CTID. But fall back to the old way if the hash table grows to exceed SortMem.
* ISpell info updatedTeodor Sigaev2003-08-211-142/+178
|
* Translation updatesPeter Eisentraut2003-08-204-250/+259
|
* Updates for array documentation, from Joe Conway.Tom Lane2003-08-193-23/+85
|
* Improve dynahash.c's API so that caller can specify the comparison functionTom Lane2003-08-199-195/+264
| | | | | | | | | | | | | as well as the hash function (formerly the comparison function was hardwired as memcmp()). This makes it possible to eliminate the special-purpose hashtable management code in execGrouping.c in favor of using dynahash to manage tuple hashtables; which is a win because dynahash knows how to expand a hashtable when the original size estimate was too small, whereas the special-purpose code was too stupid to do that. (See recent gripe from Stephan Szabo about poor performance when hash table size estimate is way off.) Free side benefit: when using string_hash, the default comparison function is now strncmp() instead of memcmp(). This should eliminate some part of the overhead associated with larger NAMEDATALEN values.
* When compiling a plpgsql trigger function, include the OID of the tableTom Lane2003-08-182-20/+37
| | | | | | | | | the trigger is attached to in the hashkey. This ensures that we will create separate compiled trees for each table the trigger is used with, avoiding possible datatype-mismatch problems if the tables have different rowtypes. This is essentially the same bug recently identified in plpython --- though plpgsql doesn't seem as prone to crash when the rowtype changes underneath it. But failing robustly is no substitute for just working.
* Done:Bruce Momjian2003-08-181-3/+3
| | | | > * -Add btree index support for reltime, tinterval, regproc (Tom)
* Fix ARRAY[] construct so that in multidimensional case, elements canTom Lane2003-08-1712-115/+105
| | | | | | | | be anything yielding an array of the proper kind, not only sub-ARRAY[] constructs; do subscript checking at runtime not parse time. Also, adjust array_cat to make array || array comply with the SQL99 spec. Joe Conway
* Clean up locktable init code per recent gripe from Kurt Roeckx.Tom Lane2003-08-172-10/+9
| | | | | No change in behavior, but old code would have failed to detect overrun of MAX_LOCKMODES.
* Somebody forgot to include any actual documentation for ADD_MISSING_FROM.Tom Lane2003-08-172-3/+11
|
* Update documentation to reflect the fact that ORDER BY, GROUP BY, etcTom Lane2003-08-174-32/+82
| | | | | are now driven by the default btree opclass, rather than assuming that particular operator names have the needed semantics.
* Fix broken markup.Tom Lane2003-08-171-1/+3
|
* Create a 'type cache' that keeps track of the data needed for any particularTom Lane2003-08-1740-491/+964
| | | | | | | | | | | datatype by array_eq and array_cmp; use this to solve problems with memory leaks in array indexing support. The parser's equality_oper and ordering_oper routines also use the cache. Change the operator search algorithms to look for appropriate btree or hash index opclasses, instead of assuming operators named '<' or '=' have the right semantics. (ORDER BY ASC/DESC now also look at opclasses, instead of assuming '<' and '>' are the right things.) Add several more index opclasses so that there is no regression in functionality for base datatypes. initdb forced due to catalog additions.
* Add to release notes.Bruce Momjian2003-08-171-0/+1
|
* Add:Bruce Momjian2003-08-171-2/+3
| | | | > * Allow PREPARE of cursors
* I almost forgot mark in docs "to_char(interval)" as deprecated function.Bruce Momjian2003-08-171-1/+6
| | | | | | | This useless routine will removed in 7.5. It's already discussed (see hackers list archive). Karel Zak
* Add:Bruce Momjian2003-08-171-2/+4
| | | | | > * Fix upper()/lower() to work for multibyte encodings >
* This patch makes two minor fixes to the docs: (1) fixes aBruce Momjian2003-08-175-18/+18
| | | | | | | | | spelling mistake in the PREPARE ref page (2) Makes some English more consistent, in the ref pages for some of the client apps (3) Adds a link to the libpq docs in the vacuumdb ref page. Neil Conway
* There is a misstatement in the CLOSE reference page, now that weBruce Momjian2003-08-171-4/+8
| | | | | | | | have cursors that might outlive their creating transactions. A patch is attached that fixes this (suggestions on better wording are welcome). Neil Conway
* Add:Bruce Momjian2003-08-171-2/+4
| | | | | > * Allow pooled connections to query prepared queries > * Allow pooled connections to close all open WITH HOLD cursors
* I just noticed that the sample pg_hba.conf in the docs doesn't containBruce Momjian2003-08-171-1/+11
| | | | | | | any use of CIDR masks - here's a patch that adds a couple of sample lines and associated comments. Andrew Dunstan
* The attached patch adds some clarification to the documentation of theBruce Momjian2003-08-171-2/+11
| | | | | | | binary format read/created by COPY BINARY. It also mentions the contrib/binarycopy module. Lee Kindness.
* Add:Bruce Momjian2003-08-171-2/+4
| | | | | > * Add ALTER DOMAIN, AGGREGATE, CONVERSION, SEQUENCE ... OWNER TO >
* Add:Bruce Momjian2003-08-171-2/+3
| | | | > * Add TRUNCATE ... CASCADE
* Add:Bruce Momjian2003-08-171-2/+3
| | | | > * Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
* (I always forget what the magic numbers 0 through 2 means for theBruce Momjian2003-08-171-2/+2
| | | | | | | | | | | | | "syslog" option.) By the way: The "virtual_host" parameter is a bad name for that particular option, I think. "Virtual host" signals that PostgreSQL will behave differently according to which IP address it's contacted (like Apache's virtual host support which makes the web-server serve different sites according to different criteria). A better word for the options would be "tcpip_listen_addr" or something like that. Troels Arvin
* Add mention of sort_mem in the restore docs.Bruce Momjian2003-08-171-1/+5
|
* Update for 7.3 tips URL.Bruce Momjian2003-08-171-3/+3
|
* Add to libpq changes made by Tom for new protocol.Bruce Momjian2003-08-171-0/+4
|
* Not needed, already in CVS.Bruce Momjian2003-08-171-299/+0
|
* Add description of error style.Bruce Momjian2003-08-161-0/+299
|
* Add mention that Kerberos 4 isn't recommended.Bruce Momjian2003-08-162-12/+17
|
* Make NEED_REENTRANT_FUNC_NAMES _require_ *_r functions, and add tests toBruce Momjian2003-08-1610-45/+182
| | | | configure to report if they are not found.
* Updated the blob regression test to actually use the getBlob/getClob methodsBarry Lind2003-08-151-5/+94
| | | | | | | and test them, in addition to testing the underlying LargeObject API methods. Modified Files: jdbc/build.xml jdbc/org/postgresql/test/jdbc2/BlobTest.java
* Fixed improper message length for the connection termination message 'X' whenBarry Lind2003-08-151-2/+2
| | | | | | | using the V3 protocol. Modified Files: jdbc1/AbstractJdbc1Connection.java
* Eliminate function start_parse_fh and macro YY_INPUTTeodor Sigaev2003-08-154-79/+0
|
* Rewrite array_cmp to not depend on deconstruct_array. Should be a littleTom Lane2003-08-151-37/+46
| | | | | faster, but more importantly does not leak memory. Still needs more work though, per my recent note to pgsql-hackers.
* Add disk rotation idea to WAL todo emails.Bruce Momjian2003-08-141-0/+139
|
* Minor copy-editing.Tom Lane2003-08-144-39/+42
|
* Adjustment for unixware threading.Bruce Momjian2003-08-141-1/+3
|
* Mark unixware as having threaded support.Bruce Momjian2003-08-141-0/+4
|
* Fix longstanding thinko in SSL protocol documentation: the server'sTom Lane2003-08-141-3/+3
| | | | initial response is 'S', not 'Y', when it is willing to do SSL.
* Add missing quotes.Tom Lane2003-08-141-4/+4
|