aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Release note wording improvements.Bruce Momjian2005-12-08
|
* Wrap UTF-8 paragraph.Bruce Momjian2005-12-08
|
* Update wording of translation bug item.Bruce Momjian2005-12-08
|
* Update for 8.1.1.Bruce Momjian2005-12-08
|
* Update release notes for 8.1.1.Bruce Momjian2005-12-08
|
* Add Teodor:Bruce Momjian2005-12-08
| | | | > * Teodor is Teodor Sigaev <teodor@sigaev.ru>
* Remove a few people:Bruce Momjian2005-12-08
| | | | | | < * Claudio is Claudio Natoli <claudio.natoli@memetrics.com> 1166d1164 < * Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
* FAQ_AIX in 8.1.0 contains outdated information about how to deal withBruce Momjian2005-12-08
| | | | | | | postgres problems due to readline. The attached patch replaces that section of it with better ways of handling the problem. Seneca Cunningham
* there's a paragraph in the ALTER TABLE reference page that reads:Bruce Momjian2005-12-08
| | | | | | | | | | | | | | | | | | | | | DROP CONSTRAINT This form drops constraints on a table. Currently, constraints on tables are not required to have unique names, so there may be more than one constraint matching the specified name. All matching constraints will be dropped. To my knowledge, it is no longer possible to create constraints with the same name for the same relation. When you create a constraint and specify the same name explictly, an error is raised. Implicit constraint creation won't choose an existing name either and up to now you could not rename a constraint. Renaming works with the patch I sent in a few hours ago but this patch as well won't allow constraints with identical names on the same relation. The attached patch thus removes the note in the docs. Joachim Wieland
* > 1) I'm proposing a patch to do the DROP FUNCTION argument tab completion.Bruce Momjian2005-12-08
| | | | | | | | | | | | | | | | | | | | | | | | | | > Now, the arguments of the drop function can be tab completed. for example > > drop function strpos ( > <press tab> > drop FUNCTION strpos (text, text) > > or: > > wsdb=# drop FUNCTION length ( > bit) bytea) character) lseg) path) text) > <press c> > wsdb# DROP FUNCTION length ( character) > > I think that this patch should be rather useful. At it least I hate > always to type all the arguments of the dropped functions. > > 2) Also some fixes applied for the > CREATE INDEX syntax > > now the parenthesises are inserted by tab pressing. > suppose I have the table q3c: Sergey E. Koposov
* Put [] around default value for port number.Peter Eisentraut2005-12-08
|
* Remove empty heading row in error table.Bruce Momjian2005-12-08
|
* Add missing translation markerPeter Eisentraut2005-12-08
|
* Add "Constant" column to error code table.Bruce Momjian2005-12-08
| | | | | | Also, better mark section headings. kdio@uenf.br
* Documentation fix: s/event_object_name/event_object_table/gPeter Eisentraut2005-12-08
|
* Fix bgwriter's failure to release buffer pins and open files after anTom Lane2005-12-08
| | | | | error. This probably explains bug #2099 and could also account for mysterious VACUUM hangups.
* I recently received the Debian bug report below about missing iconvBruce Momjian2005-12-08
| | | | | | | | | support for the dbf2pg contrib module. The submitter created a patch which replaces the silent ignoring of -F (when iconv support is disabled) with a meaningful warning. Martin Pitt
* Add documentation about the inability of plpsql to use parameter namesBruce Momjian2005-12-08
| | | | that are the same as column names used in the function.
* Disble some Win32-specific code in win32-client-only builds:Bruce Momjian2005-12-08
| | | | | | | | | | | | | | | | | | | | | | | | | | I have the problem, when building by MS-VC6. An error occurs in the 8.1.0 present source codes. nmake -f win32.mak ..\..\port\getaddrinfo.c(244) : error C2065: 'WSA_NOT_ENOUGH_MEMORY' ..\..\port\getaddrinfo.c(342) : error C2065: 'WSATYPE_NOT_FOUND' This is used by winsock2.h. However, Construction of a windows base is winsock.h. Then, Since MinGW has special environment, this is right. but, it is not found in VC6. Furthermore, in getaddrinfo.c, IPV6-API is used by LoadLibraryA("ws2_32"); Referring to of dll the external memory generates this violation by VC6 specification. I considered whether the whole should have been converted into winsock2. However, Now, DLL of MinGW creation operates wonderfully as it is. That's right, it has pliability by replacement of simple DLL. Then, I propose the system using winsock(non IPV6) in construction of VC6. Hiroshi Saito
* Fix thinko in comment.Tom Lane2005-12-08
|
* Improve tag recognizingTeodor Sigaev2005-12-08
|
* Push the responsibility for handling ignore_killed_tuples down intoTom Lane2005-12-07
| | | | | | _bt_checkkeys(), instead of checking it in the top-level nbtree.c routines as formerly. This saves a little bit of loop overhead, but more importantly it lets us skip performing the index key comparisons for dead tuples.
* A couple of tiny performance hacks in _bt_step(). Remove PageIsEmptyTom Lane2005-12-07
| | | | | | | | | checks, which were once needed because PageGetMaxOffsetNumber would fail on empty pages, but are now just redundant. Also, don't set up local variables that aren't needed in the fast path --- most of the time, we only need to advance offnum and not step across a page boundary. Motivated by noticing _bt_step at the top of OProfile profile for a pgbench run.
* Update:Bruce Momjian2005-12-07
| | | | | | < at initdb time or optionally later. > at initdb time or optionally later. Consider O_SYNC when > O_DIRECT exists.
* Fix incorrect SPI example, per Yoshihisa Nakano.Tom Lane2005-12-07
|
* Fix a couple of lingering references to POSTQUEL query syntax, per Simon.Tom Lane2005-12-07
|
* Spell "explicitly" correctly, per Simon.Tom Lane2005-12-07
|
* Improve lazy vacuum wording.Bruce Momjian2005-12-07
|
* Fix small memory leakTeodor Sigaev2005-12-07
|
* Improve word parser.Teodor Sigaev2005-12-07
| | | | | | - allow ~ in filenames - -8.2.1 now is '-' and '8.2.1' instead of '-8.2' '.' '3' - '.text' now is not a file
* Clarify vacuum lazy can shrink a file under certain circumstances.Bruce Momjian2005-12-07
|
* Get rid of slru.c's hardwired insistence on a fixed number of slots perTom Lane2005-12-06
| | | | | | | | | SLRU area. The number of slots is still a compile-time constant (someday we might want to change that), but at least it's a different constant for each SLRU area. Increase number of subtrans buffers to 32 based on experimentation with a heavily subtrans-bashing test case, and increase number of multixact member buffers to 16, since it's obviously silly for it not to be at least twice the number of multixact offset buffers.
* Update iconv wording, per Peter.Bruce Momjian2005-12-06
|
* Add:Bruce Momjian2005-12-06
| | | | | > * Add GUC variable to run a command on database panic or > smart/fast/immediate shutdown
* Highlight diff idea for iconv.Bruce Momjian2005-12-06
|
* iconv uses UTF-8, not UTF8.Bruce Momjian2005-12-06
|
* Document method of removing invalid UTF8 escape sequences from dumpBruce Momjian2005-12-06
| | | | | | file. Backpatch to 8.1.X. Paul Lindner
* Documentation cleanup mention:Bruce Momjian2005-12-06
| | | | non-ascii convert to & escapes
* Since my name has a non-ascii-letter in it, it's often spelled wrong. InBruce Momjian2005-12-06
| | | | | | | | | the latest release notes there is a latin1 character that shouldn't be there so I made a patch to fix that. This patch also fixes some old entries that uses o instead of &ouml; (which is also wrong but not as bad as including a latin1 character in the sgml file). Dennis Bj?rklund
* Add documentation on the use of *printf() macros and libintl.Bruce Momjian2005-12-06
| | | | Backpatch to 8.1.X.
* Fix stupid bug with sizeofTeodor Sigaev2005-12-06
|
* Arrange for read-only accesses to SLRU page buffers to take only a sharedTom Lane2005-12-06
| | | | | | | | | | lock, not exclusive, if the desired page is already in memory. This can be demonstrated to be a significant win on the pg_subtrans cache when there is a large window of open transactions. It should be useful for pg_clog as well. I didn't try to make GetMultiXactIdMembers() use the code, as that would have taken some restructuring, and what with the local cache for multixact contents it probably wouldn't really make a difference. Per my recent proposal.
* In a nestloop inner indexscan, it's OK to use pushed-down baserestrictinfoTom Lane2005-12-06
| | | | | | clauses even if it's an outer join. This is a corner case since such clauses could only arise from weird OUTER JOIN ON conditions, but worth fixing. Per example from Ron at cheapcomplexdevices.com.
* ecpg/pgtypeslib seems to need snprintf.c pulled in, too.Tom Lane2005-12-06
|
* Put undef's before extern declarations that need 'em, per Andrew Dunstan.Tom Lane2005-12-06
|
* Add comment on why pg *printf functions are used unconditionally onBruce Momjian2005-12-06
| | | | | | Win32. Backpatch to 8.1.X.
* Make Win32 build use our port/snprintf.c routines, instead of dependingTom Lane2005-12-06
| | | | | on libintl which may or may not provide what we need. Make a few marginal cleanups to ensure this works. Andrew Dunstan and Tom Lane.
* Document return-value conventions used by this implementation, perTom Lane2005-12-05
| | | | suggestion from Bruce.
* Improve word parser.Teodor Sigaev2005-12-05
| | | | | | - improve file and path recognition - fix misspeling - improve tag recognition
* Add regression test to see if the min/max values of int8 convert correctly.Tom Lane2005-12-05
|