- 31 Jul, 2006 6 commits
-
-
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 11 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
-
Tom Lane authored
server-side character set.
-
Bruce Momjian authored
< * 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
-
Michael Meskes authored
-
Michael Meskes authored
-
Michael Meskes authored
Connection identifier has to be unique
-
Michael Meskes authored
- SHOW statement puts result into a variable - COPY TO STDOUT works
-
- 27 Jul, 2006 10 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
> > A subselect can also be used as the value source.
-
Tom Lane authored
update regression expected files to what I think is correct.
-
Andrew Dunstan authored
-
Tom Lane authored
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.
-
Andrew Dunstan authored
-
Andrew Dunstan authored
-
Tom Lane authored
with restrictive permissions, which was not the behavior of the shell script and doesn't seem very desirable. Use the umask setting instead.
-
Bruce Momjian authored
Albe Laurenz
-
Peter Eisentraut authored
-
- 26 Jul, 2006 1 commit
-
-
Tom Lane authored
eliminate unnecessary code, force initdb because stored rules change (limit nodes are now supposed to be int8 not int4 expressions). Update comments and error messages, which still all said 'integer'.
-