- 23 3月, 2007 3 次提交
-
-
由 Tom Lane 提交于
doesn't exist. This allows DROP to be used to clean out the pg_tablespace catalog entry in a situation where a previous DROP attempt failed before committing but after having removed the directories and symlink. Per report from William Garrison. Even though his test case depends on an unrelated bug in PreventTransactionChain, it's certainly possible for this situation to arise due to other problems, eg a system crash at just the right time.
-
由 Bruce Momjian 提交于
full words support, per report from Mark Stosberg.
-
由 Alvaro Herrera 提交于
of palloc instead of malloc, which means a list can be freed simply by deleting the memory context that contains it.
-
- 22 3月, 2007 10 次提交
-
-
由 Teodor Sigaev 提交于
sizeof(wchar_t) = 2 instead of 4.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Magnus Hagander 提交于
-
由 Tom Lane 提交于
First, genericcostestimate() was being way too liberal about including partial-index conditions in its selectivity estimate, resulting in substantial underestimates for situations such as an indexqual "x = 42" used with an index on x "WHERE x >= 40 AND x < 50". While the code is intentionally set up to favor selecting partial indexes when available, this was too much... Second, choose_bitmap_and() was likewise easily fooled by cases of this type, since it would similarly think that the partial index had selectivity independent of the indexqual. Fixed by using predicate_implied_by() rather than simple equality checks to determine redundancy. This is a good deal more expensive but I don't see much alternative. At least the extra cost is only paid when there's actually a partial index under consideration. Per report from Jeff Davis. I'm not going to risk back-patching this, though.
-
由 Bruce Momjian 提交于
< < > o During index creation, pre-sort the tuples to improve build speed > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php >
-
由 Bruce Momjian 提交于
< * Add NUMERIC division operator that doesn't round? < < Currently NUMERIC _rounds_ the result to the specified precision. < This means division can return a result that multiplied by the < divisor is greater than the dividend, e.g. this returns a value > 10: < < SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; < < The positive modulus result returned by NUMERICs might be considered < inaccurate, in one sense. <
-
由 Magnus Hagander 提交于
-
由 Bruce Momjian 提交于
* Add locale-aware MONEY type, and support multiple currencies http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php
-
由 Magnus Hagander 提交于
-
- 21 3月, 2007 6 次提交
-
-
由 Magnus Hagander 提交于
-
由 Magnus Hagander 提交于
Uses same underlying tech as before, but not the sysv emulation layer.
-
由 Bruce Momjian 提交于
* Allow accurate statistics to be collected on indexes with more than one column or expression indexes, perhaps using per-index statistics > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< o -Allow commenting of variables in postgresql.conf to restore them > o Allow commenting of variables in postgresql.conf to restore them
-
由 Bruce Momjian 提交于
> o -Allow commenting of variables in postgresql.conf to restore them < http://archives.postgresql.org/pgsql-hackers/2006-09/msg01481.php
-
- 20 3月, 2007 6 次提交
-
-
由 Neil Conway 提交于
and regexp_split_to_table. These functions provide access to the capture groups resulting from a POSIX regular expression match, and provide the ability to split a string on a POSIX regular expression, respectively. Patch from Jeremy Drake; code review by Neil Conway, additional comments and suggestions from Tom and Peter E. This patch bumps the catversion, adds some regression tests, and updates the docs.
-
由 Jan Wieck 提交于
BTW, the comment in this file says that we hope we never have more than 10 catversion changes per day, but to even make this possible we should start counting at zero, shouldn't we? Jan
-
由 Jan Wieck 提交于
rules to be defined with different, per session controllable, behaviors for replication purposes. This will allow replication systems like Slony-I and, as has been stated on pgsql-hackers, other products to control the firing mechanism of triggers and rewrite rules without modifying the system catalog directly. The firing mechanisms are controlled by a new superuser-only GUC variable, session_replication_role, together with a change to pg_trigger.tgenabled and a new column pg_rewrite.ev_enabled. Both columns are a single char data type now (tgenabled was a bool before). The possible values in these attributes are: 'O' - Trigger/Rule fires when session_replication_role is "origin" (default) or "local". This is the default behavior. 'D' - Trigger/Rule is disabled and fires never 'A' - Trigger/Rule fires always regardless of the setting of session_replication_role 'R' - Trigger/Rule fires when session_replication_role is "replica" The GUC variable can only be changed as long as the system does not have any cached query plans. This will prevent changing the session role and accidentally executing stored procedures or functions that have plans cached that expand to the wrong query set due to differences in the rule firing semantics. The SQL syntax for changing a triggers/rules firing semantics is ALTER TABLE <tabname> <when> TRIGGER|RULE <name>; <when> ::= ENABLE | ENABLE ALWAYS | ENABLE REPLICA | DISABLE psql's \d command as well as pg_dump are extended in a backward compatible fashion. Jan
-
由 Bruce Momjian 提交于
"If the patch is not BSD-licensed, it will be rejected."
-
由 Tom Lane 提交于
test in parallel with the rules test at all, because the former wants to create a couple of temp views, which can sometimes show up in the latter's output. Let's try it in the next parallel group instead.
-
由 Tom Lane 提交于
to cover it. Per report from Anton Pikhteryev.
-
- 19 3月, 2007 5 次提交
-
-
由 Bruce Momjian 提交于
* Simplify ability to create partitioned tables > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00375.php
-
由 Bruce Momjian 提交于
* Allow sequential scans to take advantage of other concurrent sequential scans, also called "Synchronised Scanning" http://archives.postgresql.org/pgsql-hackers/2007-03/msg00415.php
-
由 Magnus Hagander 提交于
-
由 Tom Lane 提交于
on preproc.h, else make may try to build it before preproc.h is ready. Per failures seen here and in buildfarm.
-
由 Neil Conway 提交于
are initialized with a string literal. Patch from Stefan Huehner.
-
- 18 3月, 2007 4 次提交
-
-
由 Neil Conway 提交于
to ANSI-style, and change "()" -> "(void)". Patch from Stefan Huehner.
-
由 Michael Meskes 提交于
-
由 Michael Meskes 提交于
- Made some chars const as proposed by Stefan Huehner <stefan@huehner.org>. - Synced parser and keyword lists. - Copied two token parsing from backend parser to ecpg parser. - Also added a test case for this.
-
由 Magnus Hagander 提交于
-
- 17 3月, 2007 6 次提交
-
-
由 Magnus Hagander 提交于
-
由 Magnus Hagander 提交于
what each script does.
-
由 Magnus Hagander 提交于
-
由 Magnus Hagander 提交于
skeleton scripts calling them. To make it easier for the buildfarm (or other "outside callers") to use these modules directly. Per suggestion from Andrew Dunstan.
-
由 Tom Lane 提交于
executed in read_only mode. This could lead to various relatively-subtle failures, such as an allegedly stable function returning non-stable results. Bug goes all the way back to the introduction of read-only mode in 8.0. Per report from Gaetano Mendola.
-
由 Tom Lane 提交于
cut at exprTypmod support. Also, experimentation shows that we need to label the type of Const nodes that are numeric with a specific typmod.
-