Commit Graph

5578 Commits

Author SHA1 Message Date
Tom Lane e82858f013 Release-note updates and copy editing. 2006-01-06 03:00:20 +00:00
Bruce Momjian 0add52b4f6 New pgcrypto item wording. 2006-01-05 15:18:29 +00:00
Bruce Momjian 240fb6dd4f Wording improvements. 2006-01-05 15:12:03 +00:00
Bruce Momjian 4011909a02 Improve markup. 2006-01-05 14:53:18 +00:00
Bruce Momjian 748a71fbff Update release notes. 2006-01-05 05:23:09 +00:00
Bruce Momjian 2a35aedd97 Stamp relesae 8.0.6. 2006-01-05 04:00:29 +00:00
Tom Lane 499dad06f2 Stamp 8.0.5. 2005-12-09 20:49:38 +00:00
Tom Lane 9e127658f2 Add release notes for back branches (7.3 and up).
Also minor improvements to 8.1.1 release notes.
2005-12-09 20:40:38 +00:00
Peter Eisentraut bd760bf800 Documentation fix: s/event_object_name/event_object_table/g 2005-12-08 20:45:26 +00:00
Tom Lane b0be56634b Fix obsolete description of -h option, per Andreas Schmidt. 2005-12-02 23:14:02 +00:00
Bruce Momjian f583cbc8a0 Properly document return value of strpos(). 2005-11-16 03:56:08 +00:00
Bruce Momjian 56f68ed907 Backpatch FAQ's for 8.0.X. 2005-11-05 01:36:42 +00:00
Bruce Momjian 8f03406ee9 Update AIX FAQ, backpatch. 2005-10-26 13:20:47 +00:00
Neil Conway 20f5a328e5 Backpatch merge_db() example for PL/PgSQL to 8.0. Patch from David
Fetter, fixes by Neil Conway.
2005-10-06 21:21:27 +00:00
Bruce Momjian ce150c4a8b Update Japanese FAQ.
Jun Kuwamura
2005-10-05 11:51:27 +00:00
Bruce Momjian b0db380b09 Update version number in faq. 2005-10-05 11:27:10 +00:00
Bruce Momjian 2a3f44b769 Update FAQ's in 8.0.X branch. (very small changes) 2005-10-04 14:18:43 +00:00
Bruce Momjian 610a7c6fdc Add FAQ_hungarian.html to 8.0.X branch. 2005-10-04 14:17:44 +00:00
Tom Lane 3dfec7f73e COPY's test for read-only transaction was backward; it prohibited COPY TO
where it should prohibit COPY FROM.  Found by Alon Goldshuv.
2005-10-03 23:43:29 +00:00
Tom Lane 73a71f50cd Stamp release 8.0.4. 2005-10-03 17:07:18 +00:00
Tom Lane 65ae842791 Update release notes for pending back-branch releases. 2005-10-03 16:04:51 +00:00
Bruce Momjian 0326d705ab Update Russian FAQ.
Victor Vislobokov
2005-09-28 11:33:42 +00:00
Bruce Momjian 9516724bd7 Update FAQ's in 8.0.X branch. 2005-09-22 22:14:11 +00:00
Neil Conway 3926b6e9c3 Fix a mistake in the documentation for SPI_getbinval(), per Michael Fuhr. 2005-09-12 18:49:08 +00:00
Bruce Momjian 9a6f3630cf Fix typo:
sql_information_info -> sql_implementation_info

