summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2002-04-14Allow detection of collateindex.pl in stylesheet directory or in path,Peter Eisentraut
which covers some recent installation schemes. Add Mandrake installation layout to directories to check for stylesheets. Allow documentation build to proceed if stylesheets were not found, in case the stylesheets might be found through the SGML catalog mechanism.
2002-04-14Fix broken SGML tag.Tatsuo Ishii
2002-04-13Update/correct inheritance examples.Tom Lane
2002-04-13This is a proposed patch to doc/src/sgml/libpgtcl.sgml which documentsBruce Momjian
the libpgtcl "pg_execute" command. This was mentioned on pgsql-interfaces on Mar 3. I am posting it here in the hope that someone will check to see if it makes sense and is correct SGML-wise. I did run it through jade, but this is my first try at this sort of thing. ljb
2002-04-13Mention precision of NUMERIC in docs.Bruce Momjian
2002-04-12Update new Russian FAQ.Bruce Momjian
2002-04-11Add mention of function CREATE INDEX usage.Bruce Momjian
2002-04-11Restructure representation of aggregate functions so that they have pg_procTom Lane
entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could.
2002-04-10Readline and Zlib now required by default. Add options --without-readlinePeter Eisentraut
and --without-zlib to turn them off.
2002-04-10Add make install-strip target.Peter Eisentraut
2002-04-09Point to developers site, not my hostname.Bruce Momjian
2002-04-09Update FAQ.Bruce Momjian
2002-04-09Update FAQ.Bruce Momjian
2002-04-09More cleanups of cursor text.Bruce Momjian
2002-04-09Fix markup problem with recent change.Bruce Momjian
2002-04-09Update refcursor documentation with examples of how to return pl/pgsqlBruce Momjian
refcursors.
2002-04-09Fix SGML markup problem.Bruce Momjian
2002-04-08DST-transition-sensitive tests seem to be in horology now, notTom Lane
timestamp.
2002-04-06Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2002-04-05Divide functions into three volatility classes (immutable, stable, andTom Lane
volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
2002-04-04Authentication improvements:Bruce Momjian
A new pg_hba.conf column, USER Allow specifiction of lists of users separated by commas Allow group names specified by + Allow include files containing lists of users specified by @ Allow lists of databases, and database files Allow samegroup in database column to match group name matching dbname Removal of secondary password files Remove pg_passwd utility Lots of code cleanup in user.c and hba.c New data/global/pg_pwd format New data/global/pg_group file
2002-04-03Locale support is on by default. The choice of locale is done in initdbPeter Eisentraut
and/or with GUC variables.
2002-04-01Add tgconstrrelid to stored Trigger structures, make RI trigger functionsTom Lane
depend on this rather than the trigger argument strings to locate the other relation to test. This makes RI triggers function properly in the presence of schemas and temp tables. Along the way, fix bogus lack of locking in RI triggers, handle quoting of names fully correctly, compute required sizes of query buffers with some semblance of accuracy.
2002-04-01ALTER TABLE SET/DROP NOT NULL, from Christopher Kings-Lynne.Tom Lane
2002-04-01Create a new GUC variable search_path to control the namespace searchTom Lane
path. The default behavior if no per-user schemas are created is that all users share a 'public' namespace, thus providing behavior backwards compatible with 7.2 and earlier releases. Probably the semantics and default setting will need to be fine-tuned, but this is a start.
2002-03-29pg_type has a typnamespace column; system now supports creating typesTom Lane
in different namespaces. Also, cleanup work on relation namespace support: drop, alter, rename commands work for tables in non-default namespaces.
2002-03-27Don't mark up as acronym that which is not an acronym.Peter Eisentraut
2002-03-27Improve spelling of lock names, and some other editing.Peter Eisentraut
2002-03-26pg_class has a relnamespace column. You can create and access tablesTom Lane
in schemas other than the system namespace; however, there's no search path yet, and not all operations work yet on tables outside the system namespace.
2002-03-25New wording:Bruce Momjian
Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
2002-03-25Add to HISTORY:Bruce Momjian
Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)
2002-03-24Tweak labeling of plan qual conditions for more consistency.Tom Lane
2002-03-24Fix cut-and-paste-o.Tom Lane
2002-03-24EXPLAIN output now comes out as a query result, not a NOTICE message.Tom Lane
Also, fix debug logging of parse/plan trees so that the messages actually go through elog(), not directly to stdout.
2002-03-22Create the pg_namespace system catalog. Doesn't do much yet, but it'sTom Lane
there and CREATE SCHEMA will make entries in it...
2002-03-22Spell checking and markup additionsPeter Eisentraut
2002-03-21First phase of SCHEMA changes, concentrating on fixing the grammar andTom Lane
the parsetree representation. As yet we don't *do* anything with schema names, just drop 'em on the floor; but you can enter schema-compatible command syntax, and there's even a primitive CREATE SCHEMA command. No doc updates yet, except to note that you can now extract a field from a function-returning-row's result with (foo(...)).fieldname.
2002-03-20Code review for DOMAIN patch.Tom Lane
2002-03-19Put back development status section overwritten by Bruce.Tom Lane
2002-03-19> > Users of contrib/tsearch needs after upgrading of module (compiling, ↵Bruce Momjian
installing) > > to perform sql command: > > update pg_amop set amopreqcheck = true where amopclaid = > > (select oid from pg_opclass where opcname = 'gist_txtidx_ops'); > > Oleg, sorry, I don't understand where this should appear. In the README > file, and if so, where? Is this something only for people upgrading > from 7.2? Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch Also, It'd be worth to mention in Changes to point users of tsearch about importang upgrade notices. Oleg Bartunov
2002-03-19Add psql \dD listing of domains, from Jonathan Eisler.Bruce Momjian
2002-03-19Add DOMAIN support. Includes manual pages and regression tests, fromBruce Momjian
Rod Taylor.
2002-03-19Improve wording of bug fix:Bruce Momjian
Ensure that sequence counters do not go backwards after a crash
2002-03-18Update for 7.2.1.Bruce Momjian
2002-03-18Update FAQ.Bruce Momjian
2002-03-17Improve documentation about array I/O representation.Tom Lane
2002-03-15Back out EXCEPT/DIFFERENCE patch. Seems I forgot the details of this.Bruce Momjian
2002-03-15Fix for docs from Patrick Welche:Bruce Momjian
! DIFFERENCE (&minus; or &setmn;): builds the set difference of two tables. Let <classname>R</classname> and <classname>S</classname> again be two tables with the same arity. <classname>R</classname> - <classname>S</classname> --- 488,494 ---- <listitem> <para> ! EXCEPT (&minus; or &setmn;): builds the set difference of
2002-03-11Mention time() and interval() are also changed in 7.2.Bruce Momjian
2002-03-11Fix markupPeter Eisentraut
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-25 16:08:40 +0000