aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Fix markup typo.Bruce Momjian2005-03-13
|
* Add missing conversion documentation for certain encodings.Bruce Momjian2005-03-13
|
* Reorder documented encodings to be alphabetical.Bruce Momjian2005-03-13
| | | | Remove warning about pre-7.2 LATIN5 usage.
* Document aliases for our supported encodings.Bruce Momjian2005-03-13
| | | | Add a few encodings that were not documented.
* When cloning template0 (or other fully-frozen databases), set the newTom Lane2005-03-12
| | | | | | | | | | | database's datallowconn and datfrozenxid to the current transaction ID instead of copying the source database's values. This is OK because we assume the source DB contains no normal transaction IDs whatsoever. This keeps VACUUM from immediately starting to complain about unvacuumed databases in the situation where we are more than 2 billion transactions out from the XID stamp of template0. Per discussion with Milen Radev (although his complaint turned out to be due to something else, but the problem is real anyway).
* Fix ALTER DATABASE RENAME to allow the operation if user is a superuserTom Lane2005-03-12
| | | | | who for some reason isn't marked usecreatedb. Per report from Alexander Pravking. Also fix sloppy coding in have_createdb_privilege().
* Adjust the API for aggregate function calls so that a C-coded functionTom Lane2005-03-12
| | | | | | | | | | | | | can tell whether it is being used as an aggregate or not. This allows such a function to avoid re-pallocing a pass-by-reference transition value; normally it would be unsafe for a function to scribble on an input, but in the aggregate case it's safe to reuse the old transition value. Make int8inc() do this. This gets a useful improvement in the speed of COUNT(*), at least on narrow tables (it seems to be swamped by I/O when the table rows are wide). Per a discussion in early December with Neil Conway. I also fixed int_aggregate.c to check this, thereby turning it into something approaching a supportable technique instead of being a crude hack.
* Add pg_buffercache contrib module, from Mark Kirkwood.Neil Conway2005-03-12
|
* Some builds (depends on crypto engine support?) of OpenSSLNeil Conway2005-03-12
| | | | | | | | | | | | 0.9.7x have EVP_DigestFinal function which which clears all of EVP_MD_CTX. This makes pgcrypto crash in functions which re-use one digest context several times: hmac() and crypt() with md5 algorithm. Following patch fixes it by carring the digest info around EVP_DigestFinal and re-initializing cipher. Marko Kreen.
* Documention all our supported encodings.Bruce Momjian2005-03-12
|
* Done:Bruce Momjian2005-03-12
| | | | | < o Allow COPY FROM ... CSV to interpret newlines and carriage > o -Allow COPY FROM ... CSV to interpret newlines and carriage
* Handle carriage returns and line feeds in COPY CSV mode.Bruce Momjian2005-03-12
| | | | Andrew Dunstan
* Done:Bruce Momjian2005-03-12
| | | | * -Add a warning when the free space map is too small
* Add warning about the need to increase "max_fsm_relations" andBruce Momjian2005-03-12
| | | | | | | "max_fsm_relations" for vacuums. Also improve VACUUM VERBOSE final message text. Ron Mayer
* Fix snprintf() to properly handle precision specification for %f.Bruce Momjian2005-03-12
|
* Fix problem with infinite recursion between write_syslogger_file andTom Lane2005-03-12
| | | | | | | | elog if the former has trouble writing its file. Code review for Magnus' patch to redirect stderr to syslog on Windows (Bruce's version seems right, but did some minor prettification). Backpatch both changes to 8.0 branch.
* Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn'tBruce Momjian2005-03-11
| | | | | | change content (at least not supposed to). Magnus Hagander
* Add fprintf() custom version to libpgport.Bruce Momjian2005-03-11
| | | | | | | Document use of macros for pg_printf functions. Bump major versions of all interfaces to handle movement of get_progname from libpq to libpgport in 8.0, and probably other libpgport changes in 8.1.
* Define snprintf() to call pg_snprintf() so our own snprintf-likeBruce Momjian2005-03-11
| | | | | implementation doesn't export out via libpq and get used by a user application.
* Add 'static' to initdb.c file-global variables.Bruce Momjian2005-03-11
|
* Mark file-global function and variables as static.Bruce Momjian2005-03-11
|
* Fix typos.Bruce Momjian2005-03-11
| | | | Hashem Masoud
* Fix typos.Bruce Momjian2005-03-11
| | | | Robert Treat
* Fix typos.Bruce Momjian2005-03-11
| | | | Robert Treat
* Fix typo.Bruce Momjian2005-03-11
|
* Slight refactoring and optimization of some code in WaitOnLock().Neil Conway2005-03-11
|
* Add:Bruce Momjian2005-03-11
| | | | > * Fix cross-compiling of time zone database via 'zic'
* Make the behavior of HAVING without GROUP BY conform to the SQL spec.Tom Lane2005-03-10
| | | | | | | | | Formerly, if such a clause contained no aggregate functions we mistakenly treated it as equivalent to WHERE. Per spec it must cause the query to be treated as a grouped query of a single group, the same as appearance of aggregate functions would do. Also, the HAVING filter must execute after aggregate function computation even if it itself contains no aggregate functions.
* Add spinlock support for Itanium processor with Intel compiler.Bruce Momjian2005-03-10
| | | | Vikram Kalsi
* Refactor fork()-related code. We need to do various housekeeping tasksNeil Conway2005-03-10
| | | | | | | | | | before we can invoke fork() -- flush stdio buffers, save and restore the profiling timer on Linux with LINUX_PROFILE, and handle BeOS stuff. This patch moves that code into a single function, fork_process(), instead of duplicating it at the various callsites of fork(). This patch doesn't address the EXEC_BACKEND case; there is room for further cleanup there.
* Add comma.Bruce Momjian2005-03-08
|
* Fix markup of URL.Bruce Momjian2005-03-08
|
* Add URL for patches queues.Bruce Momjian2005-03-08
|
* Unbreak out-of-tree builds, by fixing a typo.Neil Conway2005-03-07
|
* Replace an instance of $Id$ and an instance of $Header$ with $PostgreSQL$Neil Conway2005-03-07
|
* Properly implement "Response files" for bcc. Add URL's to describe theBruce Momjian2005-03-07
| | | | feature for Win32 and bcc.
* Adjust creation/destruction of TupleDesc data structure to reduce theTom Lane2005-03-07
| | | | | | number of palloc calls. This has a salutory impact on plpgsql operations with record variables (which create and destroy tupdescs constantly) and probably helps a bit in some other cases too.
* Rename canonical encodings, per Peter:Bruce Momjian2005-03-07
| | | | | | | | | UNICODE => UTF8 ALT => WIN866 WIN => WIN1251 TCVN => WIN1258 The old codes continue to work.
* Here's a tiny fix for a harmless typo in catalog.c:Neil Conway2005-03-07
| | | | | | | | Too much space is allocated for tablespace file path, I guess the directory name used to be "pg_tablespaces" instead of "pg_tblspc" at some point. Heikki Linnakangas
* Add a note that regression test row ordering differences can be causedTom Lane2005-03-07
| | | | by non-default planner parameter settings.
* Revise hash join code so that we can increase the number of batchesTom Lane2005-03-06
| | | | | | | on-the-fly, and thereby avoid blowing out memory when the planner has underestimated the hash table size. Hash join will now obey the work_mem limit with some faithfulness. Per my recent proposal (hash aggregate part isn't done yet though).
* Prevent rank change in case of duplicate search termsTeodor Sigaev2005-03-05
|
* Replace the BufMgrLock with separate locks on the lookup hashtable andTom Lane2005-03-04
| | | | | | | | the freelist, plus per-buffer spinlocks that protect access to individual shared buffer headers. This requires abandoning a global freelist (since the freelist is a global contention point), which shoots down ARC and 2Q as well as plain LRU management. Adopt a clock sweep algorithm instead. Preliminary results show substantial improvement in multi-backend situations.
* Move snprintf int64 compatibility letters into a NOT_USED block.Bruce Momjian2005-03-02
|
* Fix misspelling of sysctl, per Stefan Hans.Tom Lane2005-03-02
|
* Use test && test rather than test -a, per Peter.Bruce Momjian2005-03-02
|
* Fix for %I64d snprintf.Bruce Momjian2005-03-02
|
* snprintf() %I64d code fix.Bruce Momjian2005-03-02
|
* Use our own snprintf() only if NLS is enabled, and support %qd and %I64d.Bruce Momjian2005-03-02
|
* Prevent large allocation in snprintf to hold positional parameters.Bruce Momjian2005-03-02
| | | | Allocated size based on format string.