Robert Treat
2005-08-27 14:13:31 +00:00
Bruce Momjian 18e615979e Backpatch new CVS home page URL. 2005-08-11 13:54:10 +00:00
Bruce Momjian 61dc3df71f Update AIX FAQ.
Chris Browne
2005-07-30 03:39:40 +00:00
Tom Lane 894889ecc4 Force a checkpoint before committing a CREATE DATABASE command. This
should fix the recent reports of "index is not a btree" failures,
as well as preventing a more obscure race condition involving changes
to a template database just after copying it with CREATE DATABASE.
2005-06-25 22:47:49 +00:00
Bruce Momjian 9f64e10225 NetBSD uses "options" not "option". 2005-06-17 16:46:45 +00:00
Tom Lane 887a7255d1 Repair error in description of nonblocking usage of PQgetCopyData().
Per Volkan Yazici.
2005-06-09 19:08:36 +00:00
Bruce Momjian 272f23c814 Update Chinese FAQ to fix XHTML format.
Weiping (Laser)
2005-06-04 03:33:25 +00:00
Bruce Momjian 1d03f3f027 Update Russian FAQ.
Viktor Vislobokov
2005-06-03 18:17:54 +00:00
Bruce Momjian 1b46bcc0c3 Update Farsi FAQ.
Mahmoud Taghizadeh
2005-05-27 22:10:20 +00:00
Bruce Momjian 29167dd3d7 Update Japanese FAQ.
Jun Kuwamura
2005-05-20 15:53:52 +00:00
Neil Conway 621d5e1d72 Fix typo in ECPG docs, per Andreas Seltenreich. 2005-05-20 12:37:51 +00:00
Bruce Momjian ba5684691c Convert Chinese FAQ to valid XHTML, finally. 2005-05-17 04:18:30 +00:00
Bruce Momjian c23e15cd42 Fix Chinese markup some more. 2005-05-17 03:41:14 +00:00
Bruce Momjian 390d460138 Update Chinese FAQ to xhtml. 2005-05-16 02:50:58 +00:00
Tom Lane 011af314b7 Add missing quote, per Dave Page. 2005-05-13 16:48:22 +00:00
Tom Lane 69664f11af Fix broken markup. 2005-05-13 16:47:03 +00:00
Tom Lane f591a227df Update createuser examples to match the current program behavior,
and add an example showing assignment of a password.  Per suggestion
from Jari Aalto (via Martin Pitt).
2005-05-13 16:31:50 +00:00
Bruce Momjian 7b32956f37 Update chinese encoding specification. 2005-05-13 13:48:05 +00:00
Bruce Momjian b5e4dc25f1 Update FAQ URLs.
Robert Treat
2005-05-11 16:13:58 +00:00
Bruce Momjian b746e49c87 Document where to download free Microsoft and Borland development tools. 2005-05-11 16:02:59 +00:00
Bruce Momjian 4401b762c2 Document that bcc compiles now need the -N flag, backpatch to 8.0.X. 2005-05-11 15:10:56 +00:00
Bruce Momjian f7fa826041 Update Chinese FAQ, per Magnus. 2005-05-11 14:57:26 +00:00
Bruce Momjian c20e93d363 Backpatch mention that not all functions are listed, with spelling fix. 2005-05-11 14:10:40 +00:00
Bruce Momjian 22b824ae39 Add mention that not all functions are listed.
Update Chinese FAQ for HTML.
2005-05-11 13:36:53 +00:00
Bruce Momjian 1608d48e15 Backpatch new Chinese FAQ to 8.0.X. 2005-05-11 02:13:21 +00:00
Bruce Momjian 4fa7615da8 Rename encryption section. 2005-05-09 17:26:55 +00:00
Bruce Momjian 00283f4b0a Backpatch FAQ's to 8.0.X for release. 2005-05-09 17:24:04 +00:00
Bruce Momjian 014fce947d Backpatch encryption doc section to 8.0.X. 2005-05-09 17:14:47 +00:00
Tom Lane 8fae36881d Update release notes for upcoming re-releases. 2005-05-09 00:10:06 +00:00
Tom Lane 17eb867e98 Stamp release 8.0.3. 2005-05-05 20:07:36 +00:00
Tom Lane 4afab9639a Alter the signature for encoding conversion functions to declare the
output area as INTERNAL not CSTRING.  This is to prevent people from
calling the functions by hand.  This is a permanent solution for the
back branches but I hope it is just a stopgap for HEAD.
2005-05-03 19:18:16 +00:00
Neil Conway 323fe83608 Backport fix for correct quoting in CREATE DOMAIN example. Per Robert
Treat.
2005-05-02 01:56:16 +00:00
Bruce Momjian 115119e179 Wording improvement. 2005-04-27 20:11:11 +00:00
Bruce Momjian 5e46908a48 Update PAM documentation, per Alvaro. 2005-04-27 20:09:58 +00:00
Bruce Momjian 575d7d0330 Mention that PAM requires the user already exist in the database, per
Dick Davies.
2005-04-26 03:01:22 +00:00
Bruce Momjian 8e4b89ccf2 Backpatch of LIMIT / FOR UPDATE behavior, but keep pre-7.3 mention in 8.0.X. 2005-04-22 15:53:27 +00:00
Bruce Momjian ddae2b6801 Clarify that only crypt can't use md5 pg_shadow passwords. 2005-04-22 04:19:02 +00:00
Bruce Momjian 4f6d275ac7 Clarify use of MD5 authentication and pg_shadow encryption. 2005-04-21 22:19:27 +00:00
Bruce Momjian 0a2400e964 Update PITR wording, per Simon. 2005-04-19 01:40:02 +00:00
Bruce Momjian fef57bd487 Update PITR mention of which WAL files are needed. 2005-04-18 01:29:08 +00:00
Bruce Momjian 2bf3ab90bd Clarify name of file to be checked for PITR expiring. 2005-04-17 03:05:27 +00:00
Tom Lane 7dbded2c9c Stamp 8.0.2. 2005-04-07 19:43:06 +00:00
Tom Lane 9b8438169a Update and copy-edit release notes for 8.0.2. 2005-04-07 19:04:19 +00:00
Bruce Momjian 9c4b34796f Fix release not typo. 2005-04-02 03:43:08 +00:00
Bruce Momjian 6176eb50d4 Update release notes for 8.0.2. 2005-04-02 02:42:59 +00:00
Bruce Momjian 558dace99f Backpatch FAQ's to 8.0.X. 2005-04-01 16:42:59 +00:00
Bruce Momjian cc20233a81 Fix wrong week returnded by date_trunc('week') for early dates in
January --- would return wrong year for 2005-01-01 and 2006-01-01.

