- 29 Jan, 2003 6 commits
-
-
Tom Lane authored
a tuple table. Fixes core dump in pltcl (and probably other PLs) when executing a query rewritten by a rule. Per bug report from Wolfgang Walter.
-
Bruce Momjian authored
-
Tom Lane authored
cannot actually happen at present because ArrayCount() is only called on strings beginning with '{', but seems best to prevent it going forward. Per report from Yichen Xie.
-
Tom Lane authored
can only occur if the constant DEFAULT_CLIENT_AUTHSVC is given a bogus value, so it doesn't seem worth back-patching, but I'll fix it in HEAD.
-
Tom Lane authored
value of MAX_TIME_PRECISION in floating-point-timestamp-storage case from 13 to 10, which is as much as time_out is actually willing to print. (The alternative of increasing the number of digits we are willing to print looks risky; we might find ourselves printing roundoff garbage.)
-
Tom Lane authored
-
- 28 Jan, 2003 5 commits
-
-
Tom Lane authored
passed to join selectivity estimators. Make use of this in eqjoinsel to derive non-bogus selectivity for IN clauses. Further tweaking of cost estimation for IN. initdb forced because of pg_proc.h changes.
-
Peter Eisentraut authored
separate macro. Also add support for %I64d which is the way on Windows. The code that checks for the 64-bit int type now gives more reasonable results when cross-compiling: In that case we just take the compiler's information and trust that the arithmetic works. Disabling int64 is too pessimistic.
-
Tom Lane authored
in GUCArrayAdd/GUCArrayDelete. This prevents the multiple-entry bug exhibited by Frank Lupo 28-Jan-2003.
-
Bruce Momjian authored
Set log_min_error_messages to the proper and agreed-upon default, PANIC (off). (BACKPATCH)
-
Bruce Momjian authored
-
- 27 Jan, 2003 8 commits
-
-
Bruce Momjian authored
Backpatch to 7.3.X.
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Add the concept of dataspaces/tablespaces [tablespaces] 307d307 < * Add the concept of dataspaces/tablespaces [tablespaces]
-
Bruce Momjian authored
-
Tom Lane authored
Try to model the effect of rescanning input tuples in mergejoins; account for JOIN_IN short-circuiting where appropriate. Also, recognize that mergejoin and hashjoin clauses may now be more than single operator calls, so we have to charge appropriate execution costs.
-
Bruce Momjian authored
-
Tom Lane authored
-
Tom Lane authored
Problem reported and fixed by Oliver Elphick.
-
- 26 Jan, 2003 3 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
suggestion of Peter.
-
Bruce Momjian authored
> * Add group object ownership, so groups can rename/drop/grant on objects, > so we can implement roles
-
- 25 Jan, 2003 3 commits
-
-
Tom Lane authored
necessarily following the JOIN syntax to develop the query plan. The old behavior is still available by setting GUC variable JOIN_COLLAPSE_LIMIT to 1. Also create a GUC variable FROM_COLLAPSE_LIMIT to control the similar decision about when to collapse sub-SELECT lists into their parent lists. (This behavior existed already, but the limit was always GEQO_THRESHOLD/2; now it's separately adjustable.)
-
Tom Lane authored
of the socket file and socket lock file; this should prevent both of them from being removed by even the stupidest varieties of /tmp-cleaning script. Per suggestion from Giles Lean.
-
Tom Lane authored
rather than actually opening the files. This eliminates some corner cases where the file indeed exists but open() fails for another reason, such as being out of file descriptors. The net reliability gain is probably tiny, since xlog.c is full of other file open calls that will elog(PANIC) if they fail for any reason; but this specific failure mode has been observed in the field, so we may as well fix it.
-
- 24 Jan, 2003 2 commits
-
-
Tom Lane authored
-
Tom Lane authored
of known-equal expressions includes any constant expressions (including Params from outer queries), we actively suppress any 'var = var' clauses that are or could be deduced from the set, generating only the deducible 'var = const' clauses instead. The idea here is to push down the restrictions implied by the equality set to base relations whenever possible. Once we have applied the 'var = const' clauses, the 'var = var' clauses are redundant, and should be suppressed both to save work at execution and to avoid double-counting restrictivity.
-
- 23 Jan, 2003 5 commits
-
-
Peter Eisentraut authored
users right now, not groups. Extension of has_foo_privileges functions to query the grant options. Extension of aclitem type to store grantor.
-
Dave Cramer authored
-
Tom Lane authored
-
Tom Lane authored
for backwards compatibility with pre-7.3 behavior. Per discussion on pgsql-general and pgsql-hackers.
-
Tom Lane authored
forms of ceil(), floor(), sign(). Back-patch this and other recent doc fixes in this file to the 7.3 branch.
-
- 22 Jan, 2003 4 commits
- 21 Jan, 2003 4 commits
-
-
Tom Lane authored
that's selecting into a RECORD variable returns zero rows, make it assign an all-nulls row to the RECORD; this is consistent with what happens when the SELECT INTO target is not a RECORD. In support of this, tweak the SPI code so that a valid tuple descriptor is returned even when a SPI select returns no rows.
-
Michael Meskes authored
-
Tom Lane authored
-
Peter Eisentraut authored
-