- 10 Nov, 2007 13 commits
-
-
Bruce Momjian authored
or will never be converted.
-
Bruce Momjian authored
start/shutdown.
-
Tom Lane authored
multiple rows. I had thought this case was covered, but there was no example in the obvious section to look in.
-
Tom Lane authored
spaces for consistency. Per bug #3734 from Ben Leslie; fix by Euler Taveira de Oliveira.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
uninitialized value, and avoid invoking the function nine separate times in the pg_xmlIsNameChar macro. Should resolve buildfarm failures. Per report from Ben Leslie.
-
Bruce Momjian authored
Throw an error for actual stop words, rather than a warning. This fixes problems with cache reloading causing warning messages. Re-enable stop words in regression tests; was disabled by Tom. Document "?" as API change.
-
Bruce Momjian authored
NOTICE.
-
Bruce Momjian authored
-
Joe Conway authored
per suggestion from Tom Lane. This fixes crash-bug reported by Stefan Schwarzer.
-
Bruce Momjian authored
-
- 09 Nov, 2007 10 commits
-
-
Tom Lane authored
a plpgsql keyword. This avoids springing a new reserved word on plpgsql programmers. For consistency, handle RETURN NEXT the same way.
-
Bruce Momjian authored
-
Tom Lane authored
locale, which sorts a bit differently. Per recent gripe from Magnus.
-
Tom Lane authored
behavior of wchar2char/char2wchar; this should resolve bug #3730. Avoid excess computations of pg_mblen in t_isalpha and friends. Const-ify APIs where possible.
-
Alvaro Herrera authored
-
Tom Lane authored
out that it's actually quite likely that a string that is an extension of the given prefix will sort as larger than the "greater" string our previous code created. To provide some defense against that, do the comparisons against a modified string instead of just the bare prefix. We tack on "Z", "z", "y", or "9", whichever is seen as largest in the current locale. Testing suggests that this is sufficient at least for cases involving ASCII data.
-
Magnus Hagander authored
to validate the realm of the connecting user. By default it's empty meaning no verification, which is the way Kerberos authentication has traditionally worked in PostgreSQL.
-
Bruce Momjian authored
section.
-
Peter Eisentraut authored
those being exactly "xml". Bug #3735 from Ben Leslie
-
Bruce Momjian authored
-
- 08 Nov, 2007 16 commits
-
-
Tom Lane authored
whole table instead, to ensure that it goes away when the table is dropped. Per bug #3723 from Sam Mason. Backpatch as far as 7.4; AFAICT 7.3 does not have the issue, because it doesn't have general-purpose expression indexes and so there must be at least one column referenced by an index.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
predictable manner; in particular that if you say ORDER BY output-column-ref, it will in fact sort by that specific column even if there are multiple syntactic matches. An example is SELECT random() AS a, random() AS b FROM ... ORDER BY b, a; While the use-case for this might be a bit debatable, it worked as expected in earlier releases, so we should preserve the behavior for 8.3. Per my recent proposal. While at it, fix convert_subquery_pathkeys() to handle RelabelType stripping in both directions; it needs this for the same reasons make_sort_from_pathkeys does.
-
Tom Lane authored
to be able to discard top-level RelabelType nodes on *both* sides of the equivalence-class-to-target-list comparison, since make_pathkey_from_sortinfo might either add or remove a RelabelType. Also fix the latter to do the removal case cleanly. Per example from Peter.
-
Bruce Momjian authored
-
Bruce Momjian authored
table to docs.
-
Bruce Momjian authored
it seems more logical there.
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
- 07 Nov, 2007 1 commit
-
-
Tom Lane authored
make_greater_string() try harder to generate a string that's actually greater than its input string. Before we just assumed that making a string that was memcmp-greater was enough, but it is easy to generate examples where this is not so when the locale is not C. Instead, loop until the relevant comparison function agrees that the generated string is greater than the input. Unfortunately this is probably not enough to guarantee that the generated string is greater than all extensions of the input, so we cannot relax the restriction to C locale for the LIKE/regex index optimization. But it should at least improve the odds of getting a useful selectivity estimate in prefix_selectivity(). Per example from Guillaume Smet. Backpatch to 8.1, mainly because that's what the complainant is using...
-