per report from Robert Creager.

Backpatch to 8.0.X.
2005-04-01 14:25:39 +00:00
PostgreSQL Daemon 507fc3c554 Tag for 8.0.2beta1 2005-03-26 03:46:33 +00:00
Tom Lane ae7c18d1ae Update and copy-edit description of privileges. 2005-03-25 16:39:03 +00:00
Tom Lane 88f07b183f Fix to_date to behave reasonably when CC and YY fields are both used.
Karel Zak
2005-03-25 16:08:50 +00:00
Bruce Momjian 291cd954fb Change Win32 O_SYNC method to O_DSYNC because that is what the method
currently does.  This is now the default Win32 wal sync method because
we perfer o_datasync to fsync.

Also, change Win32 fsync to a new wal sync method called
fsync_writethrough because that is the behavior of _commit, which is
what is used for fsync on Win32.

Backpatch to 8.0.X.
2005-03-24 04:37:07 +00:00
Tom Lane 63b0d7b35f Add note about risks involved in replaying CREATE TABLESPACE commands
from WAL.  A couple other grammatical improvements too.
2005-03-23 19:39:06 +00:00
Bruce Momjian 2e964aee75 Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't
change content (at least not supposed to).

Magnus Hagander
2005-03-11 21:47:44 +00:00
Tom Lane 4e8af8d273 Replace ARC cache management algorithm with the similar but slightly
simpler 2Q algorithm, to avoid possible problems with the pending patent
on ARC.  Testing so far suggests that there is little if any performance
loss from doing this.

Note that this patch is going into the 8.0 branch only; a much more
extensive revision is planned for HEAD.
2005-03-03 16:47:43 +00:00
Bruce Momjian 9f312cde26 Backpatch clarification of PGPASSWORD to 8.0.X. 2005-02-26 18:50:44 +00:00
Bruce Momjian 4a68e59418 Backpatch FAQ to 8.0.X. 2005-02-25 00:33:45 +00:00
Tom Lane 777745435c Document that only a table's owner may TRUNCATE it. Per Keith Worthington. 2005-02-22 19:06:35 +00:00
Bruce Momjian 7f6754bdb4 Update initdb locale/encoding documentation description. Backpatch to
8.0.X.
2005-02-22 02:56:37 +00:00
Bruce Momjian 6da3aee893 Update Russian FAQ.
Viktor Vislobokov
2005-02-21 17:34:10 +00:00
Neil Conway 14fd629aea Fix two typos, per report from Hashem Masoud. 2005-02-21 06:12:41 +00:00
Neil Conway abd7168524 Document the "register" and "unregister" pg_ctl subcommands, for use on
Windows. Patch from Magnus Hagander.
2005-02-21 02:14:34 +00:00
Bruce Momjian 8814ee8497 Update to Russian FAQ, HEAD and 8.0.X. 2005-02-11 04:54:05 +00:00
Bruce Momjian 538e960939 Mention that some psql environment variables come from libpq and note
more variables can be found in the libpq manual section.

Mention .pgpass in the psql manual page section dealing with connection
parameters and point to the libpq section for more details.

