| Age | Commit message (Collapse) | Author |
|---|
|
|
|
on views.
|
|
has a DISTINCT ON clause, per bug report from Anthony Wood. While at it,
improve the DISTINCT-ON-clause recognizer routine to not be fooled by out-
of-order DISTINCT lists.
Also, back-patch earlier fix to not push down into sub-SELECT with LIMIT.
|
|
namely after the view definition rather than before it. Bug introduced
in 7.1 by changes to dump stuff in OID ordering.
|
|
|
|
after writing/unpinning it. An actual failure is unlikely, unless the
system is tremendously short of buffers ... but a bug is a bug.
|
|
(it's a field of a tuple). I see Jan has already fixed this in
current sources, but 7.1.* is pretty badly broken here.
|
|
manipulation of rtable/jointree by planner. Rewriter was generating
actions that shared rtable/jointree substructure, which caused havoc
when planner got to the later actions that it'd already mucked up.
|
|
|
|
because cached fmgr info contained reference to a shorter-lived data
structure. Also guard against possibility that fmgr_info could fail,
leaving an incomplete entry present in the hash table.
|
|
|
|
Without patch, the time zone field is ignored and the returned time is
not correct.
Already applied to the development tree...
|
|
initdb to fix this in 7.1 installations, but it seems better to be
shipping a correct entry than a wrong one.
|
|
the buffer lock while checking page free space).
|
|
|
|
trees (mostly my fault). Repair. Also fix long-standing bug in ExecReplace:
after recomputing a concurrently updated tuple, we must recheck constraints.
Make EvalPlanQual leak memory with somewhat less enthusiasm than before,
although plugging leaks fully will require more changes than I care to risk
in a dot-release.
|
|
for relations on the nullable side of an OUTER JOIN. For now I think
we'd better refuse such queries.
|
|
|
|
not TRUE. Otherwise we break pl call handler functions. fmgr_oldstyle
will take care of making sure the semantics are the same for C functions.
Clean up some slightly grotty coding in 7.0 pg_class reading, also.
|
|
|
|
- Fix view dumping SQL for V7.0
- Fix bug when getting view oid with long view names
- Treat SEQUENCE SET TOC entries as data entries rather than schema
entries.
- Make allowance for data entries that did not have a data dumper
routine (eg. SEQUENCE SET)
|
|
|
|
set null/default).
|
|
to their children, leading to misbehavior if they had any children that paid
attention to chgParam (most plan node types don't). Append's bug has been
there a long time, but nobody had noticed because it used to be difficult
to create a query where an Append would be used below the top level of a
plan; so there were never any parameters getting passed down. SubqueryScan
is new in 7.1 ... and I'd modeled its behavior on Append :-(
|
|
passed, which occurs when no rows are retrieved by a SELECT.
Mea maxima culpa ... I should have caught this.
|
|
|
|
going to have any at all.
|
|
running deferred triggers. They are really part of the regular
transaction, and they could take awhile.
|
|
routine DetermineLocalTimeZone(). In that routine, be more wary of
broken mktime() implementations than the original code was: don't allow
mktime to change the already-set y/m/d/h/m/s information, and don't
use tm_gmtoff if mktime failed. Possibly this will resolve some of
the complaints we've been hearing from users of Middle Eastern timezones
on RedHat.
|
|
support two - KOI8-R and KOI8-U (latter is superset of the former if
not to take to the account pseudographics)
Andy Rysin
|
|
either :-(.
|
|
Oleg Bartunov
|
|
give consistent results for all datatypes. Types float4, float8, and
numeric were broken for NaN values; abstime, timestamp, and interval
were broken for INVALID values; timetz was just plain broken (some
possible pairs of values were neither < nor = nor >). Also clean up
text, bpchar, varchar, and bit/varbit to eliminate duplicate code and
thereby reduce the probability of similar inconsistencies arising in
the future.
|
|
Per bug report from Lieven Van Acker, 5/2/01.
|
|
|
|
|
|
|
|
<Jason.Tishler@dothill.com>.
|
|
Convert back to Unix style --- it seems some versions of nmake insist
on this.
|
|
the way to handle this.
|
|
properly on 64 bit systems.
Change submitted by Marc Poinot (Marc.Poinot@onera.fr)
|
|
|
|
This is an extension to the SQL9x standard, but is consistant with usage
of the underlying date_part() function used to implement it.
Example: EXTRACT('YEAR',...)
No impact on regression tests.
|
|
2) fix a bug reported by Jan Wieck.
psqlodbc is 7.01.0005 now.
|
|
number of columns than it was expecting, for reasons that are now
documented in the code...
|
|
join. This is needed to avoid improper evaluation of expressions that
should be nulled out, as in Victor Wagner's bug report of 4/27/01.
Pretty ugly solution, but no time to do anything better for 7.1.1.
|
|
Patches contributed by Victor Wagner.
|
|
it's bogus, try building a btree index on the regress tests' abstime_tbl.)
|
|
Without this, it was making some pretty silly decisions about whether an
expensive sub-SELECT should be the inner or outer side of a join...
|
|
- pgsql v7.0 compatbility
|
