aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add some instrumentation to the bgwriter, through the stats collector.Magnus Hagander2007-03-30
| | | | New view pg_stat_bgwriter, and the functions required to build it.
* Update Japanese FAQ.Bruce Momjian2007-03-30
| | | | Jun Kuwamura
* Update SSL description for when SSL root.crt/server.crt is required;Bruce Momjian2007-03-30
| | | | | | add link to libpq SSL does from server docs. Backpatch to 8.2.X.
* Fix oversight in coding of _bt_start_vacuum: we can't assume that the LWLockTom Lane2007-03-30
| | | | | | | will be released by transaction abort before _bt_end_vacuum gets called. If either of these "can't happen" errors actually happened, we'd freeze up trying to acquire an already-held lock. Latest word is that this does not explain Martin Pitt's trouble report, but it still looks like a bug.
* pg_char_to_encoding() was redundant in initdb becauseBruce Momjian2007-03-29
| | | | | | | pg_valid_server_encoding() returns the same result if the encoding is valid. ITAGAKI Takahiro
* Add to:Bruce Momjian2007-03-29
| | | | | * Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-patches/2007-02/msg00505.php
* Add:Bruce Momjian2007-03-29
| | | | | | | > * Reduce storage space for small NUMERICs > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01331.php >
* Install include filesMagnus Hagander2007-03-29
|
* Update:Bruce Momjian2007-03-29
| | | | | < o Add more logical syntax CLUSTER table USING index; > o Add more logical syntax CLUSTER table USING index;
* Update item:Bruce Momjian2007-03-29
| | | | | | o Add more logical syntax CLUSTER table USING index; < o Add more logical syntax CLUSTER table ORDER BY index; > o Add more logical syntax CLUSTER table USING index;
* exec_parse_message neglected to copy parameter type array into theTom Lane2007-03-29
| | | | | required memory context when handling client-specified parameter types for an unnamed statement. Per report from Kris Jurka.
* Make ECPG regression tests use native threading instead of pthreads, now thatMagnus Hagander2007-03-29
| | | | | | | ecpglib supports it. Change configure (patch from Bruce) and msvc build system to no longer require pthreads on win32, since all parts of postgresql can be thread-safe using the native platform functions.
* - Added patch by Magnus Hagander <magnus@hagander.net> to use nativeMichael Meskes2007-03-29
| | | | | win32 threads. - Fixed regression tests to run threading tests.
* Teach CLUSTER to skip writing WAL if not needed (ie, not using archiving)Tom Lane2007-03-29
| | | | | --- Simon. Also, code review and cleanup for the previous COPY-no-WAL patches --- Tom.
* Code cleanup for the new regexp UDFs: we can hardcode the OID and someNeil Conway2007-03-28
| | | | | properties of the "text" type, and then simplify the code accordingly. Patch from Jeremy Drake.
* Replace 4-clause licensed blf.[ch] with blowfish implementationNeil Conway2007-03-28
| | | | from PuTTY with is under minimal BSD/MIT license. Marko Kreen.
* Add the "recheck" logic to autovacuum worker code. The worker first buildsAlvaro Herrera2007-03-28
| | | | | | | | | | | its table list and then rechecks pgstat before vacuuming each table to verify that no one has vacuumed the table in the meantime. In the current autovacuum world this only means that a worker will not vacuum a table that a user has vacuumed manually after the worker started. When support for multiple autovacuum workers is introduced, this will reduce the probability of simultaneous workers on the same database doing redundant work.
* Fix compiler warnings in ereport messages on mingw.Magnus Hagander2007-03-28
| | | | ITAGAKI Takahiro
* Add URL for:Bruce Momjian2007-03-28
| | | | | * Automatically create rules on views so they are updateable, per SQL99 > http://archives.postgresql.org/pgsql-patches/2006-08/msg00255.php
* Fix uninitialized-variable bug.Tom Lane2007-03-28
|
* Fix array coercion expressions to ensure that the correct volatility isTom Lane2007-03-27
| | | | | | | | | seen by code inspecting the expression. The best way to do this seems to be to drop the original representation as a function invocation, and instead make a special expression node type that represents applying the element-type coercion function to each array element. In this way the element function is exposed and will be checked for volatility. Per report from Guillaume Smet.
* Install import libraries used to link to libpq, ecpg and the backend.Magnus Hagander2007-03-27
|
* Cosmetic changes: rename some struct fields, and move the fetching of pgstatAlvaro Herrera2007-03-27
| | | | | table entries to a separate routine. Don't pass the pgstat database entry to do_autovacuum; rather, have it fetch it by itself.
* Remove item due to lack of interest:Bruce Momjian2007-03-27
| | | | | | | | < * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), < pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef() < < These would be for application use, not for use by pg_dump. <
* Add:Bruce Momjian2007-03-27
| | | | | | | | | > > * Allow configuration of backend priorities via the operating system > > Though backend priorities make priority inversion during lock > waits possible, research shows that this is not a huge problem. > http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
* Fix typo in Makefile.Bruce Momjian2007-03-27
| | | | Marko Kreen
* Fix typo, ensable -> enable, per Steve Gieseking.Tom Lane2007-03-27
|
* Add documentation for pulling the CVS repository using rsync, andBruce Momjian2007-03-27
| | | | mention cvsup last.
* Update:Bruce Momjian2007-03-26
| | | | * Improve dead row detection during multi-statement transactions usage
* Add:Bruce Momjian2007-03-26
| | | | | | | | > * Increase the number of rows recognized as dead during multi-statement > transactions > > http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php >
* Remove Andrew Yu copyright, with permission from author.Bruce Momjian2007-03-26
|
* Remove advertising clause from Berkeley BSD-licensed files, perBruce Momjian2007-03-26
| | | | instructions from Berkeley.
* Properly fix PORTNAME in configure.Bruce Momjian2007-03-26
|
* User PORTNAME for win32 tests, rather than $template, for consistency.Bruce Momjian2007-03-26
|
* Fix seriously broken markup for libpq-envars cross-references.Tom Lane2007-03-26
|
* Allow non-superuser database owners to create procedural languages.Tom Lane2007-03-26
| | | | | | | | | | A DBA is allowed to create a language in his database if it's marked "tmpldbacreate" in pg_pltemplate. The factory default is that this is set for all standard trusted languages, but of course a superuser may adjust the settings. In service of this, add the long-foreseen owner column to pg_language; renaming, dropping, and altering owner of a PL now follow normal ownership rules instead of being superuser-only. Jeremy Drake, with some editorialization by Tom Lane.
* Add checking of end of line in parsing stopword list. Thanks to sharp eyes ↵Teodor Sigaev2007-03-26
| | | | of Tom lane
* Fix stopword and synonym files parsing bug in MSVC build, per report fromTeodor Sigaev2007-03-26
| | | | Magnus Hagander. Also, now it ignores space symbol after stopwords.
* Fix pg_wchar_table's maxmblen field of EUC_CN, EUC_TW, MULE_INTERNALTatsuo Ishii2007-03-26
| | | | and GB18030. patches from ITAGAKI Takahiro.
* Seems some people have been forgetting to run autoheader.Tom Lane2007-03-26
|
* Add -lcrypto as one of the possible link dependencies of libkrb5.Tom Lane2007-03-26
| | | | | Per report from Jim Rosenberg. This possibly should get back-patched, but I'm a bit suspicious of it still because of the lack of prior reports.
* Remove assertion that constraint_exclusion risks wrong answers ifTom Lane2007-03-26
| | | | | table constraints are changed; this is no longer true now that we have a plan invalidation mechanism.
* Fix plancache's invalidation callback to do the right thing for a SITom Lane2007-03-26
| | | | | | reset event, namely invalidate everything. This oversight probably explains the rare failures that some buildfarm machines have been showing for the plancache regression test.
* Make _SPI_execute_plan pass the query source string down to ProcessUtilityTom Lane2007-03-25
| | | | | | if possible. I had left this undone in the first pass at the API change for ProcessUtility, but forgot to revisit it after the plancache changes made it possible to do it.
* Remove the prohibition on executing cursor commands through SPI_execute.Tom Lane2007-03-25
| | | | | | | | | Vadim had included this restriction in the original design of the SPI code, but I'm darned if I can see a reason for it. I left the macro definition of SPI_ERROR_CURSOR in place, so as not to needlessly break any SPI callers that are checking for it, but that code will never actually be returned anymore.
* Clean up the representation of special snapshots by including a "methodTom Lane2007-03-25
| | | | | | | | | | | | | | | | | | | | | pointer" in every Snapshot struct. This allows removal of the case-by-case tests in HeapTupleSatisfiesVisibility, which should make it a bit faster (I didn't try any performance tests though). More importantly, we are no longer violating portable C practices by assuming that small integers are distinct from all pointer values, and HeapTupleSatisfiesDirty no longer has a non-reentrant API involving side-effects on a global variable. There were a couple of places calling HeapTupleSatisfiesXXX routines directly rather than through the HeapTupleSatisfiesVisibility macro. Since these places had to be changed anyway, I chose to make them go through the macro for uniformity. Along the way I renamed HeapTupleSatisfiesSnapshot to HeapTupleSatisfiesMVCC to emphasize that it's only used with MVCC-type snapshots. I was sorely tempted to rename HeapTupleSatisfiesVisibility to HeapTupleSatisfiesSnapshot, but forebore for the moment to avoid confusion and reduce the likelihood that this patch breaks some of the pending patches. Might want to reconsider doing that later.
* Add new encoding EUC_JIS_2004 and SHIFT_JIS_2004,Tatsuo Ishii2007-03-25
| | | | | along with new conversions among EUC_JIS_2004, SHIFT_JIS_2004 and UTF-8. catalog version has been bump up.
* Add:Bruce Momjian2007-03-25
| | | | | | | > > * Allow BEFORE INSERT triggers on views > > http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php
* Add:Bruce Momjian2007-03-24
| | | | | > o Add more logical syntax CLUSTER table ORDER BY index; > support current syntax for backward compatibility
* Support for installing NLS files, and update support to use gettextMagnus Hagander2007-03-24
| | | | from gnuwin32.