- 01 4月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
January --- would return wrong year for 2005-01-01 and 2006-01-01. per report from Robert Creager. Backpatch to 8.0.X.
-
- 30 3月, 2005 1 次提交
-
-
由 Neil Conway 提交于
-
- 26 3月, 2005 1 次提交
-
-
由 Tom Lane 提交于
Karel Zak
-
- 15 3月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
Roland Volkmann
-
- 07 3月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
UNICODE => UTF8 ALT => WIN866 WIN => WIN1251 TCVN => WIN1258 The old codes continue to work.
-
- 28 2月, 2005 1 次提交
-
-
由 Neil Conway 提交于
Iijima, reviewed by Neil Conway. Catalog version number bumped, regression tests updated.
-
- 11 2月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
SELECT CURRENT_TIMESTAMP; SELECT now(); SELECT TIMESTAMP 'now'; -- incorrect for use with DEFAULT
-
- 29 1月, 2005 1 次提交
-
-
由 Tom Lane 提交于
-
- 27 1月, 2005 1 次提交
-
-
由 Tom Lane 提交于
-
- 23 1月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 10 1月, 2005 1 次提交
-
-
由 Tom Lane 提交于
per discussion in Nov 2004 with Ken Tanzer.
-
- 08 1月, 2005 1 次提交
-
-
由 Tom Lane 提交于
7.4 interactive docs.
-
- 24 12月, 2004 1 次提交
-
-
由 Tom Lane 提交于
-
- 21 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday while TO_CHAR starts at 1==Sunday. A suggestion for two documentation notes is attached as a patch to current CVS HEAD. Troels Arvin
-
- 14 12月, 2004 1 次提交
-
-
由 Peter Eisentraut 提交于
-
- 04 12月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 03 12月, 2004 3 次提交
-
-
由 Bruce Momjian 提交于
David Fetter
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 02 12月, 2004 1 次提交
-
-
由 Tom Lane 提交于
-
- 28 11月, 2004 1 次提交
-
-
由 Peter Eisentraut 提交于
by Troels Arvin, Simon Riggs, Elein Mustain Make spelling of SQL standard names uniform.
-
- 15 11月, 2004 1 次提交
-
-
由 Neil Conway 提交于
output.
-
- 08 11月, 2004 1 次提交
-
-
由 Peter Eisentraut 提交于
-
- 27 10月, 2004 1 次提交
-
-
由 Tom Lane 提交于
index entries for IS-foo constructs.
-
- 04 10月, 2004 1 次提交
-
-
由 Neil Conway 提交于
-
- 28 9月, 2004 1 次提交
-
-
由 Neil Conway 提交于
-
- 18 8月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
Greg Sabino Mullan
-
- 10 8月, 2004 1 次提交
-
-
由 Tom Lane 提交于
time zone names we support.
-
- 05 8月, 2004 1 次提交
-
-
由 Tom Lane 提交于
and documentation to reference 8.0 instead of 7.5.
-
- 04 8月, 2004 1 次提交
-
-
由 Tom Lane 提交于
and history files as per recent discussion. While at it, remove pg_terminate_backend, since we have decided we do not have time during this release cycle to address the reliability concerns it creates. Split the 'Miscellaneous Functions' documentation section into 'System Information Functions' and 'System Administration Functions', which hopefully will draw the eyes of those looking for such things.
-
- 13 7月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
Christopher Kings-Lynne
-
- 03 7月, 2004 2 次提交
-
-
由 Tom Lane 提交于
better SQL compliance in this area, per recent discussion. Mark related operators as commutators where possible. (The system doesn't actually care about commutator marking for operators not returning boolean, at the moment, but this seems forward-thinking and besides it made it easier to verify that we hadn't missed any.) Also, remove interval-minus-time and interval-minus-timetz operators. I'm not sure how these got in, but they are nonstandard and had very obviously broken behavior. (minus is not commutative in anyone's book.) I doubt anyone had ever used 'em, because we'd surely have gotten a bug report about it if so.
-
由 Joe Conway 提交于
From an idea of Bruce, the attached patch implements the function pg_tablespace_databases(oid) RETURNS SETOF oid which delivers as set of database oids having objects in the selected tablespace, enabling an admin to examine only the databases affecting the tablespace for objects instead of scanning all of them. initdb forced
-
- 26 6月, 2004 1 次提交
-
-
由 Tom Lane 提交于
This eliminates the assumption that a serial column's sequence will have the same name on reload that it was given in the original database. Christopher Kings-Lynne
-
- 25 6月, 2004 1 次提交
-
-
由 Tom Lane 提交于
Magnus Hagander
-
- 16 6月, 2004 1 次提交
-
-
由 Tom Lane 提交于
eliminating the former hard-wired convention about their names. Allow pg_cast entries to represent both type coercion and length coercion in a single step --- this is represented by a function that takes an extra typmod argument, just like a length coercion function. This nicely merges the type and length coercion mechanisms into something at least a little cleaner than we had before. Make use of the single- coercion-step behavior to fix integer-to-bit coercion so that coercing to bit(n) yields the rightmost n bits of the integer instead of the leftmost n bits. This should fix recurrent complaints about the odd behavior of this coercion. Clean up the documentation of the bit string functions, and try to put it where people might actually find it. Also, get rid of the unreliable heuristics in ruleutils.c about whether to display nested coercion steps; instead require parse_coerce.c to label them properly in the first place.
-
- 15 6月, 2004 1 次提交
-
-
由 Tom Lane 提交于
-
- 14 6月, 2004 1 次提交
-
-
由 Tom Lane 提交于
log_hostname is enabled, clean up documentation.
-
- 03 6月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
Specifically, point out that intersecting points in a path will yield (most likely), unexpected results. Visually these are identical paths, but mathematically they're not the same. Ex: area | plan ------ +----------------------------------------------------------------------- ------------------- -0 | ((0,0),(0,1),(2,1),(2,2),(1,2),(1,0),(0,0)) 2 | ((0,0),(0,1),(1,1),(1,2),(2,2),(2,1),(1,1),(1,0),(0,0)) The current algorithm for area(PATH) is very quick, but only handles non-intersecting paths. I'm going to work on two other functions for the PATH data type that determines if a PATH is intersecting or not, and a function that returns the area() for an intersecting PATH. The intersecting area() function will be considerably slower (I think it's going to be O(n!) or worse instead of the current O(n), but that comes with the territory). Sean Chittenden
-
- 27 5月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
the four functions. > Also, please justify the temp-related changes. I was not aware that we > had any breakage there. patch-tmp-schema.txt contains the following bits: *) Changes pg_namespace_aclmask() so that the superuser is always able to create objects in the temp namespace. *) Changes pg_namespace_aclmask() so that if this is a temp namespace, objects are only allowed to be created in the temp namespace if the user has TEMP privs on the database. This encompasses all object creation, not just TEMP tables. *) InitTempTableNamespace() checks to see if the current user, not the session user, has access to create a temp namespace. The first two changes are necessary to support the third change. Now it's possible to revoke all temp table privs from non-super users and limiting all creation of temp tables/schemas via a function that's executed with elevated privs (security definer). Before this change, it was not possible to have a setuid function to create a temp table/schema if the session user had no TEMP privs. patch-area-path.txt contains: *) Can now determine the area of a closed path. patch-dfmgr.txt contains: *) Small tweak to add the library path that's being expanded. I was using $lib/foo.so and couldn't easily figure out what the error message, "invalid macro name in dynamic library path" meant without looking through the source code. With the path in there, at least I know where to start looking in my config file. Sean Chittenden
-