summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2001-05-17Change "indices" to "indexes", per OED.Peter Eisentraut
2001-05-17Add -U and -W options to pg_dump and friends to support non-interactivePeter Eisentraut
specification of username (like in psql). pg_dumpall now works with password authentication.
2001-05-17Add dynamic_library_path parameter and automatic appending of sharedPeter Eisentraut
library extension.
2001-05-17Add HISTORY items for 7.1.2.Bruce Momjian
2001-05-15redo record -> undo record, Tom Lane.Bruce Momjian
2001-05-14Remove unused tables pg_variable, pg_inheritproc, pg_ipl tables. InitdbBruce Momjian
forced.
2001-05-14Fix 'set path' for csh.Bruce Momjian
2001-05-12Add index. Only some parts of the manual set have index entries so far...Peter Eisentraut
2001-05-12Add command '\pset footer' to psql to turn off default "(x rows)" footer.Peter Eisentraut
2001-05-12PL/Python should build portably now, if you can get over the fact thatPeter Eisentraut
there's no shared libpython. Test suite works as well. Also, add some documentation.
2001-05-11Improve discussion of %TYPE and %ROWTYPE.Tom Lane
2001-05-11Stamp CVS as 7.2. Update all interface version numbers. This is theBruce Momjian
time to do it, not during beta because people are using this stuff in production sometimes.
2001-05-11Stamp for 7.1.2. Ready when you are...Bruce Momjian
2001-05-11Update FAQ.Bruce Momjian
2001-05-09First cut at making indexscan cost estimates depend on correlationTom Lane
between index order and table order.
2001-05-09Add --echo option to createlang and droplang.Peter Eisentraut
from Oliver Elphick
2001-05-09Change --with-pltcl-unknown to --enable-pltcl-unknownBruce Momjian
2001-05-09This patch adds a new configure option --with-pltcl-unknown whichBruce Momjian
enables pltcl unknown support. Also it adds substituting of tclsh with tclsh that was by configure in pltcl_*mod scripts. For example, On freebsd, tclsh can be called tclsh8.2 or tclsh8.3 depending on installed version of Tcl. After patching files src/pl/tcl/modules/pltcl_listmod src/pl/tcl/modules/pltcl_loadmod src/pl/tcl/modules/pltcl_delmod must be renamed(copied,repocopied) to src/pl/tcl/modules/pltcl_listmod.in src/pl/tcl/modules/pltcl_loadmod.in src/pl/tcl/modules/pltcl_delmod.in seva@sevasoft.kiev.ua
2001-05-09Fix libpq++'s FieldSize to return int, not short.Bruce Momjian
2001-05-09Here's a version of my suggested diffs transplanted to 7.1 beta 5. I'mBruce Momjian
still looking at the best way to integrate Tom Vijlbrief's fixes (insofar as they're still needed); would 7.2 be a suitable time for incompatible API changes? Jeroen Changes: (*) Introduced bool, true, false (replacing some int, 1, 0) (*) Made some member functions const (*) Documented GetIsNull() (*) Marked DisplayTuples() and PrintTuples() as obsolescent; fixed possible portability problem (assumed that NULL pointer equals all-zero bit pattern) (*) PrintTuples(): renamed width parameter to fillAlign to conform with other usage; fixed memory leak and compile issue w.r.t. field separator (should also slightly improve performance) (*) Fixed some minor compilation issues (*) Moved "using namespace std;" out of headers, where they didn't belong; used new (temporary) preprocessor macro PGSTD to do this (*) Made ToString() static, removed unneeded memset(), made buffer size adapt to sizeof(int) (*) Made some constructors explicit (*) Changed some const std::string & parameters to plain std::string (*) Marked PgCursor::Cursor(std::string) as obsolescent (setter with same name as getter--bad style) (*) Renamed some paramaters previously named "string" (*) Introduced size_type typedef for number of tuples in result set (*) PgTransaction now supports re-opening after closing, and aborts if not explicitly committed prior to destruction J. T. Vermeulen
2001-05-09If it's true that the ALTER TABLE x ADD CONSTRAINT x CHECK (x) syntax isBruce Momjian
supported in 7.1.1, here is a patch to that alter_table.sgml that documents it. Christopher Kings-Lynne
2001-05-09Cause planner to make use of average-column-width statistic that is nowTom Lane
collected by ANALYZE. Also, add some modest amount of intelligence to guesses that are used for varlena columns in the absence of any ANALYZE statistics. The 'width' reported by EXPLAIN is finally something less than totally bogus for varlena columns ... and, in consequence, hashjoin estimating should be a little better ...
2001-05-08Update runtime shared memory computations.Bruce Momjian
2001-05-08Add SET SESSION AUTHORIZATION command.Peter Eisentraut
2001-05-08Remove pgadmin.sgml file.Bruce Momjian
2001-05-08Remove LISP manual reference. Added to web "interfaces" page.Bruce Momjian
2001-05-08drop_function.sgml:Bruce Momjian
=================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. In Compatibility SQL/PSM: SQL/PSM is a proposed standard. We had that before: remove proposed. drop_index.sgml: ================ <REFNAME>: Removes existing indexes from a database as far as I can see index should be singular. The command description is written as if only one index can be removed at a time. Interestingly enough, in v7.0.2 it was in fact singular. Am I mistaken here? drop_operator.sgml: =================== In Outputs the arguments are referred to as type and type2, but the synopsis and Inputs section these are left_type and right_type, respectively. Also, oper is used in Outputs versus id in Inputs/Synopsis. In the translation I follow the replaceables used in the Inputs/Synopsis part. Frank Wegmann
2001-05-08drop_function.sgml:Bruce Momjian
=================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. Frank Wegmann
2001-05-08Further cleanup of RAISE discussion; in particular, remove exampleTom Lane
that doesn't actually work.
2001-05-08Fix raise mention that %% output as %.Bruce Momjian
2001-05-08Update RAISE manual concerning % format symbols.Bruce Momjian
2001-05-08Update RAISE mention in manual to take string/variable not format/identifier.Bruce Momjian
2001-05-07Add mention of functional indexes for case-insensitive comparisons.Bruce Momjian
2001-05-07Add \cd command to psql.Peter Eisentraut
2001-05-07Solaris startup cleanup from Justin CliftBruce Momjian
2001-05-07Rewrite of planner statistics-gathering code. ANALYZE is now available asTom Lane
a separate statement (though it can still be invoked as part of VACUUM, too). pg_statistic redesigned to be more flexible about what statistics are stored. ANALYZE now collects a list of several of the most common values, not just one, plus a histogram (not just the min and max values). Random sampling is used to make the process reasonably fast even on very large tables. The number of values and histogram bins collected is now user-settable via an ALTER TABLE command. There is more still to do; the new stats are not being used everywhere they could be in the planner. But the remaining changes for this project should be localized, and the behavior is already better than before. A not-very-related change is that sorting now makes use of btree comparison routines if it can find one, rather than invoking '<' twice.
2001-05-06Allow 'psql -f -' to read from standard input.Peter Eisentraut
2001-05-06Make prompt customization work with changeable Unix socket location.Peter Eisentraut
2001-05-05UPdate for release tomorrow.Bruce Momjian
2001-05-04COMMIT_DELAY and COMMIT_SIBLINGS were missing from the list of WALTom Lane
configuration parameters in chapter 3.
2001-05-04Add missing tag.Bruce Momjian
2001-05-03BTW it does not add encodign it just patches existing one (KOI8) toBruce Momjian
support two - KOI8-R and KOI8-U (latter is superset of the former if not to take to the account pseudographics) Andy Rysin
2001-05-03pg_dump can dump 7.0 databases.Bruce Momjian
2001-05-03Describe handling of multiply-inherited fields correctly.Tom Lane
2001-05-03Update shared memory docs.Bruce Momjian
2001-05-03Final stamp for 7.1.1. All done.Bruce Momjian
2001-05-03Some updates for 7.1.1.Bruce Momjian
2001-05-02In the outputs section the NOTICE reads:Bruce Momjian
aggregate 'agg' for 'type' does not exist. Mismatch with synopsis, agg must be name here. Frank Wegmann
2001-05-02Added mention of SHMALL and removed BSD/OS-specific table.Bruce Momjian
2001-05-02description of the command line option echo should read:Bruce Momjian
Echo the queries that createuser generates and sends to the backend. ^^^^^^^^^^ Frank Wegmann