- 19 11月, 2005 3 次提交
-
-
由 Tom Lane 提交于
recursed twice on its first argument, leading to exponential time spent on a deep nest of COALESCEs ... such as a deeply nested FULL JOIN would produce. Per report from Matt Carter.
-
由 Andrew Dunstan 提交于
translate undef to NULL for result arrayref, now that we allow NULLs in arrays. Update plperl regression test accordingly.
-
由 Alvaro Herrera 提交于
-
- 18 11月, 2005 6 次提交
-
-
由 Neil Conway 提交于
-
由 Tom Lane 提交于
contents directly.
-
由 Bruce Momjian 提交于
J.Kuwamura
-
由 Andrew Dunstan 提交于
make psql honor explicit database parameter in -l mode, in case "postgres" database is missing - per complaint from Philip Yarra.
-
由 Tom Lane 提交于
functionality, but I still need to make another pass looking at places that incidentally use arrays (such as ACL manipulation) to make sure they are null-safe. Contrib needs work too. I have not changed the behaviors that are still under discussion about array comparison and what to do with lower bounds.
-
由 Tom Lane 提交于
that was added to localbuf.c in 8.1; therefore, applying it to a temp table left corrupt lookup state in memory. The only case where this had a significant chance of causing problems was an ON COMMIT DELETE ROWS temp table; the other possible paths left bogus state that was unlikely to be used again. Per report from Csaba Nagy.
-
- 17 11月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
< so duplicate checking can be easily performed. > so duplicate checking can be easily performed. It is possible to > do it without a unique index if we require the user to LOCK the table > before the MERGE.
-
由 Tom Lane 提交于
its result when the clause was an OR clause. Brain fade exposed by example from Sebastian BÎck.
-
由 Bruce Momjian 提交于
< * Add a libpq function to support Parse/DescribeStatement capability < * Add PQescapeIdentifier() to libpq < * Prevent PQfnumber() from lowercasing unquoted the column name < < PQfnumber() should never have been doing lowercasing, but historically < it has so we need a way to prevent it < 648a642,661 > > > libpq > > o Add a function to support Parse/DescribeStatement capability > o Add PQescapeIdentifier() > o Prevent PQfnumber() from lowercasing unquoted the column name > > PQfnumber() should never have been doing lowercasing, but > historically it has so we need a way to prevent it > > o Allow query results to be automatically batched to the client > > Currently, all query results are transfered to the libpq > client before libpq makes the results available to the > application. This feature would allow the application to make > use of the first result rows while the rest are transfered, or > held on the server waiting for them to be requested by libpq. > One complexity is that a query like SELECT 1/col could error > out mid-way through the result set.
-
- 16 11月, 2005 6 次提交
-
-
由 Tatsuo Ishii 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> > To implement this cleanly requires that the table have a unique index > so duplicate checking can be easily performed. >
-
由 Bruce Momjian 提交于
features.
-
- 15 11月, 2005 7 次提交
-
-
由 Bruce Momjian 提交于
names from being added to pgindent's typedef list. The existance of them caused weird formatting in the date/type files, and in keywords.c. Backpatch to 8.1.X.
-
由 Bruce Momjian 提交于
columns, shifting comment to the right when more than 150 'else if' clauses were used, and update typedefs for 8.1.X. NetBSD patched updated, with documentation.
-
由 Tom Lane 提交于
sense and rename to "outerjoin_delayed" to more clearly reflect what it means). I had decided that it was redundant in 8.1, but the folly of this is exposed by a bug report from Sebastian Böck. The place where it's needed is to prevent orindxpath.c from cherry-picking arms of an outer-join OR clause to form a relation restriction that isn't actually legal to push down to the relation scan level. There may be some legal cases that this forbids optimizing, but we'd need much closer analysis to determine it.
-
由 Alvaro Herrera 提交于
-
由 Bruce Momjian 提交于
Cosmetic fix only.
-
由 Tom Lane 提交于
slot of the topmost plan node when a trigger returns a modified tuple. These appear to be the only places where a plan node's caller did not treat the result slot as read-only, which is an assumption that nodeUnique makes as of 8.1. Fixes trigger-vs-DISTINCT bug reported by Frank van Vugt.
-
由 Teodor Sigaev 提交于
of self-defined macros, add limit of Array to gist__int_ops. BTW, intarray now doesn't support NULLs in arrays.
-
- 14 11月, 2005 3 次提交
-
-
由 Teodor Sigaev 提交于
Use postgres-wide macros BITS_PER_BYTE instead self-definenig macros, also use it for calculating bit length of TPQTGist
-
由 Teodor Sigaev 提交于
-
由 Tom Lane 提交于
surprising results when it's some other numeric type. This doesn't solve the generic problem of surprising implicit casts to text, but it's a low-impact way of making sure this particular case behaves sanely. Per gripe from Harald Fuchs and subsequent discussion.
-
- 13 11月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
indent bug.
-
- 10 11月, 2005 3 次提交
-
-
由 Andrew Dunstan 提交于
add missing quote mark to ident_file sample line - per Hiroshi Saito
-
由 Tom Lane 提交于
anything but transaction-exiting commands (ROLLBACK etc). We already rejected Parse and Execute in such cases, so there seems little point in allowing Bind. This prevents at least an Assert failure, and probably worse things, since there's a lot of infrastructure that doesn't work when not in a live transaction. We can also simplify the Bind logic a bit by rejecting messages with a nonzero number of parameters, instead of the former kluge to silently substitute NULL for each parameter. Per bug #2033 from Joel Stevenson.
-
由 Tom Lane 提交于
-
- 09 11月, 2005 2 次提交
-
-
由 Teodor Sigaev 提交于
Instead of getting elements of array manually call deconstruct_array
-
由 Teodor Sigaev 提交于
1 Comparison operation for tsquery 2 Btree index on tsquery 3 numnode(tsquery) - returns 'length' of tsquery 4 tsquery @ tsquery, tsquery ~ tsquery - contains, contained for tsquery. Note: They don't gurantee exact result, only MAY BE, so it useful only for speed up rewrite functions 5 GiST index support for @,~ 6 rewrite(): select rewrite(orig, what, to); select rewrite(ARRAY[orig, what, to]) from tsquery_table; select rewrite(orig, 'select what, to from tsquery_table;'); 7 significantly improve cover algorithm
-
- 08 11月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Tom Lane 提交于
-
- 07 11月, 2005 3 次提交
-
-
由 Alvaro Herrera 提交于
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
on every index page they read; in particular to catch the case of an all-zero page, which PageHeaderIsValid allows to pass. It turns out hash already had this idea, but it was just Assert()ing things rather than doing a straight error check, and the Asserts were partially redundant with PageHeaderIsValid anyway. Per recent failure example from Jim Nasby. (gist still needs the same treatment.)
-