- 09 11月, 2002 2 次提交
-
-
由 Tom Lane 提交于
precision for float4, float8, and geometric types. Set it in pg_dump so that float data can be dumped/reloaded exactly (at least on platforms where the float I/O support is properly implemented). Initial patch by Pedro Ferreira, some additional work by Tom Lane.
-
由 Bruce Momjian 提交于
now)" item on the open items, and subsequent plpgsql function I sent in, made me realize it was too hard to get the upper and lower bound of an array. The attached creates two functions that I think will be very useful when combined with the ability of plpgsql to return sets. array_lower(array, dim_num) - and - array_upper(array, dim_num) They return the value (as an int) of the upper and lower bound of the requested dim in the provided array. Joe Conway
-
- 03 11月, 2002 1 次提交
-
-
由 Tom Lane 提交于
where it's safe to do database access. Along the way, fix core dump for 'DEFAULT' parameters to CREATE DATABASE. initdb forced due to change in pg_proc entry.
-
- 02 11月, 2002 3 次提交
-
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
(usually bison output files), not as standalone files. This hack works around flex's insistence on including <stdio.h> before we are able to include postgres.h; postgres.h will already be read before the compiler starts to read the flex output file. Needed for largefile support on some platforms.
-
由 Tom Lane 提交于
core file to be produced for debugging, and avoids trying to run the normal proc-exit cleanup hooks, which are likely to cause additional problems if the system is hosed.
-
- 01 11月, 2002 3 次提交
-
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
between signal handler and enable/disable code, avoid accumulation of timing error due to trying to maintain remaining-time instead of absolute-end-time, disable timeout before commit not after.
-
由 Tom Lane 提交于
conform to C99's brain-dead notion of how inline functions should work.
-
- 26 10月, 2002 1 次提交
-
-
由 Tom Lane 提交于
-
- 19 10月, 2002 3 次提交
-
-
由 Tom Lane 提交于
Ray Ontko 28-June-02. Also, fix prefix_selectivity for NAME lefthand variables (it was bogusly assuming binary compatibility), and adjust make_greater_string() to not call pg_mbcliplen() with invalid multibyte data (this last per bug report that I can't find at the moment, but it was in July '02).
-
由 Bruce Momjian 提交于
specifically ceil(), floor(), and sign(). There may be other functions that need to be added, but this is a start. I've included some simple regression tests. Neil Conway
-
由 Tom Lane 提交于
been bit by the fact that the locale functions return pointers to modifiable variables. I added some comments that might help us avoid the mistake in future.
-
- 15 10月, 2002 1 次提交
-
-
由 Tom Lane 提交于
query that uses it. This ensures that triggers will be applied consistently throughout a query even if someone commits changes to the relation's pg_class.reltriggers field meanwhile. Per crash report from Laurette Cisneros. While at it, simplify memory management in relcache.c, which no longer needs the old hack to try to keep trigger info in the same place over a relcache entry rebuild. (Should try to fix rd_att and rewrite-rule access similarly, someday.) And make RelationBuildTriggers simpler and more robust by making it build the trigdesc in working memory and then CopyTriggerDesc() into cache memory.
-
- 13 10月, 2002 1 次提交
-
-
由 Tom Lane 提交于
Per gripe from Patrick Welche, 13-Oct-2002.
-
- 11 10月, 2002 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 09 10月, 2002 1 次提交
-
-
由 Tom Lane 提交于
into postgres.c; make sure it happens for all cases that seem to need it. Perhaps it would be better to explicitly exclude just a few utility statement types from setting a snapshot?
-
- 05 10月, 2002 2 次提交
-
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
just the significant fields of FunctionCallInfoData, rather than MemSet'ing the whole struct to zero. Unused positions in the arg[] array will thereby contain garbage rather than zeroes. This buys back some of the performance hit from increasing FUNC_MAX_ARGS. Also tweak tuplesort.c code for more speed by marking some routines 'inline'. All together these changes speed up simple sorts, like count(distinct int4column), by about 25% on a P4 running RH Linux 7.2.
-
- 04 10月, 2002 3 次提交
-
-
由 Tom Lane 提交于
are missing the FROM clause (due to a long-ago pg_dump bug). Patch by Stephan Szabo, minor tweaking by Tom Lane.
-
由 Tom Lane 提交于
to avoid unnecessary consumption of semaphores.
-
由 Bruce Momjian 提交于
Neil Conway
-
- 03 10月, 2002 2 次提交
-
-
由 Tom Lane 提交于
so that precision of result is always at least as good as you'd get from float8 arithmetic (ie, always at least 16 digits of accuracy). Per pg_hackers discussion a few days ago.
-
由 Bruce Momjian 提交于
-
- 25 9月, 2002 2 次提交
-
-
由 Tom Lane 提交于
and PUBLIC EXECUTE, respectively. Per discussion about easing updates from prior versions.
-
由 Peter Eisentraut 提交于
document that scheme.
-
- 23 9月, 2002 3 次提交
-
-
由 Tom Lane 提交于
even when dealing with a nailed-in-cache relation; otherwise, following VACUUM truncation of a system catalog, other backends might have unreasonably large values of these fields.
-
由 Tom Lane 提交于
-
由 Tom Lane 提交于
the SQL99 standard. (I'm not sure that the character-class features are quite right, but that can be fixed later.) Document SQL99 and POSIX regexps as being different features; provide variants of SUBSTRING for each.
-
- 22 9月, 2002 1 次提交
-
-
由 Tom Lane 提交于
-ffast-math.
-
- 20 9月, 2002 5 次提交
-
-
由 Bruce Momjian 提交于
* to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not Karel Zak
-
由 Bruce Momjian 提交于
> I see in your recent bytea-LIKE patch > > if (datatype != BYTEAOID && pg_database_encoding_max_length() > 1) > len = pg_mbcliplen((const unsigned char *) workstr, len, len - 1); > else > len -= -1; > > Surely there's one too many minus signs in that last? Joe Conway
-
由 Bruce Momjian 提交于
fixes a few minor bugs (typos, potential buffer overruns, etc.), and fixes some spelling/grammar mistakes. Neil Conway
-
由 Tom Lane 提交于
composite types. Add a couple more lsyscache.c routines to support this, and make use of them in some other places that were doing lookups the hard way.
-
由 Tom Lane 提交于
ruleutils display is not such a great idea. For arguments of functions and operators I think we'd better keep the historical behavior of showing such casts explicitly, to ensure that the function/operator is reparsed the same way when the rule is reloaded. This also makes the output of EXPLAIN less obscurantist about exactly what's happening.
-
- 19 9月, 2002 1 次提交
-
-
由 Tom Lane 提交于
to be flexible about assignment casts without introducing ambiguity in operator/function resolution. Introduce a well-defined promotion hierarchy for numeric datatypes (int2->int4->int8->numeric->float4->float8). Change make_const to initially label numeric literals as int4, int8, or numeric (never float8 anymore). Explicitly mark Func and RelabelType nodes to indicate whether they came from a function call, explicit cast, or implicit cast; use this to do reverse-listing more accurately and without so many heuristics. Explicit casts to char, varchar, bit, varbit will truncate or pad without raising an error (the pre-7.2 behavior), while assigning to a column without any explicit cast will still raise an error for wrong-length data like 7.3. This more nearly follows the SQL spec than 7.2 behavior (we should be reporting a 'completion condition' in the explicit-cast cases, but we have no mechanism for that, so just do silent truncation). Fix some problems with enforcement of typmod for array elements; it didn't work at all in 'UPDATE ... SET array[n] = foo', for example. Provide a generalized array_length_coerce() function to replace the specialized per-array-type functions that used to be needed (and were missing for NUMERIC as well as all the datetime types). Add missing conversions int8<->float4, text<->numeric, oid<->int8. initdb forced.
-
- 18 9月, 2002 2 次提交
-
-
由 Tatsuo Ishii 提交于
-
由 Tatsuo Ishii 提交于
conversion function interface.
-
- 13 9月, 2002 1 次提交
-
-
由 Tatsuo Ishii 提交于
Change PG_RETURN_INT32(0) to PG_RETURN_VOID()
-