- 02 Aug, 2006 6 commits
-
-
Michael Meskes authored
-
Michael Meskes authored
Implemented EXEC SQL UNDEF. Applied first version of the regression test patch by Joachim Wieland <joe@mcknight.de>.
-
Bruce Momjian authored
< o Add COPY TO STDIN / STDOUT handling > o Add COPY TO STDIN handling
-
Bruce Momjian authored
> o In rules, allow VALUES() to contain a mixture of 'old' and 'new' > references
-
Bruce Momjian authored
o -Allow INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..)
-
Joe Conway authored
(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.
-
- 01 Aug, 2006 10 commits
-
-
Bruce Momjian authored
-
Alvaro Herrera authored
of the text where appropiate.
-
Bruce Momjian authored
lightweight locks. Marc Munro
-
Bruce Momjian authored
if table creation failed (the table already exists). Martin Pitt
-
Bruce Momjian authored
< 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
-
Bruce Momjian authored
-
Bruce Momjian authored
and -N options to exclude objects. Also support regular expressions for option object names. Greg Sabino Mullane
-
Bruce Momjian authored
-
Andrew Dunstan authored
have pg_regress fall back on testing with the canonical results file if an alternative test is specified but none succeeds.
-
Bruce Momjian authored
Joshua D. Drake Robert Treat
-
- 31 Jul, 2006 7 commits
-
-
Bruce Momjian authored
> * Consider compressed annealing to search for query plans > > This might replace GEQO, http://sixdemonbag.org/Djinni.
-
Tom Lane authored
(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.
-
Michael Meskes authored
-
Michael Meskes authored
-
Tatsuo Ishii authored
patches submitted by ITAGAKI Takahiro.
-
Tom Lane authored
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.
-
Alvaro Herrera authored
-
- 30 Jul, 2006 6 commits
-
-
Tom Lane authored
-
Michael Meskes authored
-
Michael Meskes authored
-
Alvaro Herrera authored
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.
-
Bruce Momjian authored
> * Consider detoasting keys before sorting
-
Bruce Momjian authored
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.
-
- 29 Jul, 2006 6 commits
-
-
Andrew Dunstan authored
prevent multiplexing Windows kernel event objects we listen for across various sockets - should fix the occasional stats test regression failures we see.
-
Bruce Momjian authored
> * Add column to pg_stat_activity that shows the progress of long-running > commands like CREATE INDEX and VACUUM
-
Bruce Momjian authored
Hiroshi Saito
-
Bruce Momjian authored
> * Add support for SQL-standard GENERATED/IDENTITY columns > > http://archives.postgresql.org/pgsql-hackers/2006-07/msg00543.php
-
Bruce Momjian authored
pg-specific code in those files, or might be some day.
-
Tom Lane authored
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.
-
- 28 Jul, 2006 5 commits
-
-
Tatsuo Ishii authored
discussion in hackers list. Also enhance predefined benchmark scenarios to reflect the scaling factor parameter flexibly.
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow DISTINCT to work in multiple-argument aggregate calls < o Allow UPDATE to handle complex aggregates [update]?
-
Tom Lane authored
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.
-
Tom Lane authored
-