| Age | Commit message (Collapse) | Author |
|---|
|
used within WAL files. Historically this was the same as the data file
BLCKSZ, but there's no necessary connection, and it's possible that
performance gains might ensue from reducing XLOG_BLCKSZ. In any case
distinguishing two symbols should improve code clarity. This commit
does not actually change the page size, only provide the infrastructure
to make it possible to do so. initdb forced because of addition of a
field to pg_control.
Mark Wong, with some help from Simon Riggs and Tom Lane.
|
|
|
|
|
|
to fix regressions introduced in the recent patch adding additional
\connect options. This is based on work by Volkan YAZICI, although
this version of the patch doesn't bear much resemblance to Volkan's
version.
\connect takes 4 optional arguments: database name, user name, host
name, and port number. If any of those parameters are omitted or
specified as "-", the value of that parameter from the previous
connection is used instead; if there is no previous connection,
the libpq default is used. Note that this behavior makes it
impossible to reuse the libpq defaults without quitting psql and
restarting it; I don't really see the use case for needing to do
that.
|
|
|
|
for REASSIGN OWNED and DROP OWNED.
|
|
|
|
worked and someone asked about them, so we might as well document them.
|
|
|
|
var_samp(), stddev_pop(), and stddev_samp(). var_samp() and stddev_samp()
are just renamings of the historical Postgres aggregates variance() and
stddev() -- the latter names have been kept for backward compatibility.
This patch includes updates for the documentation and regression tests.
The catversion has been bumped.
NB: SQL2003 requires that DISTINCT not be specified for any of these
aggregates. Per discussion on -patches, I have NOT implemented this
restriction: if the user asks for stddev(DISTINCT x), presumably they
know what they are doing.
|
|
|
|
|
|
|
|
|
|
> * -Eventually enable escape_string_warning and standard_conforming_strings
|
|
- new function justify_interval(interval)
- modified function justify_hours(interval)
- modified function justify_days(interval)
These functions are defined to meet the requirements as discussed in
this thread. Specifically:
- justify_hours makes certain the sign bit on the hours
matches the sign bit on the days. It only checks the
sign bit on the days, and not the months, when
determining if the hours should be positive or negative.
After the call, -24 < hours < 24.
- justify_days makes certain the sign bit on the days
matches the sign bit on the months. It's behavior does
not depend on the hours, nor does it modify the hours.
After the call, -30 < days < 30.
- justify_interval makes sure the sign bits on all three
fields months, days, and hours are all the same. After
the call, -24 < hours < 24 AND -30 < days < 30.
Mark Dilger
|
|
Kevin Grittner
|
|
> o Prevent parent tables from altering or dropping constraints
> like CHECK that are inherited by child tables
>
> Dropping constraints should only be possible with CASCADE.
>
|
|
> o Check WSACancelBlockingCall() for interrupts (win32intr)
>
|
|
> o Add COPY TO STDIN / STDOUT handling
|
|
< * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns
> * %Disallow ALTER SEQUENCE changes for SERIAL sequences because pg_dump
> does not dump the changes
|
|
> * %Disallow changing sequence characteristics like INCREMENT for SERIAL columns
|
|
returning "ASCII code of the first character of the argument"
(see
http://www.postgresql.org/docs/8.1/interactive/functions-string.html,
Table 9-6. "Other String Functions").
Presumably this should read "ASCII code of the first byte of the
argument",
which is what is returned when the argument is a multi-byte character
(although then with UTF-8 at least that might not necessarily be an
ASCII
code).
Ian Barwick
|
|
> o Port contrib/xml2
|
|
and docs from Dmitry Karasik, slightly editorialised.
|
|
|
|
> o -Add "include file" functionality in postgresql.conf
|
|
example of /etc/sysctl.conf contents.
|
|
Patch by Joachim Wieland, somewhat reworked for clarity and portability.
|
|
> * Allow FSM page return free space based on table clustering, to assist
> in maintaining clustering?
|
|
> just that certain commands do. TRUNCATE isn't shown.
Patch against HEAD to add TRUNCATE to the list of commands that aquire
ACCESS EXCLUSIVE.
Jim C. Nasby, Sr.
|
|
descriptions after the code are correct). Only shmmax needs to be
multiples of the page size (at least, that's how I interpret the
Darwin code).
Chris Campbell
|
|
|
|
and tighten up its sanity checking of the tag as a safety measure.
Volkan Yazici.
|
|
> * -Allow TRUNCATE ... CASCADE/RESTRICT
|
|
< o %Have COPY return the number of rows loaded/unloaded?
> o -Have COPY return the number of rows loaded/unloaded?
|
|
rows copied. Backend side of Volkan Yazici's recent patch, with
corrections and documentation.
|
|
|
|
> * Allow FSM to return free space toward the beginning of the heap file,
> in hopes that empty pages at the end can be truncated by VACUUM
|
|
ROLE page, based on what Tom Lane told me here:
http://archives.postgresql.org/pgsql-general/2005-11/msg00998.php
Joachim Wieland
|
|
> * Add missing parameter handling in to_char()
>
> http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php
>
|
|
> * Allow to_date() and to_timestamp() accept localized month names
|
|
was opening with INV_READ flag and then writing. Prior to 8.1 the backend
did not reject this, but now it does.
|
|
/etc/sysctl.conf.
Chris Campbell
|
|
|
|
> * Improve port/qsort() to handle sorts with 50% unique and 50% duplicate
> value [qsort]
>
> This involves choosing better pivot points for the quicksort.
|
|
|
|
Robert Treat
|
|
|
|
more compliant with the error message style guide. In particular,
errdetail should begin with a capital letter and end with a period,
whereas errmsg should not. I also fixed a few related issues in
passing, such as fixing the repeated misspelling of "lexeme" in
contrib/tsearch2 (per Tom's suggestion).
|
