aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Fix problems with column name list of CREATE TABLE AS being applied toTom Lane2006-09-18
| | | | | the input query's target list too soon, causing it to affect processing of ORDER BY in the input query.
* Add item:Bruce Momjian2006-09-18
| | | | | | | | > > * Set client encoding based on the client operating system encoding > > Currently client_encoding is set in postgresql.conf, which > defaults to the server encoding.
* Add URL to UPDATE unique index case x=x+1:Bruce Momjian2006-09-18
| | | | | < > http://archives.postgresql.org/pgsql-hackers/2006-09/msg01458.php
* Improve wordings by David Fuhry <dfuhry@cs.kent.edu>Teodor Sigaev2006-09-18
|
* Fix CREATE TABLE ... AS VALUES ... to work rather than Assert'ing;Tom Lane2006-09-18
| | | | | | oversight in original implementation of VALUES. Also fix an oversight in recent addition of options to CREATE TABLE AS: they weren't getting propagated if the query was a set-operation such as UNION.
* Change ANALYZE to take ShareUpdateExclusiveLock not AccessShareLock onTom Lane2006-09-17
| | | | | | | | | | | | the table being analyzed. This prevents two ANALYZEs from running concurrently on the same table and possibly suffering concurrent-update failures while trying to store their results into pg_statistic. The downside is that a database-wide ANALYZE executed within a transaction block will hold ShareUpdateExclusiveLock on many tables simultaneously, which could lead to concurrency issues or even deadlock against another such ANALYZE. However, this seems a corner case of less importance than getting unexpected errors from a foreground ANALYZE when autovacuum elects to analyze the same table concurrently. Per discussion.
* Marginal cleanup in arrangements for ensuring StrategyHintVacuum is clearedTom Lane2006-09-17
| | | | | | | | | after an error during VACUUM. We have a PG_TRY block anyway around the only call sites, so just reset it in the CATCH clause instead of having AtEOXact_Buffers blindly do it during xact end. I think the old code was actively wrong for the case of a failure during ANALYZE inside a subtransaction --- the flag wouldn't get cleared until main transaction end. Probably not worth back-patching though.
* Update TODO for short header versions:Bruce Momjian2006-09-16
| | | | | | | | | | | | | | | | | | | | | | | | < o Reorder physical storage order to reduce padding? < < This involves having the user-specified order of columns < be different from the physical order. SELECT * would < need to reorder the physical values to match the < user-specified ordering. < < o Store disk pages with no alignment/padding? < < This necessitates adding CPU-required padding when moving < rows from disk to memory. < < One idea is to store the header in network byte order (high bits < first), and read the high bits to determine the header length. < http://archives.postgresql.org/pgsql-hackers/2006-09/msg00848.php > One idea is to create zero-or-one-byte-header versions > of varlena data types. In involves setting the high-bit and > 0-127 length in the single-byte header, or clear the high bit > and store the 7-bit ASCII value in the rest of the byte. > The small-header versions have no alignment requirements. > http://archives.postgresql.org/pgsql-hackers/2006-09/msg01372.php
* Rename the recently-added pg_timezonenames view to pg_timezone_abbrevs,Tom Lane2006-09-16
| | | | | | and create a new view pg_timezone_names that provides information about the zones known in the 'zic' database. Magnus Hagander, with some additional work by Tom Lane.
* Update timezone data files to release 2006k of the zic database.Tom Lane2006-09-16
|
* Rename xml_valid() to xml_is_well_formed(), but provide a temporaryTom Lane2006-09-16
| | | | | | alias with the old name for backwards compatibility. Per discussion, the old name is actively wrong because validity and well-formedness have different meanings in XML.
* Define errcode as __msvc_errcode not __vc_errcode for MSVC builds,Tom Lane2006-09-16
| | | | per Magnus.
* Fix some more uses of str[n]casecmp that should be pg_str[n]casecmp.Tom Lane2006-09-16
|
* Remove emacs info from footer of SGML files.Bruce Momjian2006-09-16
|
* Document Warm Standby for High AvailabilityBruce Momjian2006-09-15
| | | | | | Includes sample standby script. Simon Riggs
* Document WAL recovery now uses checkpoints.Bruce Momjian2006-09-15
| | | | Simon Riggs
* Several fixes for MSVC build scripts, from Magnus.Tom Lane2006-09-15
|
* Fix some uses of str[n]casecmp that should be pg_str[n]casecmp.Tom Lane2006-09-15
|
* Fix some uses of str[n]casecmp that should be pg_str[n]casecmp,Tom Lane2006-09-15
| | | | per Magnus.
* Remove WINLDAPAPI decoration from ldap_start_tls_sA typedef, per Magnus.Tom Lane2006-09-15
|
* Improve confusing comment for HeapTupleSatisfiesNow, per gripe from Greg Stark.Tom Lane2006-09-15
|
* Make postgresql.conf.sample match the initdb defaults. This fixesBruce Momjian2006-09-14
| | | | comment alignment on most systems.
* Add a couple of information functions to support direct checks on whetherTom Lane2006-09-14
| | | | | | a schema is our own temp schema or another backend's temp schema, and use these in place of some former kluges in information_schema. Per my proposal of yesterday.
* Seems no one wants this:Bruce Momjian2006-09-14
| | | | | < * -Allow PREPARE to automatically determine parameter types based on the SQL < statement (Neil)
* Done:Bruce Momjian2006-09-14
| | | | | < * -Allow protocol-level BIND parameter values to be logged, if text mode > * -Allow protocol-level BIND parameter values to be logged
* Not done yet:Bruce Momjian2006-09-14
| | | | | < o -Allow commenting of variables in postgresql.conf to restore them > o Allow commenting of variables in postgresql.conf to restore them
* Fix missing markup.Tom Lane2006-09-14
|
* Remove sslinfo copyright with author permission, keep author attribution.Bruce Momjian2006-09-14
| | | | Victor Wagner
* Remove:Bruce Momjian2006-09-14
| | | | < * Research storing only active XIDs in subtransaction cache
* Add:Bruce Momjian2006-09-14
| | | | > * Research storing only active XIDs in subtransaction cache
* Add XML item.Bruce Momjian2006-09-14
| | | | | | | > > * Improve XML support > > http://developer.postgresql.org/index.php/XML_Support
* Add description for variable-length header:Bruce Momjian2006-09-14
| | | | | > One idea is to store the header in network byte order (high bits > first), and read the high bits to determine the header length.
* Add recent ICU URL:Bruce Momjian2006-09-14
| | | | > http://archives.postgresql.org/pgsql-hackers/2006-09/msg00662.php
* Update TODO items:Bruce Momjian2006-09-14
| | | | | | | | | | | | | | | | | | < o Store disk pages with no alignment/padding? > > This involves having the user-specified order of columns > be different from the physical order. SELECT * would > need to reorder the physical values to match the > user-specified ordering. > > o Store disk pages with no alignment/padding? > > This necessitates adding CPU-required padding when moving > rows from disk to memory. > > > http://archives.postgresql.org/pgsql-hackers/2006-09/msg00848.php >
* For release notes checklist, add UTF8 URL.Bruce Momjian2006-09-14
|
* In release notes checklist, add URL for HTML non-ASCII escapes, mentionBruce Momjian2006-09-14
| | | | UTF8 escapes.
* Fix SGML markupTeodor Sigaev2006-09-14
|
* Improve error message. Per discussionTeodor Sigaev2006-09-14
| | | | http://archives.postgresql.org/pgsql-general/2006-09/msg00186.php
* GIN documentation and slightly improving GiST docs.Teodor Sigaev2006-09-14
| | | | | Thanks to Christopher Kings-Lynne <chris.kingslynne@gmail.com> for initial version and Jeff Davis <pgsql@j-davis.com> for inspection
* Cygwin systems seem to have a different error message when trying to connect ↵Michael Meskes2006-09-14
| | | | to port 0. Let's try port 20 instead.
* Added missing constuctor/destructor for interval and date.Michael Meskes2006-09-14
|
* Some small editorialization on the description of CREATE INDEXTom Lane2006-09-13
| | | | CONCURRENTLY. Greg Stark, some further tweaks by me.
* Make logging of extended-protocol commands a bit more consistent, perTom Lane2006-09-13
| | | | discussion with Guillaume Smet.
* Code review for patch to avoid second scan when vacuuming index-lessTom Lane2006-09-13
| | | | | table: avoid invoking LockBufferForCleanup without need, put out the same log message we would have before, minor code beautification.
* Change "tps" to "scale" to avoid confusionTatsuo Ishii2006-09-13
| | | | | Fix bug with handling default scaling factor in the default scenarios
* Add David Fetter:Bruce Momjian2006-09-12
| | | | > * David is David Fetter <david@fetter.org>
* Add uninstall scriptTeodor Sigaev2006-09-12
|
* Spell readme file's name correctly, per buildfarm reports.Tom Lane2006-09-12
|
* Small fix for the README install for contrib/sslinfo.Peter Eisentraut2006-09-12
| | | | Dave Page
* Seems this wasn't committed originallyMichael Meskes2006-09-12
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 01:59:42 +0000