Backpatch to 8.0.X.
2005-02-11 04:19:18 +00:00
Bruce Momjian 7dfc700b96 Update pginstaller URL to http://www.postgresql.org/ftp/win32/.
Backpatch to 8.0.X.
2005-02-10 04:53:11 +00:00
Neil Conway 5b327fb917 Better late than never: document that the GiST API changed in 8.0 in the
"incompatibilities" section of the release notes.
2005-02-06 22:36:10 +00:00
Tom Lane c31570ed43 Document array behavior for out-of-range subscripts. 2005-02-06 20:59:37 +00:00
Bruce Momjian 722c886ba1 Improve wording of to_char() change in 8.1:
The 8.1 release will remove the <function>to_char()</> function
      for intervals.
2005-02-02 18:17:34 +00:00
Bruce Momjian 6aebc34e55 Backpatch FAQ to 8.0.X. 2005-02-02 17:44:51 +00:00
Bruce Momjian 8e2216db6c Backpatch FAQ to 8.0.X. 2005-02-02 13:42:02 +00:00
Bruce Momjian 925320fe3d Backpatch FAQ changes to 8.0.X. 2005-02-01 02:42:03 +00:00
Tom Lane 380c7117ef Recommend security@postgresql.org as the contact point for security-related bugs. 2005-01-30 21:31:57 +00:00
Tom Lane 8097ce9f52 Stamp 8.0 branch as 8.0.1. 2005-01-30 19:17:49 +00:00
Bruce Momjian caf48b43c7 Backpatch FAQ to 8.0.X. 2005-01-30 04:45:23 +00:00
Bruce Momjian cd69dea6a0 FAQ markup fixes. 2005-01-30 04:44:25 +00:00
Bruce Momjian bfdfa4d00d Backpatch FAQ to 8.0.X. 2005-01-30 04:26:40 +00:00
Bruce Momjian 8f2c03752b Backpatch FAQ changes to 8.0.X. 2005-01-30 04:22:53 +00:00
Tom Lane 426ccf86fa We haven't had a fixed limit on rule recursion depth since 7.3 ...
but the documentation still said so.
2005-01-29 23:45:53 +00:00
Tom Lane d8595c9850 Add documentation for format_type(), which somehow escaped it before. 2005-01-28 23:13:26 +00:00
Tom Lane 2bb33a8048 Add note cautioning that you can't use an encrypting IDENT server
with Postgres.
2005-01-28 22:38:50 +00:00
Tom Lane aa060cd714 Close all cursors created during a failed subtransaction. This is needed
to avoid problems when a cursor depends on objects created or changed in
the same subtransaction.  We'd like to do better someday, but this seems
the only workable answer for 8.0.1.
2005-01-26 23:20:37 +00:00
Tom Lane 4cfa8cdfaf Add docs for a couple of formerly-undocumented geometric conversion functions. 2005-01-26 20:42:26 +00:00
Bruce Momjian 3a4589056d Add tools/find_gt_lt to find < and > in SGML source.
Lowercase some uppercase tags so tools is more reliable at finding
problems.
2005-01-23 00:38:05 +00:00
Bruce Momjian 5be6219bdd More < and > changes to ampersands.
8.0.X and HEAD.
2005-01-22 23:23:53 +00:00
Bruce Momjian 60f63fb0d4 More < and > cleanups converted to ampersands. 2005-01-22 23:05:53 +00:00
Bruce Momjian b920addcfd Change -> and <- to use proper ampersand markups.
HEAD and 8.0.X.
2005-01-22 22:10:10 +00:00
Bruce Momjian e2d65d7062 Mention Rekall is GPL now. 2005-01-19 19:54:13 +00:00
Bruce Momjian 02478558e3 Fix typo. 2005-01-19 03:15:59 +00:00
Tom Lane 0f6be37fcb Clarify that the --enable-integer-datetimes switch affects the time and
interval datatypes as well as timestamp.
2005-01-17 18:47:15 +00:00
Bruce Momjian be105bd789 Please find enclosed another patch that now (I hope) really is
correct.  It's in addition to the previous patch.

David Fetter
2005-01-17 17:29:49 +00:00
Neil Conway 8a9cc26ee1 Fix minor thinko in pg_dump documentation of "-n" option. 2005-01-17 04:30:37 +00:00
Bruce Momjian 691bb1d247 Spelling fix. 2005-01-17 04:27:23 +00:00
Bruce Momjian 6ea9da1ee0 Please find enclosed a patch to the pl/perl documents that correctly
tells what arguments go to pl/perl triggers.

