- 27 Jul, 2005 4 commits
-
-
Neil Conway authored
-
Neil Conway authored
parentheses. This avoids possible operator precedence problems, and is consistent with most of the macro definitions in the tree.
-
Neil Conway authored
-
Neil Conway authored
no database has been explicitly specified. Per gripe from Omar Kilani.
-
- 26 Jul, 2005 4 commits
-
-
Tom Lane authored
be rewritten, but at least the reference pages are reasonably sane.
-
Tom Lane authored
sensibly, even though we don't document it.
-
Tom Lane authored
doesn't automatically inherit the privileges of roles it is a member of; for such a role, membership in another role can be exploited only by doing explicit SET ROLE. The default inherit setting is TRUE, so by default the behavior doesn't change, but creating a user with NOINHERIT gives closer adherence to our current reading of SQL99. Documentation still lacking, and I think the information schema needs another look.
-
Tom Lane authored
existing ones for object privileges. Update the information_schema for roles --- pg_has_role() makes this a whole lot easier, removing the need for most of the explicit joins with pg_user. The views should be a tad faster now, too. Stephen Frost and Tom Lane.
-
- 25 Jul, 2005 5 commits
-
-
Tom Lane authored
I'm still working on the has_role function and information_schema changes.
-
Bruce Momjian authored
Adrian Maier
-
Bruce Momjian authored
> o Allow postgresql.conf file values to be changed via an SQL API > o Allow the server to be stopped/restarted via an SQL API
-
Tom Lane authored
pg_strcasecmp and pg_strncasecmp ... but I see some of the former have crept back in. Eternal vigilance is the price of locale independence, apparently.
-
Tom Lane authored
on the not-very-good .so pattern rules in the port-specific Makefiles. (This leaves only pgxs' MODULES case needing those rules.) Also, compile pgsleep.c locally and add it to regress.so to avoid failure on AIX.
-
- 24 Jul, 2005 7 commits
-
-
Tom Lane authored
Per Rocco Altier.
-
Tom Lane authored
-
Tom Lane authored
fails near DST transition days, so remove the advice about that testing problem. Also improve the description of variant-comparison-file selection.
-
Tom Lane authored
error message in Python 2.3 and before. Per Michael Fuhr and buildfarm results.
-
Bruce Momjian authored
interval_mul function.
-
Tom Lane authored
a lossy page has to be lossy, because we don't know exactly which tuples on the page should remain part of the bitmap. Per Jie Zhang.
-
Tom Lane authored
integration. Not clear this explains recent stats problems, but it's definitely wrong.
-
- 23 Jul, 2005 7 commits
-
-
Tom Lane authored
scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
near daylight savings time boudaries. This handles it properly, e.g. test=> select '2005-04-03 04:00:00'::timestamp at time zone 'America/Los_Angeles'; timezone ------------------------ 2005-04-03 07:00:00-04 (1 row)
-
Tom Lane authored
function that actually sleeps, instead of busy-waiting. Perhaps this will resolve some of the intermittent stats failures we keep seeing.
-
Bruce Momjian authored
test=> select (CURRENT_DATE + '05:00'::time)::timestamp at time zone 'Canada/Pacific'; timezone ------------------------ 2005-07-22 08:00:00-04 (1 row)
-
- 22 Jul, 2005 8 commits
-
-
Bruce Momjian authored
test=> select ('2005-07-20 00:00:00'::timestamp without time zone) at time zone 'Europe/Paris'; timezone ------------------------ 2005-07-19 22:00:00-04 Udpate documentation.
-
Tom Lane authored
-
Tom Lane authored
coding would ignore startup cost differences of less than 1% of the estimated total cost; which was OK for normal planning but highly not OK if a very small LIMIT was applied afterwards, so that startup cost becomes the name of the game. Instead, compare startup and total costs fuzzily but independently. This changes the plan selected for two queries in the regression tests; adjust expected-output files for resulting changes in row order. Per reports from Dawid Kuroczko and Sam Mason.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 21 Jul, 2005 5 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
Add SECS_PER_YEAR and MINS_PER_HOUR macros.
-
Bruce Momjian authored
-
Bruce Momjian authored
< > * Research storing disk pages with no alignment/padding
-
Bruce Momjian authored
-