- 31 Jan, 2007 15 commits
-
-
Bruce Momjian authored
Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately, in conversational English, their use is often mixed, as in, "You may use this variable to do X", when in fact, "can" is a better choice. Similarly, "It may crash" is better stated, "It might crash".
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately, in conversational English, their use is often mixed, as in, "You may use this variable to do X", when in fact, "can" is a better choice. Similarly, "It may crash" is better stated, "It might crash". Also update two error messages mentioned in the documenation to match.
-
Neil Conway authored
targets, and refactor the tablespace setup code into a separate Makefile target.
-
Neil Conway authored
nonportable "hh" sprintf(3) length modifier. Instead, do the parsing and output by hand. The code to do this isn't ideal, but this is an interim measure anyway: the uuid type should probably use the in-memory struct layout specified by RFC 4122. For now, this patch should hopefully rectify the buildfarm failures for the uuid test. Along the way, re-add pg_cast entries for uuid <-> varchar, which I mistakenly removed earlier, and bump the catversion.
-
Tom Lane authored
or other share-directory files are inaccessible for some reason other than not existing. Inspired by trouble report from Simon Kinsella.
-
Teodor Sigaev authored
-
Teodor Sigaev authored
-
Teodor Sigaev authored
In this case extractQuery should returns -1 as nentries. This changes prototype of extractQuery method to use int32* instead of uint32* for nentries argument. Based on that gincostestimate may see two corner cases: nothing will be found or seqscan should be used. Per proposal at http://archives.postgresql.org/pgsql-hackers/2007-01/msg01581.php PS tsearch_core patch should be sightly modified to support changes, but I'm waiting a verdict about reviewing of tsearch_core patch.
-
Bruce Momjian authored
o Fix RENAME to work on variables other than OLD/NEW > > http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php >
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> > * Add REINDEX CONCURRENTLY, like CREATE INDEX CONCURRENTLY > > This is difficult because you must upgrade to an exclusive table lock > to replace the existing index file. CREATE INDEX CONCURRENTLY does not > have this complication. This would allow index compaction without > downtime.
-
Bruce Momjian authored
< reindex rather than update the index. > reindex rather than update the index. Also, index updates can > bloat the index.
-
- 30 Jan, 2007 7 commits
-
-
Bruce Momjian authored
> o ARRAY[[1,2],[3,4]])[1] should return the same values as > ARRAY[[1,2],[3,4]])[1:1]; >
-
Bruce Momjian authored
-
Bruce Momjian authored
more, and standard_conforming_strings less, because in the future non-E strings will not treat backslashes specially. Also use E'' strings where backslashes are used in examples. (The existing examples would have drawn warnings.) Backpatch to 8.2.X.
-
Tom Lane authored
The original coding failed (tried to access deallocated memory) if there were two active call sites (fn_extra pointers) for the same function and the function definition was updated. Also, if an update of a recursive function was detected upon nested entry to the function, the existing compiled version was summarily deallocated, resulting in crash upon return to the outer instance. Problem observed while studying a bug report from Sergiy Vyshnevetskiy. Bug does not exist before 8.1 since older versions just leaked the memory of obsoleted compiled functions, rather than trying to reclaim it.
-
Tom Lane authored
by plpgsql can themselves use SPI --- possibly indirectly, as in the case of domain_in() invoking plpgsql functions in a domain check constraint. Per bug #2945 from Sergiy Vyshnevetskiy. Somewhat arbitrarily, I've chosen to back-patch this as far as 8.0. Given the lack of prior complaints, it doesn't seem critical for 7.x.
-
Bruce Momjian authored
-
Tom Lane authored
Hashing for aggregation purposes still needs work, so it's not time to mark any cross-type operators as hashable for general use, but these cases work if the operators are so marked by hand in the system catalogs.
-
- 29 Jan, 2007 6 commits
-
-
Tom Lane authored
actually used for anything.
-
Bruce Momjian authored
-
Bruce Momjian authored
< * Add Globally/Universally Unique Identifier (GUID/UUID) > * -Add Globally/Universally Unique Identifier (GUID/UUID)
-
Bruce Momjian authored
-
Bruce Momjian authored
from exec.c and postmaster.c.
-
Peter Eisentraut authored
-
- 28 Jan, 2007 12 commits
-
-
Tom Lane authored
match because they contain a null join key (and the join operator is known strict). Improves performance significantly when the inner relation contains a lot of nulls, as per bug #2930.
-
Tom Lane authored
handy to prevent core dump files from disappearing, but it's useless now because (a) we don't drop core in individual DB subdirectories anymore, and (b) CREATE DATABASE forces an internal checkpoint anyway.
-
Neil Conway authored
definitions of uuid_t that may be provided by the system headers. This should hopefully fix the Win32 build problems reported by Magnus.
-
Andrew Dunstan authored
-
Tom Lane authored
-
Tom Lane authored
rel->tuples as well as rel->rows, since some estimation functions expect both to be valid in every baserel. Per report from Dave Dutcher.
-
Tom Lane authored
reports; inspired by the misleading CONTEXT lines shown in recent bug report from Stefan Kaltenbrunner. Also, allow statement-type names shown in these messages to be translated.
-
Andrew Dunstan authored
-
Neil Conway authored
that defined in RFC 4122. This patch includes the basic implementation, plus regression tests. Documentation and perhaps some additional functionality will come later. Catversion bumped. Patch from Gevik Babakhani; review from Peter, Tom, and myself.
-
Tom Lane authored
safely in the presence of subtransactions. To ensure that any ExprContext shutdown callbacks are called at the right times, we have to have a separate EState for each level of subtransaction. Per "TupleDesc reference leak" bug report from Stefan Kaltenbrunner. Although I'm convinced the code is wrong as far back as 8.0, it doesn't seem that there are any ways for the problem to really manifest before 8.2: AFAICS, 8.0 and 8.1 only use the ExprContextCallback mechanism to handle set-returning functions, which cannot usefully be executed in a "simple expression" anyway. Hence, no backpatch before 8.2 --- the risk of unforeseen breakage seems to outweigh the chance of fixing something.
-
Tom Lane authored
sprintf pushup to be sure we can report something useful for out-of-range exitstatus?
-
Tom Lane authored
formatted error messages.
-