- 22 8月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
interchanged.
-
- 21 8月, 2006 1 次提交
-
-
由 Tom Lane 提交于
by abandoning the idea that it should say SERIAL in the dump. Instead, dump serial sequences and column defaults just like regular ones. Add a new backend command ALTER SEQUENCE OWNED BY to let pg_dump recreate the sequence-to-column dependency that was formerly created "behind the scenes" by SERIAL. This restores SERIAL to being truly "just a macro" consisting of component operations that can be stated explicitly in SQL. Furthermore, the new command allows sequence ownership to be reassigned, so that old mistakes can be cleaned up. Also, downgrade the OWNED-BY dependency from INTERNAL to AUTO, since there is no longer any very compelling argument why the sequence couldn't be dropped while keeping the column. (This forces initdb, to be sure the right kinds of dependencies are in there.) Along the way, add checks to prevent ALTER OWNER or SET SCHEMA on an owned sequence; you can now only do this indirectly by changing the owning table's owner or schema. This is an oversight in previous releases, but probably not worth back-patching.
-
- 18 8月, 2006 1 次提交
-
-
由 Tom Lane 提交于
than N seconds apart. This allows a simple, if not very high performance, means of guaranteeing that a PITR archive is no more than N seconds behind real time. Also make pg_current_xlog_location return the WAL Write pointer, add pg_current_xlog_insert_location to return the Insert pointer, and fix pg_xlogfile_name_offset to return its results as a two-element record instead of a smashed-together string, as per recent discussion. Simon Riggs
-
- 06 8月, 2006 1 次提交
-
-
由 Tom Lane 提交于
to happen automatically during pg_stop_backup(). Add some functions for interrogating the current xlog insertion point and for easily extracting WAL filenames from the hex WAL locations displayed by pg_stop_backup and friends. Simon Riggs with some editorialization by Tom Lane.
-
- 29 7月, 2006 1 次提交
-
-
由 Tom Lane 提交于
the float8 versions of the aggregates, which is all that the standard requires. Sergey's original patch also provided versions using numeric arithmetic, but given the size and slowness of the code, I doubt we ought to include those in core.
-
- 17 7月, 2006 1 次提交
-
-
由 Neil Conway 提交于
don't include a space between the function name and the parenthesis that begins its parameter list, for consistency.
-
- 14 7月, 2006 1 次提交
-
-
由 Neil Conway 提交于
are alphabetically ordered. I believe the tables were correctly ordered in the past, but some of them had subsequently regressed.
-
- 12 7月, 2006 1 次提交
-
-
由 Neil Conway 提交于
SGML cleanup: sort table entries alphabetically.
-
- 06 7月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
for the usage of full time zone names. Joachim Wieland
-
- 20 6月, 2006 1 次提交
-
-
由 Tom Lane 提交于
functions.
-
- 18 6月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
symlink is kept for now for compatibility. To call single-user mode, use postgres --single.
-
- 16 6月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
description. Nis Jorgensen
-
- 30 5月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
Joachim Wieland
-
- 18 5月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 01 5月, 2006 1 次提交
-
-
由 Tom Lane 提交于
CONNECTION, fix a number of places that were missed (eg pg_dump support), avoid executing an extra search of pg_database during startup.
-
- 25 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
transaction_timestamp() (just like now()). Also update statement_timeout() to mention it is statement arrival time that is measured. Catalog version updated.
-
- 23 4月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
compatibility for release 7.2 and earlier. I have not altered any mentions of release 7.3 or later. The release notes were not modified, so the changes are still documented, just not in the main docs.
-
- 11 3月, 2006 2 次提交
-
-
由 Neil Conway 提交于
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.
-
由 Bruce Momjian 提交于
-
- 07 3月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
- 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
-
- 06 3月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
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
-
- 04 3月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 19 2月, 2006 1 次提交
-
-
由 Peter Eisentraut 提交于
up a bunch of the support utilities. In src/backend/utils/mb/Unicode remove nearly duplicate copies of the UCS_to_XXX perl script and replace with one version to handle all generic files. Update the Makefile so that it knows about all the map files. This produces a slight difference in some of the map files, using a uniform naming convention and not mapping the null character. In src/backend/utils/mb/conversion_procs create a master utf8<->win codepage function like the ISO 8859 versions instead of having a separate handler for each conversion. There is an externally visible change in the name of the win1258 to utf8 conversion. According to the documentation notes, it was named incorrectly and this changes it to a standard name. Running the Unicode mapping perl scripts has shown some additional mapping changes in koi8r and iso8859-7.
-
- 12 2月, 2006 2 次提交
-
-
由 Bruce Momjian 提交于
Euler Taveira de Oliveira
-
由 Bruce Momjian 提交于
comments on cluster global objects like databases, tablespaces, and roles. It touches a lot of places, but not much in the way of big changes. The only design decision I made was to duplicate the query and manipulation functions rather than to try and have them handle both shared and local comments. I believe this is simpler for the code and not an issue for callers because they know what type of object they are dealing with. This has resulted in a shobj_description function analagous to obj_description and backend functions [Create/Delete]SharedComments mirroring the existing [Create/Delete]Comments functions. pg_shdescription.h goes into src/include/catalog/ Kris Jurka
-
- 11 2月, 2006 1 次提交
-
-
由 Bruce Momjian 提交于
minus inet. Stephen R. van den Berg
-
- 26 1月, 2006 1 次提交
-
-
由 Tom Lane 提交于
and rely exclusively on the SQL type system to tell the difference between the types. Prevent creation of invalid CIDR values via casting from INET or set_masklen() --- both of these operations now silently zero any bits to the right of the netmask. Remove duplicate CIDR comparison operators, letting the type rely on the INET operators instead.
-
- 12 1月, 2006 1 次提交
-
-
由 Tom Lane 提交于
Replace the former ad-hoc implementation used in the regression tests. Joachim Wieland
-
- 28 12月, 2005 1 次提交
-
-
由 Tom Lane 提交于
(previously we only did = and <> correctly). Also, allow row comparisons with any operators that are in btree opclasses, not only those with these specific names. This gets rid of a whole lot of indefensible assumptions about the behavior of particular operators based on their names ... though it's still true that IN and NOT IN expand to "= ANY". The patch adds a RowCompareExpr expression node type, and makes some changes in the representation of ANY/ALL/ROWCOMPARE SubLinks so that they can share code with RowCompareExpr. I have not yet done anything about making RowCompareExpr an indexable operator, but will look at that soon. initdb forced due to changes in stored rules.
-
- 22 12月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
Backpatch to 8.1.X.
-
由 Bruce Momjian 提交于
Fix example for day and hours interval subtraction for new computation method. Update interval examples to display zero seconds, which is our default. Backpatch to 8.1.X.
-
- 11 12月, 2005 1 次提交
-
-
由 Neil Conway 提交于
Patch from Pavel Stehule, minor fixups by myself.
-
- 04 12月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
Map them to a single day, so '30 hours' is 'AM'. Have to_char(interval) and to_char(time) use "HH", "HH12" as 12-hour intervals, rather than bypass and print the full interval hours. This is neeeded because to_char(time) is mapped to interval in this function. Intervals should use "HH24", and document suggestion. Allow "D" format specifiers for interval/time.
-
- 29 11月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
and IFNULL. Backpatch to 8.1.X.
-
- 20 11月, 2005 1 次提交
-
-
由 Tom Lane 提交于
not only the array contents, before claiming two arrays are equal. Per recent discussion.
-
- 19 11月, 2005 1 次提交
-
-
由 Tom Lane 提交于
the array (for array_push) or higher-dimensional array (for array_cat) rather than decrementing it as before. This avoids generating lower bounds other than one for any array operation within the SQL spec. Per recent discussion. Interestingly, this seems to have been the original behavior, because while updating the docs I noticed that a large fraction of relevant examples were *wrong* for the old behavior and are now right. Is it worth correcting this in the back-branch docs?
-
- 18 11月, 2005 1 次提交
-
-
由 Tom Lane 提交于
functionality, but I still need to make another pass looking at places that incidentally use arrays (such as ACL manipulation) to make sure they are null-safe. Contrib needs work too. I have not changed the behaviors that are still under discussion about array comparison and what to do with lower bounds.
-