aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add support for multi-row VALUES clauses as part of INSERT statementsJoe Conway2006-08-02
| | | | | | (e.g. "INSERT ... VALUES (...), (...), ...") and elsewhere as allowed by the spec. (e.g. similar to a FROM clause subselect). initdb required. Joe Conway and Tom Lane.
* Fix bug I introduced while cleaning up pg_dump -t/-n patch.Bruce Momjian2006-08-01
|
* Editorialize a bit on the recent patch, reverting to the original versionsAlvaro Herrera2006-08-01
| | | | of the text where appropiate.
* Add support for loadable modules to allocated shared memory andBruce Momjian2006-08-01
| | | | | | lightweight locks. Marc Munro
* Add pg_dump -X no-data-for-failed-tables option to suppress loading dataBruce Momjian2006-08-01
| | | | | | if table creation failed (the table already exists). Martin Pitt
* Done:Bruce Momjian2006-08-01
| | | | | | | | | < o %Allow pg_dump to use multiple -t and -n switches [pg_dump] < < http://archives.postgresql.org/pgsql-patches/2006-01/msg00190.php < > o -Allow pg_dump to use multiple -t and -n switches, exclusion > ability, and regular expression object matching
* Remove TODO.detail/pg_dump.Bruce Momjian2006-08-01
|
* Allow multiple -n (schema) and -t (table) pg_dump options, and add -TBruce Momjian2006-08-01
| | | | | | | and -N options to exclude objects. Also support regular expressions for option object names. Greg Sabino Mullane
* Remove extra argument to printf().Bruce Momjian2006-08-01
|
* have pg_regress fall back on testing with the canonical results file if anAndrew Dunstan2006-08-01
| | | | alternative test is specified but none succeeds.
* Improvements to Maintenance and External Projects documentation.Bruce Momjian2006-08-01
| | | | | Joshua D. Drake Robert Treat
* Add:Bruce Momjian2006-07-31
| | | | | | > * Consider compressed annealing to search for query plans > > This might replace GEQO, http://sixdemonbag.org/Djinni.
* Change the relation_open protocol so that we obtain lock on a relationTom Lane2006-07-31
| | | | | | | | | | | | (table or index) before trying to open its relcache entry. This fixes race conditions in which someone else commits a change to the relation's catalog entries while we are in process of doing relcache load. Problems of that ilk have been reported sporadically for years, but it was not really practical to fix until recently --- for instance, the recent addition of WAL-log support for in-place updates helped. Along the way, remove pg_am.amconcurrent: all AMs are now expected to support concurrent update.
* Added missing ECPGget_sqlca() callMichael Meskes2006-07-31
|
* First small patches needed for regression testsMichael Meskes2006-07-31
|
* Fix memory allocation bug in pgbench.Tatsuo Ishii2006-07-31
| | | | patches submitted by ITAGAKI Takahiro.
* Change the bootstrap sequence so that toast tables for system catalogs areTom Lane2006-07-31
| | | | | | | | | | created in the bootstrap phase proper, rather than added after-the-fact by initdb. This is cleaner than before because it allows us to retire the undocumented ALTER TABLE ... CREATE TOAST TABLE command, but the real reason I'm doing it is so that toast tables of shared catalogs will now have predetermined OIDs. This will allow a reasonably clean solution to the problem of locking tables before we load their relcache entries, to appear in a forthcoming patch.
* Fix confusion between COPY FROM and COPY TO, per Gavin Sharry and Arul Shaji.Alvaro Herrera2006-07-31
|
* Fix a couple of comments.Tom Lane2006-07-30
|
* Replaced $Header$ by $§PosgreSQL$Michael Meskes2006-07-30
|
* Added missing $Header$ entries.Michael Meskes2006-07-30
|
* Modify snapshot definition so that lazy vacuums are ignored by otherAlvaro Herrera2006-07-30
| | | | | | | | | vacuums. This allows a OLTP-like system with big tables to continue regular vacuuming on small-but-frequently-updated tables while the big tables are being vacuumed. Original patch from Hannu Krossing, rewritten by Tom Lane and updated by me.
* Add:Bruce Momjian2006-07-30
| | | | > * Consider detoasting keys before sorting
* Fix WIN32 wait() return value macros to be accurate, particularlyBruce Momjian2006-07-30
| | | | | | | | | because they are used for testing the return value from system(). (WIN32 doesn't overlay the return code with other failure conditions like Unix does, so they are just simple macros.) Fix regression checks to properly handle diff failures on Win32 using the new macros.
* prevent multiplexing Windows kernel event objects we listen for across ↵Andrew Dunstan2006-07-29
| | | | various sockets - should fix the occasional stats test regression failures we see.
* Add entry:Bruce Momjian2006-07-29
| | | | | > * Add column to pg_stat_activity that shows the progress of long-running > commands like CREATE INDEX and VACUUM
* Don't use #include <crtdefs.h> for MSVC <= 1400.Bruce Momjian2006-07-29
| | | | Hiroshi Saito
* Add:Bruce Momjian2006-07-29
| | | | | | > * Add support for SQL-standard GENERATED/IDENTITY columns > > http://archives.postgresql.org/pgsql-hackers/2006-07/msg00543.php
* Add #include postgres_fe.h in two win32-specific files, because there isBruce Momjian2006-07-29
| | | | pg-specific code in those files, or might be some day.
* Adjust initialization sequence for timezone_abbreviations so thatTom Lane2006-07-29
| | | | | | | | | it's handled just about like timezone; in particular, don't try to read anything during InitializeGUCOptions. Should solve current startup failure on Windows, and avoid wasted cycles if a nondefault setting is specified in postgresql.conf too. Possibly we need to think about a more general solution for handling 'expensive to set' GUC options.
* Change the delta val from 0 and 10000 to -5000 and 5000 per recentTatsuo Ishii2006-07-28
| | | | | discussion in hackers list. Also enhance predefined benchmark scenarios to reflect the scaling factor parameter flexibly.
* Remove update TODO.detail item.Bruce Momjian2006-07-28
|
* Updates per Tom:Bruce Momjian2006-07-28
| | | | | > * Allow DISTINCT to work in multiple-argument aggregate calls < o Allow UPDATE to handle complex aggregates [update]?
* SQL2003-standard statistical aggregates, by Sergey Koposov. I've added onlyTom Lane2006-07-28
| | | | | | | the float8 versions of the aggregates, which is all that the standard requires. Sergey's original patch also provided versions using numeric arithmetic, but given the size and slowness of the code, I doubt we ought to include those in core.
* Fix table title.Tom Lane2006-07-28
|
* Make it clearer that not every Postgres character set can be used as aTom Lane2006-07-28
| | | | server-side character set.
* Update Tatsuo:Bruce Momjian2006-07-28
| | | | | < * Tatsuo is Tatsuo Ishii <t-ishii@sra.co.jp> of Software Research Assoc. > * Tatsuo is Tatsuo Ishii <ishii@sraoss.co.jp> of SRA OSS, Inc. Japan
* Variables should be free'ed only once.Michael Meskes2006-07-28
|
* Removed superfluous commentMichael Meskes2006-07-28
|
* And one more:Michael Meskes2006-07-28
| | | | Connection identifier has to be unique
* Added more SoC changes by Joachim Wieland <joe@mcknight.de>:Michael Meskes2006-07-28
| | | | | - SHOW statement puts result into a variable - COPY TO STDOUT works
* Add URL for UPDATE/SET for multiple values.Bruce Momjian2006-07-27
|
* Add for UPDATE SET for multiple values:Bruce Momjian2006-07-27
| | | | | > > A subselect can also be used as the value source.
* Fix incorrect function return code in cube_cmp and cube_dim;Tom Lane2006-07-27
| | | | update regression expected files to what I think is correct.
* revert last change - broke non-AIX platforms.Andrew Dunstan2006-07-27
|
* Aggregate functions now support multiple input arguments. I also tookTom Lane2006-07-27
| | | | | | | | the opportunity to treat COUNT(*) as a zero-argument aggregate instead of the old hack that equated it to COUNT(1); this is materially cleaner (no more weird ANYOID cases) and ought to be at least a tiny bit faster. Original patch by Sergey Koposov; review, documentation, simple regression tests, pg_dump and psql support by moi.
* another try at keeping AIX/ppc happy on cube test.Andrew Dunstan2006-07-27
|
* fix most regression tests for new cube code.Andrew Dunstan2006-07-27
|
* Original coding of pg_regress.c made the results and log directoriesTom Lane2006-07-27
| | | | | with restrictive permissions, which was not the behavior of the shell script and doesn't seem very desirable. Use the umask setting instead.
* Allow LDAP lookups from pg_service.conf.Bruce Momjian2006-07-27
| | | | Albe Laurenz