- 11 Nov, 2007 5 commits
-
-
Tom Lane authored
even in code paths where we don't pay any subsequent attention to the typmod value. This seems needed in view of the fact that 8.3's generalized typmod support will accept a lot of bogus syntax, such as "timestamp(foo)" or "record(int, 42)" --- if we allow such things to pass without comment, users will get confused. Per a recent example from Greg Stark. To implement this in a way that's not very vulnerable to future bugs-of-omission, refactor the API of parse_type.c's TypeName lookup routines so that typmod validation is folded into the base lookup operation. Callers can still choose not to receive the encoded typmod, but we'll check the decoration anyway if it's present.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
remove transactions use create or replace function make formatting consistent set search patch on first line Add documentation on modifying *.sql to set the search patch, and mention that major upgrades should still run the installation scripts. Some of these issues were spotted by Tom today.
-
- 10 Nov, 2007 14 commits
-
-
Bruce Momjian authored
-
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 11 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
-