David Fetter
2005-01-17 03:04:17 +00:00
Bruce Momjian 56d982b7d4 Mention ALTER COLUMN TYPE in FAQ. 2005-01-17 03:02:56 +00:00
Bruce Momjian 5be1e13dd1 Update German FAQ.
Ian Barwick
2005-01-17 02:42:31 +00:00
Bruce Momjian d2136690a6 Update to 8.0.0 for packaging. 2005-01-17 02:40:56 +00:00
Peter Eisentraut 637cf69b9d Update supported platforms list. 2005-01-17 02:29:23 +00:00
Tom Lane 9175d7df66 Some more copy-editing. 2005-01-17 01:29:02 +00:00
Bruce Momjian da10a47b39 Remove </a>
Alvaro
2005-01-15 22:51:10 +00:00
Bruce Momjian 2d3746759d Update TORA item.
Euler Taveira de Oliveira
2005-01-15 22:44:18 +00:00
Bruce Momjian 6987ca78db Update Brazilian FAQ.
Euler Taveira de Oliveira
2005-01-15 22:14:08 +00:00
Tom Lane a5645972af Some minor editing work on the release notes. 2005-01-15 21:11:46 +00:00
Tom Lane 0e3afb3277 Minor improvements in descriptions of recent changes. 2005-01-15 07:53:04 +00:00
Bruce Momjian 67c1fd1efd Update release notes for 8.0.0 final. Release date set as 2005-01-19! 2005-01-15 05:59:44 +00:00
Bruce Momjian 0b72ebdc0c Merge query of system objects FAQ items. 2005-01-15 05:19:01 +00:00
Tom Lane 893c66de69 Simplify trigger example, per Mark Kirkwood. 2005-01-15 03:38:44 +00:00
Kris Jurka 2c1abfd979 Add index entries for function volatilities. 2005-01-14 21:46:09 +00:00
Tom Lane a294726bc1 Incorporate examples and doc patches from Mark Kirkwood and David Fetter. 2005-01-14 01:16:52 +00:00
Bruce Momjian 29e58330a6 Change Win32 client configuration files from *.txt to *.conf. 2005-01-14 00:25:56 +00:00
Peter Eisentraut 145cc515f0 Update supported platforms list. 2005-01-13 21:13:33 +00:00
Bruce Momjian c2eef62c66 Update of Japanese FAQ.
Jun Kuwamura
2005-01-13 03:08:14 +00:00
Peter Eisentraut 89b5cbe928 Update supported platforms list. 2005-01-10 09:01:04 +00:00
Peter Eisentraut 35fde297c0 Small polishing of bug reporting template 2005-01-10 08:21:43 +00:00
Tom Lane ab3bb9cf78 Add some real documentation about TOAST (finally). Combine this with
the old 'page' chapter and the recently added 'filelayout' chapter to
make a coherent chapter about PostgreSQL's physical storage layout.
2005-01-10 00:04:43 +00:00
Tom Lane 0471cd5f62 Clarify description of greedy and non-greedy POSIX regular expressions,
per discussion in Nov 2004 with Ken Tanzer.
2005-01-09 20:08:50 +00:00
Bruce Momjian a9566cccca Update OS/2 URL. 2005-01-09 19:44:25 +00:00
Tom Lane 7da8623a56 Last batch of updates in response to 7.4 interactive docs comments. 2005-01-09 18:58:10 +00:00
Tom Lane 7bbdb078bd Update discussion of ALTER TABLE ADD COLUMN, per Michael Fuhr. 2005-01-09 17:47:30 +00:00
Tom Lane b548cde1f5 Some more small improvements in response to 7.4 interactive docs comments. 2005-01-09 05:57:45 +00:00
Tom Lane b5adf46cbd Some more small improvements in response to 7.4 interactive docs comments. 2005-01-08 22:13:38 +00:00
Peter Eisentraut b19011e10c Update supported platforms list. 2005-01-08 09:54:47 +00:00
Tom Lane 6889537c48 Some small docs improvements motivated by reading the comments for the 7.4
7.4 interactive docs.
2005-01-08 05:19:18 +00:00
Bruce Momjian cb6eab78b7 Remove mp3 that is now missing. 2005-01-08 03:59:04 +00:00
Tom Lane cef2cc50b5 Some small docs improvements motivated by reading the comments for the
7.4 interactive docs.
2005-01-08 01:44:08 +00:00
Tom Lane ffce35fe6f Add a tip showing how functions on composite types can be used to
emulate computed fields.  I suppose this is why the Berkeley boys made
it work that way in the first place, but the docs never said so anyplace.
2005-01-07 23:08:44 +00:00
Tom Lane 4e64e7f563 Improve discussion of SQL functions taking/returning row types. 2005-01-07 22:40:46 +00:00
Peter Eisentraut 7a986fb4a4 Update supported platforms list 2005-01-07 10:21:02 +00:00