summaryrefslogtreecommitdiff
path: root/doc
AgeCommit message (Collapse)Author
2002-03-11Fix markupPeter Eisentraut
2002-03-11Uppercase class selectors, to work with browsers that follow the standards.Peter Eisentraut
2002-03-10Update and remove items:Bruce Momjian
< * Remove brackets as multi-statement rule grouping, must use parens (Bruce) > * -Remove brackets as multi-statement rule grouping, must use parens (Bruce) 458d457 < * Remove USING clause from pg_get_indexdef() if index is btree (Bruce)
2002-03-10Disable brackets in multi-statement rules, as discussed.Bruce Momjian
2002-03-09Wording improvements to runtime.sgml. Add mention in postgresql.confBruce Momjian
file that SIGHUP or "pg_ctl reload" are required for changes to take affect on a running server.
2002-03-08Remove async TODO.detail file.Bruce Momjian
2002-03-08Update TODO items that are completed.Bruce Momjian
2002-03-08TODO item done:Bruce Momjian
* Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)
2002-03-08Mark as done:Bruce Momjian
> * -Change DEBUG startup tag to LOG (Bruce)
2002-03-08AddBruce Momjian
> * Prevent aggregates from being used in rule WHERE clauses
2002-03-07Back out domain patch until it works properly.Bruce Momjian
2002-03-06alter table doc cleanups.Bruce Momjian
Neil Conway
2002-03-06Ok. Updated patch attached.Bruce Momjian
- domain.patch -> source patch against pgsql in cvs - drop_domain.sgml and create_domain.sgml -> New doc/src/sgml/ref docs - dominfo.txt -> basic domain related queries I used for testing [ ADDED TO /doc] Enables domains of array elements -> CREATE DOMAIN dom int4[3][2]; Uses a typbasetype column to describe the origin of the domain. Copies data to attnotnull rather than processing in execMain(). Some documentation differences from earlier. If this is approved, I'll start working on pg_dump, and a \dD <domain> option in psql, and regression tests. I don't really feel like doing those until the system table structure settles for pg_type. CHECKS when added, will also be copied to to the table attributes. FK Constraints (if I ever figure out how) will be done similarly. Both will lbe handled by MergeDomainAttributes() which is called shortly before MergeAttributes(). Rod Taylor
2002-03-06Update docs for new stored procedure error levels.Bruce Momjian
2002-03-06Update reference pages for new INFO, NOTICE, WARNING elog() levels.Bruce Momjian
2002-03-06Update docs for new INFO, NOTICE, WARNING elog() levels.Bruce Momjian
2002-03-06Add name:Bruce Momjian
> * Improve concurrency of hash indexes (Neil Conway)
2002-03-05Update FAQ.Bruce Momjian
2002-03-05This version has been synchonized with English version at Mar 03.Bruce Momjian
With best wishes,Victor Vislobokov Perm, Russia
2002-03-05This trivial patch fixes a typo and improves the phrasing of a sentenceBruce Momjian
in the docs. Neil Conway
2002-03-05> Tatsuo Ishii wrote:Bruce Momjian
> > > > It was made to cope with encoding such as an Asian bloc in 7.2Beta2. > > > > > > > > Added ServerEncoding > > > > Korean (JOHAB), Thai (WIN874), > > > > Vietnamese (TCVN), Arabic (WIN1256) > > > > > > > > Added ClientEncoding > > > > Simplified Chinese (GBK), Korean (UHC) > > > > > > > > > > > > > http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2b2.newencoding.diff.tar.gz > > > > (608K) > > > > > > Looks good. I need some people to review this for me. > > > > For me they look good too. The only missing part is a > > documentation. I will ask him to write it up. If he couldn't, I will > > do it for him. > > > The diff is 3mb > > > but appears to address only additions to multibyte. I have attached a > > > list of files it modifies. Also, look at the sizes of the mb/ > > > directory. It is getting large: > > > > > > 4 ./CVS > > > 6 ./Unicode/CVS > > > 3433 ./Unicode > > > 6197 . > > > > Yes. We definitely need the on-the-fly encoding addition capability: > > i.e. CREATE CHRACTER SET in the future... > > -- > > Tatsuo Ishii > > > > Address chainge. http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2.newencoding.diff.gz Add PsqlODBC and document ...etc patch. Eiji Tokuya
2002-03-05I attach a version of my toast-slicing patch, against current CVSBruce Momjian
(current as of a few hours ago.) This patch: 1. Adds PG_GETARG_xxx_P_SLICE() macros and associated support routines. 2. Adds routines in src/backend/access/tuptoaster.c for fetching only necessary chunks of a toasted value. (Modelled on latest changes to assume chunks are returned in order). 3. Amends text_substr and bytea_substr to use new methods. It now handles multibyte cases -and should still lead to a performance improvement in the multibyte case where the substring is near the beginning of the string. 4. Added new command: ALTER TABLE tabname ALTER COLUMN colname SET STORAGE {PLAIN | EXTERNAL | EXTENDED | MAIN} to parser and documented in alter-table.sgml. (NB I used ColId as the item type for the storage mode string, rather than a new production - I hope this makes sense!). All this does is sets attstorage for the specified column. 4. AlterTableAlterColumnStatistics is now AlterTableAlterColumnFlags and handles both statistics and storage (it uses the subtype code to distinguish). The previous version of my patch also re-arranged other code in backend/commands/command.c but I have dropped that from this patch.(I plan to return to it separately). 5. Documented new macros (and also the PG_GETARG_xxx_P_COPY macros) in xfunc.sgml. ref/alter_table.sgml also contains documentation for ALTER COLUMN SET STORAGE. John Gray
2002-03-05Add:Bruce Momjian
> o allow replication over unreliable or non-persistent links
2002-03-05Add \timing patch to psql. Times all queries.Bruce Momjian
Greg Sabino Mullane
2002-03-04Add PQunescapeBytea libpq function.Bruce Momjian
Everyone using libpq and bytea is probably having to invent this wheel.. Patrick Welche
2002-03-04Improve libpgeasy API for multiple result sets, add example.Bruce Momjian
2002-03-04Update FAQ_Solaris with info about gcc 2.95.1 problems and how to workTom Lane
around 64-bit vsnprintf bug.
2002-03-04Modify:Bruce Momjian
< * Add GUC parameter for eurodates > * Add GUC parameter for DATESTYLE
2002-03-04Add:Bruce Momjian
> * Add GUC parameter for eurodates
2002-03-03Update FAQ.Bruce Momjian
2002-03-03Update FAQ.Bruce Momjian
2002-03-02Commit to match discussed elog() changes. Only update is that LOG isBruce Momjian
now just below FATAL in server_min_messages. Added more text to highlight ordering difference between it and client_min_messages. --------------------------------------------------------------------------- REALLYFATAL => PANIC STOP => PANIC New INFO level the prints to client by default New LOG level the prints to server log by default Cause VACUUM information to print only to the client NOTICE => INFO where purely information messages are sent DEBUG => LOG for purely server status messages DEBUG removed, kept as backward compatible DEBUG5, DEBUG4, DEBUG3, DEBUG2, DEBUG1 added DebugLvl removed in favor of new DEBUG[1-5] symbols New server_min_messages GUC parameter with values: DEBUG[5-1], INFO, NOTICE, ERROR, LOG, FATAL, PANIC New client_min_messages GUC parameter with values: DEBUG[5-1], LOG, INFO, NOTICE, ERROR, FATAL, PANIC Server startup now logged with LOG instead of DEBUG Remove debug_level GUC parameter elog() numbers now start at 10 Add test to print error message if older elog() values are passed to elog() Bootstrap mode now has a -d that requires an argument, like postmaster
2002-03-01User and database-specific session defaults for run-time configurationPeter Eisentraut
variables. New commands ALTER DATABASE ... SET and ALTER USER ... SET.
2002-03-01Revert quotes, 7.2 doesn't need them for CREATE FUNCTION.Bruce Momjian
2002-03-01Oops, we didn't have single quotes around 'langname' in CREATE FUNCTIONBruce Momjian
manual page; pointed out by IRC user.
2002-02-27Some cleanups in CREATE/ALTER/DROP USER ref pages.Peter Eisentraut
2002-02-27Update FAQ.Bruce Momjian
2002-02-26Correct typo noticed by Christopher Kings-Lynne.Tom Lane
2002-02-25Added:Bruce Momjian
> * Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)
2002-02-25Update FAQ_DEV.Bruce Momjian
2002-02-25Update FAQ.Bruce Momjian
2002-02-25Add items and JDBC maintainers:Bruce Momjian
> o Add LISTEN/NOTIFY support to the JDBC driver (Barry) 479a481 > * Barry is Barry Lind <barry@xythos.com> 482a485 > * Dave is Dave Cramer <dave@fastcrypt.com>
2002-02-25Update completed items:Bruce Momjian
> * -Prevent SIGHUP and 'pg_ctl reload' from changing command line > * -Remove LIMIT #,# and force use LIMIT and OFFSET clauses in 7.3 (Bruce) > * -Prevent create/drop scripts from allowing extra args (Bruce) > * -Have pg_dump -C dump database location and encoding information
2002-02-25*** empty log message ***Bruce Momjian
2002-02-25Re-add equals documentation with CREATE DATABASE.Bruce Momjian
2002-02-25Remove documentation of equals in CREATE DATABASE. Mention removal ofBruce Momjian
equals hack for the future.
2002-02-24Fix copy-and-paste typo.Tom Lane
2002-02-24Add -O/--owner switch to createdb script, in support of new OWNER optionTom Lane
for CREATE DATABASE.
2002-02-24Add OWNER option to CREATE DATABASE, so superusers can create databasesTom Lane
on behalf of unprivileged users. Also, make '=' optional in CREATE DATABASE syntax. From Gavin Sherry, with kibitzing and docs by Tom Lane.
2002-02-23Added:Bruce Momjian
> * Add checks for missing parameters to shell script, to prevent > over-shifting
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-30 00:28:05 +0000