summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
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
2001-05-01Bump version to 7.1.1. Now run over to hub to rebuild documentationPeter Eisentraut
before release...
2001-05-01More markup fixesPeter Eisentraut
2001-05-01Fix slightly confused description of debug options.Tom Lane
2001-04-30Document pltcl's return_null command.Tom Lane
2001-04-30Repair freshly-broken markup.Tom Lane
2001-04-30Break up PQexec() result functions into subsections to be clearer. BothBruce Momjian
libpq and libpq++ reorganized.
2001-04-30Add mention of libpgtcl's options to manual, libpq++ markup fixes.Bruce Momjian
2001-04-28In create_function there is a remark concerning SQL/PSM notBruce Momjian
being ratified as yet. This is certainly no longer true, it wasn't even true in Q2/1998 when I did a little research for Date's book. SQL/PSM had been published on 1996-12-15 as ISO/IEC 9075:4. So you might want to update that section. Frank Wegmann
2001-04-27A small patch for a small option (for rel. 7.1).Bruce Momjian
Jimmy Olgeni
2001-04-27Update FAQ.Bruce Momjian
2001-04-27Update FAQ.Bruce Momjian
2001-04-27Update FAQ.Bruce Momjian
2001-04-20Final markup for 7.1 hardcopy release. Mostly typo and table-fittingThomas G. Lockhart
adjustments. Note that many tables are being abused with *really* long description columns. Should probably shrink those columns to be more concise, and move some of the info to follow-on reference notes.
2001-04-20Add option --refentry to change \keepn (keep with next paragraph) toThomas G. Lockhart
\keep (keep current paragraph together). This fixes most troubles with reference pages marked up with <refentry> tags. Use on reference.rtf, generated by "make reference.rtf".