summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2001-10-10Remove gratuitous discrepancy between extract() and date_part(),Peter Eisentraut
regarding timezone_hour, timezone_minute vs. tz_hour, tz_minute. Document the former.
2001-10-09Allow optional () after current_user, session_user, user, current_time,Peter Eisentraut
current_timestamp, current_date for ODBC compatibility. Add more functions to odbc.sql catalog extension, use new CREATE OR REPLACE FUNCTION. Document iODBC/unixODBC build options.
2001-10-09Bunch of copy fitting and style sheet tweakage to get decent looking printPeter Eisentraut
output (from pdfjadetex). Also updated instructions to install documentation processing toolchain.
2001-10-09Correct some errors in plpgsql examples, as reported by Junichi Kobayasi.Tom Lane
2001-10-09Change plpgsql to depend on main parser's type-declaration grammar,Tom Lane
rather than having its own somewhat half-baked notion of what a type declaration looks like. This is necessary now to ensure that plpgsql will think a 'timestamp' variable has the same semantics as 'timestamp' does in the main SQL grammar; and it should avoid divergences in future.
2001-10-05ouput -> outputBruce Momjian
Oliver Elphick
2001-10-04Finetuning for legalnotice in print output. Add some "ASCII markup" forPeter Eisentraut
text output.
2001-10-04Finetuning for better print formattingPeter Eisentraut
2001-10-04Replace simplelists with itemizedlists for better formattingPeter Eisentraut
2001-10-04RewordingPeter Eisentraut
2001-10-04Fix spacing to get proper URL formatting in print outputPeter Eisentraut
2001-10-04Hack for Jade vs TeX interpretation of "--"Peter Eisentraut
2001-10-04Consider interpreting a function call as a trivial (binary-compatible)Tom Lane
type coercion after failing to find an exact match in pg_proc, but before considering interpretations that involve a function call with one or more argument type coercions. This avoids surprises wherein what looks like a type coercion is interpreted as coercing to some third type and then to the destination type, as in Dave Blasby's bug report of 3-Oct-01. See subsequent discussion in pghackers.
2001-10-04Change some 7.2 mentions to version macro.Bruce Momjian
2001-10-03DROP AGGREGATE and COMMENT ON AGGREGATE now accept the expected syntaxTom Lane
'aggname (aggtype)'. The old syntax 'aggname aggtype' is still accepted for backwards compatibility. Fix pg_dump, which was actually broken for most cases of user-defined aggregates. Clean up error messages associated with these commands.
2001-10-03Minor fixup in spacing for tabular information.Thomas G. Lockhart
2001-10-02Add CREATE OR REPLACE FUNCTION syntax to allow replacing a functionTom Lane
definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry.
2001-10-01Fix typo (block size is 8 kB not 8192 kB).Tom Lane
2001-10-01Fix wording.Bruce Momjian
2001-10-01Update docs for 7.2 mention where appropriate.Bruce Momjian
2001-10-01> > > > > - PostgreSQL requires to be compiled with --enable-multibyteBruce Momjian
> > > > > and --enable-unicode-convertion if it ought to work correctly > > > > > with Tcl/Tk >= 8.1 (client or server side). > > > > > > > > > > - PL/Tcl needs to be changed to use pg_do_encoding_conversion > > > > > if it runs on a Tcl version >= 8.1 . > > > > > > > I'll do pl/tcl part in the next version of patch. Using this approach we > > > > can eliminate overhead for databases in UNICODE. > > > > > > Any progress on this? I'd prefer to get rid of this --enable-pltcl-utf > > > option before release. > > > > Done > > > > Next version removes --enable-pltcl-utf switch and enables embedded > > utf conversion of pgsql if tcl version >=8.1 and --enable-unicode-conversion
2001-09-30Allow the postmaster to accept changes in PGC_BACKEND GUC variablesTom Lane
from the config file, so that these changes will propagate to backends started later. Already-started backends continue to ignore changes in these variables.
2001-09-30Change tar -T file to tar `cat file` for BSD tar.Bruce Momjian
2001-09-30Change tar -c -f to -cf for BSD tar.Bruce Momjian
2001-09-30Create a GUC parameter max_files_per_process that is a configurableTom Lane
upper limit on what we will believe from sysconf(_SC_OPEN_MAX). The default value is 1000, so that under ordinary conditions it won't affect the behavior. But on platforms where the kernel promises far more than it can deliver, this can be used to prevent running out of file descriptors. See numerous past discussions, eg, pgsql-hackers around 23-Dec-2000.
2001-09-30Use <mediaobject> instead of <graphic> for forward compatibility. Be morePeter Eisentraut
flexible about the extension of the graphic files, allow for other formats in print output. (Generating these formats is not implemented yet.)
2001-09-30Fix *.gif expansion to be empty when no gif files are used.Peter Eisentraut
2001-09-29Implement new 'lightweight lock manager' that's intermediate betweenTom Lane
existing lock manager and spinlocks: it understands exclusive vs shared lock but has few other fancy features. Replace most uses of spinlocks with lightweight locks. All remaining uses of spinlocks have very short lock hold times (a few dozen instructions), so tweak spinlock backoff code to work efficiently given this assumption. All per my proposal on pghackers 26-Sep-01.
2001-09-28Fix markup to allow compilation. The chapters on failure and recoveryThomas G. Lockhart
need more work, but at least they have something now.
2001-09-28Add information on new timestamp and timestamptz data types.Thomas G. Lockhart
Start chapter on recovery techniques. Still needs work for release.
2001-09-27Remove useless LockDisable() function and associated overhead, per myTom Lane
proposal of 26-Aug.
2001-09-23Rename collect_* options to more user-friendly names.Peter Eisentraut
2001-09-23One more LIMIT doc update.Bruce Momjian
2001-09-23Add mention of log file rotation with mention of syslog SIGHUP capability.Bruce Momjian
2001-09-23Implement TODO item:Bruce Momjian
* Change LIMIT val,val to offset,limit to match MySQL Documentation updates too.
2001-09-23Update anoncvs info, per Marc.Bruce Momjian
2001-09-23Update FAQ.Bruce Momjian
2001-09-22Fix 6.4.* release dates, pointed out by Tom Lane.Bruce Momjian
2001-09-22WAL file numbers: Sequenatial -> ever-increasingBruce Momjian
2001-09-21Suggest running ldconfig after installation if available.Peter Eisentraut
2001-09-21For consistency with the rest of PostgreSQL, rename BLOBs to large objectsPeter Eisentraut
in messages and documentation.
2001-09-21Add 'reload' option to pg_ctl to send SIGHUP to the postmaster.Tom Lane
2001-09-21Code review for MD5 authorization patch. Clean up some breakageTom Lane
(salts were always zero!?), add much missing documentation.
2001-09-21Readd test/regress/README file, this time with a well-defined and simplePeter Eisentraut
rule to remake it when necessary.
2001-09-21Add an overall timeout on the client authentication cycle, so thatTom Lane
a hung client or lost connection can't indefinitely block a postmaster child (not to mention the possibility of deliberate DoS attacks). Timeout is controlled by new authentication_timeout GUC variable, which I set to 60 seconds by default ... does that seem reasonable?
2001-09-21Give VACUUM its own GUC parameter for memory usage, rather thanTom Lane
piggybacking on SortMem. Add documentation for some recently-added GUC parameters that had so far escaped it.
2001-09-20Document the sign() function.Peter Eisentraut
2001-09-20Provide tunable knob for x = NULL -> x IS NULL transformation, default to off.Peter Eisentraut
2001-09-18Generate index.html as the root file name of the documentation set,Peter Eisentraut
rather than making index.html a symlink to the autogenerated name. Fixes fatal problems with tar programs that don't handle symlinks very well (MacOS X). (The names user.html, admin.html, etc. are still available as make targets, but they aren't packaged anymore.) Use the manifest file that the stylesheets generate as the file list for packaging. Put graphics in the right place while building, not while packaging, so you can actually look at them after building.
2001-09-18EXPLAIN ANALYZE feature to measure and show actual runtimes and tupleTom Lane
counts alongside the planner's estimates. By Martijn van Oosterhout, with some further work by Tom Lane.