- 16 Jan, 2007 6 commits
-
-
Neil Conway authored
* After Markos patch, now builds pgcrypto without zlib again * Updates README with xml info * xml requires xslt and iconv * disable unnecessary warning about __cdecl() * Add a buildenv.bat called from all other bat files to set up things like PATH for flex/bison. (Can't just set it before calling, doesn't always work when building from the GUI)
-
Neil Conway authored
The implementation is somewhat ugly logic-wise, but I don't see an easy way to make it more concise. When writing this, I noticed that my previous implementation of width_bucket() doesn't handle NaN correctly: postgres=# select width_bucket('NaN', 1, 5, 5); width_bucket -------------- 6 (1 row) AFAICS SQL:2003 does not define a NaN value, so it doesn't address how width_bucket() should behave here. The patch changes width_bucket() so that ereport(ERROR) is raised if NaN is specified for the operand or the lower or upper bounds to width_bucket(). For float8, NaN is disallowed for any of the floating-point inputs, and +/- infinity is disallowed for the histogram bounds (but allowed for the operand). Update docs and regression tests, bump the catversion.
-
Neil Conway authored
existing TODO items, and re-add a TODO item for an "estimated count" capability.
-
Tom Lane authored
it was checking a pg_constraint OID instead of pg_class OID, resulting in "relation with OID nnnnn does not exist" failures for anyone who wasn't owner of the table being examined. Per bug #2848 from Laurence Rowe. Note: for existing 8.2 installations a simple version update won't fix this; the easiest fix is to CREATE OR REPLACE this view with the corrected definition.
-
Alvaro Herrera authored
-
Alvaro Herrera authored
accessing it, like DROP DATABASE. This allows the regression tests to pass with autovacuum enabled, which open the gates for finally enabling autovacuum by default.
-
- 15 Jan, 2007 2 commits
-
-
Neil Conway authored
roles and tablespaces, no longer users and groups. Per Dave Page. Backport to 8.2 and 8.1.
-
Teodor Sigaev authored
Slightly reworked patch from Tatsuo Ishii
-
- 14 Jan, 2007 4 commits
-
-
Neil Conway authored
Per recent -hackers thread, this is noteworthy because Postgres behaves differently from most implementations of NaN, including IEEE754.
-
Peter Eisentraut authored
-
Alvaro Herrera authored
Patch from Marko Kreen.
-
Peter Eisentraut authored
-
- 13 Jan, 2007 1 commit
-
-
Bruce Momjian authored
< o Fix memory leak from exceptions < < http://archives.postgresql.org/pgsql-performance/2006-06/msg00305.php < < * Allow constraint_exclusion to work for UNIONs like it does for < inheritance, allow it to work for UPDATE and DELETE statements, and allow < it to be used for all statements with little performance impact < < * Add estimated_count(*) to return an estimate of COUNT(*) < < This would use the planner ANALYZE statistics to return an estimated < count. < http://archives.postgresql.org/pgsql-hackers/2005-11/msg00943.php
-
- 12 Jan, 2007 11 commits
-
-
Tom Lane authored
standard convention the 21st century runs from 2001-2100, not 2000-2099, so make it work like that. Per bug #2885 from Akio Iwaasa. Backpatch to 8.2, but no further, since this is really a definitional change; users of older branches are probably more interested in stability.
-
Peter Eisentraut authored
-
Peter Eisentraut authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
hold true for operators in a btree operator family. This is mostly to clarify my own thinking about what the planner can assume for optimization purposes. (blowing dust off an old abstract-algebra textbook...)
-
Peter Eisentraut authored
coercion to type xml was a mistake. Escape values so they are valid XML character data.
-
Michael Meskes authored
-
Michael Meskes authored
create expected file with correct port number
-
Michael Meskes authored
Added patch by Joachim to work around OpenBSD bug in regression suite.
-
- 11 Jan, 2007 14 commits
-
-
Tom Lane authored
(or other types of pg_class entry): the function pgstat_vacuum_tabstat, invoked during VACUUM startup, had runtime proportional to the number of stats table entries times the number of pg_class rows; in other words O(N^2) if the stats collector's information is reasonably complete. Replace list searching with a hash table to bring it back to O(N) behavior. Per report from kim at myemma.com. Back-patch as far as 8.1; 8.0 and before use different coding here.
-
Bruce Momjian authored
expressions/functions.
-
Bruce Momjian authored
ORDER BY.
-
Tom Lane authored
So far only tested by hacking the planner ...
-
Michael Meskes authored
Made this option mark the .c files, so the environment variable is no longer needed. Created a special MinGW file with the special error message. Do not print port into log file when running regression tests.
-
-
Bruce Momjian authored
> o Fix transaction restriction checks for CREATE DATABASE and > other commands > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00133.php
-
-
Bruce Momjian authored
> o Extend timezone code to allow 64-bit values so we can > represent years beyond 2038 > > http://archives.postgresql.org/pgsql-hackers/2006-09/msg01363.php >
-
Bruce Momjian authored
> * Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h and > consider making it more configurable in future releases
-
Bruce Momjian authored
Backpatch to 8.2.X. L Bayuk
-
Bruce Momjian authored
L Bayuk
-
Bruce Momjian authored
-
Bruce Momjian authored
Documentation/comment improvements.
-
- 10 Jan, 2007 2 commits
-
-
Peter Eisentraut authored
our own printing dance. This does a better job of quoting and escaping the values.
-
Bruce Momjian authored
-