- 29 7月, 2005 4 次提交
-
-
由 Bruce Momjian 提交于
Euler Taveira de Oliveira
-
由 Bruce Momjian 提交于
pg_tablespace_size pg_database_size pg_relation_size pg_complete_relation_size pg_size_pretty Remove /contrib/dbsize. Dave Page
-
由 Bruce Momjian 提交于
new commands which may make an SPI call fail. Alvaro Herrera
-
由 Bruce Momjian 提交于
< * Consider use of open/fcntl(O_DIRECT) to minimize OS caching, < especially for WAL writes > * -Consider use of open/fcntl(O_DIRECT) to minimize OS caching, > for WAL writes
-
- 27 7月, 2005 3 次提交
-
-
由 Neil Conway 提交于
-
由 Tom Lane 提交于
be rewritten, but at least the reference pages are reasonably sane.
-
由 Tom Lane 提交于
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.
-
- 26 7月, 2005 2 次提交
-
-
由 Tom Lane 提交于
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.
-
由 Tom Lane 提交于
I'm still working on the has_role function and information_schema changes.
-
- 25 7月, 2005 2 次提交
-
-
由 Bruce Momjian 提交于
> 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 提交于
fails near DST transition days, so remove the advice about that testing problem. Also improve the description of variant-comparison-file selection.
-
- 24 7月, 2005 1 次提交
-
-
由 Tom Lane 提交于
scans are candidates for exclusion; this should be fixed eventually. Simon Riggs, with some help from Tom Lane.
-
- 23 7月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
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.
-
- 21 7月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
< > * Research storing disk pages with no alignment/padding
-
由 Tom Lane 提交于
-
由 Bruce Momjian 提交于
24 hours. This is very helpful for daylight savings time: select '2005-05-03 00:00:00 EST'::timestamp with time zone + '24 hours'; ?column? ---------------------- 2005-05-04 01:00:00-04 select '2005-05-03 00:00:00 EST'::timestamp with time zone + '1 day'; ?column? ---------------------- 2005-05-04 01:00:00-04 Michael Glaesemann
-
- 19 7月, 2005 3 次提交
-
-
由 Neil Conway 提交于
an <xref/>.
-
由 Tom Lane 提交于
for circle(polygon), which was missing; remove bogus entry for point(lseg, lseg), which does not exist, and the documentation seemed to describe lseg_interpt, which we already document as an operator not a function. Also remove entry for box_intersect, which likewise is preferentially used via the operator #.
-
由 Bruce Momjian 提交于
-
- 16 7月, 2005 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 14 7月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Neil Conway 提交于
is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Patch from Simon Riggs.
-
由 Tom Lane 提交于
few loose ends to be dealt with, but it seems to work. Alvaro Herrera, based on the contrib code by Matthew O'Connor.
-
- 13 7月, 2005 1 次提交
-
-
由 Neil Conway 提交于
various editorialization from Neil Conway.
-
- 11 7月, 2005 1 次提交
-
-
由 Tom Lane 提交于
optional arguments as text input functions, ie, typioparam OID and atttypmod. Make all the datatypes that use typmod enforce it the same way in typreceive as they do in typinput. This fixes a problem with failure to enforce length restrictions during COPY FROM BINARY.
-
- 10 7月, 2005 4 次提交
-
-
由 Bruce Momjian 提交于
The Problem: Occassionally a DBA needs to dump a database to a new encoding. In instances where the current encoding, (or lack of an encoding, like SQL_ASCII) is poorly supported on the target database server, it can be useful to dump into a particular encoding. But, currently the only way to set the encoding of a pg_dump file is to change client_encoding in postgresql.conf and restart postmaster. This is more than a little awkward for production systems. Magnus Hagander
-
由 Bruce Momjian 提交于
< computations should adjust based on the time zone rules, e.g. < adding 24 hours to a timestamp would yield a different result from < adding one day. < > computations should adjust based on the time zone rules.
-
由 Bruce Momjian 提交于
The specification of this function is as follows. regexp_replace(source text, pattern text, replacement text, [flags text]) returns text Replace string that matches to regular expression in source text to replacement text. - pattern is regular expression pattern. - replacement is replace string that can use '\1'-'\9', and '\&'. '\1'-'\9': back reference to the n'th subexpression. '\&' : entire matched string. - flags can use the following values: g: global (replace all) i: ignore case When the flags is not specified, case sensitive, replace the first instance only. Atsushi Ogawa
-
由 Bruce Momjian 提交于
100.000,0. Eugen Nedelcu
-
- 08 7月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
> * -Prevent dropping user that still owns objects, or auto-drop the objects
-
由 Tom Lane 提交于
have adequate mechanisms for tracking the contents of databases and tablespaces). This solves the longstanding problem that you can drop a user who still owns objects and/or has access permissions. Alvaro Herrera, with some kibitzing from Tom Lane.
-
由 Bruce Momjian 提交于
< writer. > writer. It might cause problems for applying WAL on recovery > into a partially-written page, but later the full page will be > replaced from WAL.
-
- 07 7月, 2005 3 次提交
-
-
由 Bruce Momjian 提交于
> > o -Add ability to turn off full page writes > o When off, write CRC to WAL and check file system blocks > on recovery > o Write full pages during file system write and not when > the page is modified in the buffer cache > > This allows most full page writes to happen in the background > writer.
-
由 Bruce Momjian 提交于
problems: --------------------------------------------------------------------------- Support cross compilation by compiling "zic" with a native compiler. This relies on the output of zic being platform independent, but that is currently the case.
-
由 Bruce Momjian 提交于
possible compression. Mark Kirkwood
-
- 06 7月, 2005 5 次提交
-
-
由 Bruce Momjian 提交于
Michael Paesold
-
由 Bruce Momjian 提交于
> * -Add function to return compressed length of TOAST data values
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Turn off full page writes if fsync is disabled < < If fsync is off, there is no purpose in writing full pages to WAL <
-
由 Bruce Momjian 提交于
< 881a881,882 > o Improve xid wraparound detection by recording per-table rather > than per-database
-