summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2002-03-11Uppercase class selectors, to work with browsers that follow the standards.Peter Eisentraut
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-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-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 \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-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-25Update FAQ_DEV.Bruce Momjian
2002-02-25Update FAQ.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-23Update FAQ_DEV.Bruce Momjian
2002-02-23Heimdal support (Kerberos V implementation from KTH)Peter Eisentraut
2002-02-22Add Russian FAQ from Viktor Vislobokov.Bruce Momjian
2002-02-21Update FAQ.Bruce Momjian
2002-02-21Small spacing cleanup.Bruce Momjian
2002-02-21Wrap some SQL syntax examples so \h shows them better.Bruce Momjian
2002-02-21Update FAQ.Bruce Momjian
2002-02-21Update FAQ.Bruce Momjian
2002-02-21Update FAQ.Bruce Momjian
2002-02-18Privileges on functions and procedural languagesPeter Eisentraut
2002-02-18Set version to 7.3devel.Peter Eisentraut
2002-02-18Minor copy-editing.Tom Lane
2002-02-18Fix param handling of create* admin scripts as described months ago.Bruce Momjian
Properly handles default values.
2002-02-18Update FAQ.Bruce Momjian
2002-02-17Fix SGML typo in previous patch.Bruce Momjian
2002-02-17I think it's important that it's actually documented that they can addBruce Momjian
primary keys after the fact! Also, we need to add regression tests for alter table / add primary key and alter table / drop constraint. These shouldn't be added until 7.3 tho methinks... Chris
2002-02-16Clarify params to ALTER TABLE to clearly show single parameters.Bruce Momjian
e.g. table contraint definition -> table_constraint_definition.