| Commit message (Collapse) | Author | Age |
... | |
| |
|
|
|
|
| |
other old code.
|
|
|
|
|
| |
classified the conditions under which this is safe to do (see source
code comment).
|
| |
|
|
|
|
| |
in pg_type. Fixes bug #2917. Add some regression tests for these cases.
|
|
|
|
|
|
|
|
|
|
| |
input in the stats collector. Our select() emulation is apparently buggy
for UDP sockets :-(. This should resolve problems with stats collection
(and hence autovacuum) failing under more than minimal load. Diagnosis
and patch by Magnus Hagander.
Patch probably needs to be back-ported to 8.1 and 8.0, but first let's
see if it makes the buildfarm happy...
|
|
|
|
|
|
|
| |
suffix, to distinguish them from doubles. Make some function declarations
and definitions use the "const" qualifier for arguments consistently.
Ignore warning 4102 ("unreferenced label"), because such warnings
are always emitted by bison-generated code. Patch from Magnus Hagander.
|
| |
|
|
|
|
|
| |
to deal with buildenv.bat properly, so that PATH (for example) doesn't
expand infintly. Per report from Joachim Wieland, patch from Magnus.
|
|
|
|
| |
Removed regression test that triggers those libc precision bugs on some archs.
|
|
|
|
| |
with cleanup by Jaime Casanova.
|
|
|
|
| |
2.3.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
- Add new SQL command SET XML OPTION (also available via regular GUC) to
control the DOCUMENT vs. CONTENT option in implicit parsing and
serialization operations.
- Subtle corrections in the handling of the standalone property in
xmlroot().
- Allow xmlroot() to work on content fragments.
- Subtle corrections in the handling of the version property in
xmlconcat().
- Code refactoring for producing XML declarations.
|
|
|
|
|
|
| |
objects.
Jaime Casanova
|
|
|
|
|
|
| |
might cause server crash.
Backpatch to 8.2.X.
|
|
|
|
|
|
|
| |
rather than 1/0. This helps when creating trigger functions that output
SQL.
Guido Goldstein
|
|
|
|
|
|
| |
where output redirection of child processes (pg_dump) doesn't work.
Dave Page
|
|
|
|
|
|
| |
'template1'.
Dave Page
|
|
|
|
| |
Dave Page
|
|
|
|
|
|
| |
created it.
Simon Riggs
|
|
|
|
|
|
| |
specified.
Magnus Hagander
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
page about the maximum UTF8 sequence length we support (4 bytes since 8.1,
3 before that). pg_utf2wchar_with_len never got updated to support 4-byte
characters at all, and in any case had a buffer-overrun risk in that it
could produce multiple pg_wchars from what mblen claims to be just one UTF8
character. The only reason we don't have a major security hole is that most
callers allocate worst-case output buffers; the sole exception in released
versions appears to be pre-8.2 iwchareq() (ie, ILIKE), which can be crashed
due to zeroing out its return address --- but AFAICS that can't be exploited
for anything more than a crash, due to inability to control what gets written
there. Per report from James Russell and Michael Fuhr.
Pre-8.1 the risk is much less, but I still think pg_utf2wchar_with_len's
behavior given an incomplete final character risks buffer overrun, so
back-patch that logic change anyway.
This patch also makes sure that UTF8 sequences exceeding the supported
length (whichever it is) are consistently treated as error cases, rather
than being treated like a valid shorter sequence in some places.
|
|
|
|
|
|
|
| |
involving unions of types having typmods. Variants of the failure are known
to occur in 8.1 and up; not sure if it's possible in 8.0 and 7.4, but since
the code exists that far back, I'll just patch 'em all. Per report from
Brian Hurt.
|
|
|
|
|
|
|
|
|
| |
libxml as the detail message.
As per <http://archives.postgresql.org/pgsql-hackers/2006-12/msg01087.php>.
For converting error codes to messages, we only need to cover those codes
that we raise ourselves now.
|
| |
|
| |
|
|
|
|
|
|
|
| |
pg_proc.h (it's the same changes that's in gen_fmgrtab.sh in the unix
build).
Patch from Magnus Hagander.
|
|
|
|
|
|
| |
FAMILY; and add FAMILY option to CREATE OPERATOR CLASS to allow adding a
class to a pre-existing family. Per previous discussion. Man, what a
tedious lot of cutting and pasting ...
|
| |
|
|
|
|
|
| |
values. Point to /include/ntstatus.h for an exception list, rather than
a URL.
|
|
|
|
| |
than hex codes, using FormatMessage().
|
|
|
|
|
|
|
|
|
|
| |
which I had removed in the first cut of the EquivalenceClass rewrite to
simplify that patch a little. But it's still important --- in a four-way
join problem mergejoinscansel() was eating about 40% of the planning time
according to gprof. Also, improve the EquivalenceClass code to re-use
join RestrictInfos rather than generating fresh ones for each join
considered. This saves some memory space but more importantly improves
the effectiveness of caching planning info in RestrictInfos.
|
| |
|
| |
|
|
|
|
| |
exception value in hex, and give a URL where the value can be looked-up.
|
|
|
|
|
|
|
|
|
|
|
|
| |
columns procost and prorows, to allow simple user adjustment of the estimated
cost of a function call, as well as control of the estimated number of rows
returned by a set-returning function. We might eventually wish to extend this
to allow function-specific estimation routines, but there seems to be
consensus that we should try a simple constant estimate first. In particular
this provides a relatively simple way to control the order in which different
WHERE clauses are applied in a plan node, which is a Good Thing in view of the
fact that the recent EquivalenceClass planner rewrite made that much less
predictable than before.
|
| |
|
|
|
|
| |
mentioned before the system directories.
|
|
|
|
| |
a couple of syscache lookups in make_pathkey_from_sortinfo().
|
|
|
|
|
|
|
| |
provide just a boolean 'amcanorder', instead of fields that specify the
sort operator strategy numbers. We have decided to require ordering-capable
AMs to use btree-compatible strategy numbers, so the old fields are
overkill (and indeed misleading about what's allowed).
|
|
|
|
| |
pgsql-patches discussion of September 20, 2006. Bump the catversion.
|
|
|
|
| |
Backpatch to 8.2.X for new initdbs.
|
| |
|
|
|
|
|
| |
Previously, disabled triggers were not displayed any differently than
enabled ones, which was quite misleading. Patch from Brendan Jurd.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
representation of equivalence classes of variables. This is an extensive
rewrite, but it brings a number of benefits:
* planner no longer fails in the presence of "incomplete" operator families
that don't offer operators for every possible combination of datatypes.
* avoid generating and then discarding redundant equality clauses.
* remove bogus assumption that derived equalities always use operators
named "=".
* mergejoins can work with a variety of sort orders (e.g., descending) now,
instead of tying each mergejoinable operator to exactly one sort order.
* better recognition of redundant sort columns.
* can make use of equalities appearing underneath an outer join.
|
|
|
|
|
|
|
| |
currentMarkData from IndexScanDesc to the opaque structs for the
AMs that need this information (currently gist and hash).
Patch from Heikki Linnakangas, fixes by Neil Conway.
|
| |
|
| |
|
|
|
|
| |
rather than a value too high.
|
|
|
|
| |
HTML in HTML mode. Patch from Jeremy Drake.
|