1
0
mirror of https://github.com/postgres/postgres.git synced 2025-07-31 22:04:40 +03:00
Commit Graph

6461 Commits

Author SHA1 Message Date
5db90cc645 Clarify vacuum lazy can shrink a file under certain circumstances. 2005-12-07 05:36:08 +00:00
c90f02316e Update iconv wording, per Peter. 2005-12-06 21:01:32 +00:00
494d1f1497 Highlight diff idea for iconv. 2005-12-06 20:26:02 +00:00
34dc4228cb iconv uses UTF-8, not UTF8. 2005-12-06 20:19:38 +00:00
ead868059b Document method of removing invalid UTF8 escape sequences from dump
file.  Backpatch to 8.1.X.

Paul Lindner
2005-12-06 19:27:09 +00:00
0ebd65ddd4 Since my name has a non-ascii-letter in it, it's often spelled wrong. In
the latest release notes there is a latin1 character that shouldn't be
there so I made a patch to fix that. This patch also fixes some old
entries that uses o instead of ö (which is also wrong but not as
bad as including a latin1 character in the sgml file).

Dennis Bj?rklund
2005-12-06 18:43:40 +00:00
dfdec60447 Allow to_char(interval) and to_char(time) to use AM/PM specifications.
Map them to a single day, so '30 hours' is 'AM'.

Have to_char(interval) and to_char(time) use "HH", "HH12" as 12-hour
intervals, rather than bypass and print the full interval hours.  This
is neeeded because to_char(time) is mapped to interval in this function.
Intervals should use "HH24", and document suggestion.

Allow "D" format specifiers for interval/time.
2005-12-03 16:45:23 +00:00
4ed2e803ef Fix obsolete description of -h option, per Andreas Schmidt. 2005-12-02 23:13:53 +00:00
bc0b56c0fe Fix typo in PL/PgSQL documentation, per Chris KL. 2005-12-01 10:38:09 +00:00
fc9b777a79 Improve documentation for COALESCE and NULLIF. Add references for NVL
and IFNULL.

Backpatch to 8.1.X.
2005-11-28 23:19:03 +00:00
1012a93264 Update Japanese FAQ.
J.Kuwamura
2005-11-18 00:41:26 +00:00
1cb945bd50 Properly document return value of strpos(). 2005-11-16 03:56:35 +00:00
2a80c3c4dc Tag everything for 8.1.0 ... Finally, a relesae on scheduale!! 2005-11-05 04:01:57 +00:00
75a429463a Update FAQ for most recent release as 8.1. 2005-11-05 01:35:18 +00:00
9ba4c42401 Yet another supported-platforms update. 2005-11-05 00:04:04 +00:00
fd68553860 Editorial review for partitioning/constraint exclusion documentation. 2005-11-04 23:53:18 +00:00
39dfbe5791 Spellchecking run, final cleanups 2005-11-04 23:14:02 +00:00
1630571a04 Update release notes for 8.1. 2005-11-04 22:21:33 +00:00
081ed99b1e We haven't seen any agreement emerge as to what is causing AIX 5.3 ML3
to fail to successfully build the release candidates.

However, a patch has emerged (thanks, Seneca!) that does allow it to
work, and which I'd expect to be portable (better still!).

We are still actively pursuing why it breaks, but supposing that still
remains outstanding, at least the following would allow AIX users to
better survive a build...

Chris Browne
2005-11-04 18:16:50 +00:00
e47ea0566c Update supported-platforms list. 2005-11-04 16:15:20 +00:00
03381695c6 Avoid referring to a specific version of the SQL standard except where
necessary, and be careful to refer to the right version where it is
useful to do so.  This partially reverts an ill-considered search and
replace from a few months ago.
2005-11-04 02:56:31 +00:00
8bd1cbb86d Some minor improvements to the CE docs. Also fix a bit of SGML markup
elsewhere.
2005-11-03 00:51:43 +00:00
ced9dd3699 Add Tomoaki Sato to pgbench changes in release notes. 2005-11-02 14:08:43 +00:00
eddcd492fe Add some documentation for constraint exclusion and basic partitioning.
From Simon Riggs; cleanup and editorialization by Neil Conway.
2005-11-01 23:19:05 +00:00
b524cb36ac Make an editorial pass over the reference pages. 2005-11-01 21:09:51 +00:00
37a4232a0c Update supported-platforms entry for Tru64. 2005-10-31 21:12:35 +00:00
ee72793a91 Mention in the docs that temporary/non-temp tables can not share
referential integrity relationships.
2005-10-31 18:13:52 +00:00
90456d1303 Update supported-platforms list. 2005-10-30 19:21:42 +00:00
d8247b0f50 tag it for rc1 2005-10-30 05:06:03 +00:00
9c67981683 Fix psql ref typo.
Andreas Seltenreich
2005-10-30 03:01:49 +00:00
a7335a3401 Update supported-platforms list. 2005-10-28 20:01:40 +00:00
65a99590ab Fix broken markup. 2005-10-28 20:00:03 +00:00
fbff2e9607 Remove mention that \x doesn't affect backslash commands. 2005-10-28 02:39:07 +00:00
bc93b3741d Update:
< 	o Allow ALTER TABLE RENAME CONSTRAINT
> 	o Add ALTER TABLE RENAME CONSTRAINT, update index name also
2005-10-27 14:16:05 +00:00
befc607dee Add:
> 	o Have ALTER INDEX update the name of a constraint using that index
> 	o Allow ALTER TABLE RENAME CONSTRAINT
2005-10-27 14:07:29 +00:00
6859d8c141 Add mention that .pgpass localhost matches tcp and unix domain sockets. 2005-10-27 13:53:41 +00:00
0849955f3a Add mention of errfinish. 2005-10-27 13:48:14 +00:00
3332e38189 Disable expanded mode only for \d tablename, not for all backslash
commands.  Per complaint that \df+ is clearer in expanded mode.
2005-10-27 13:34:47 +00:00
807da29cf3 Add items from Tom:
< 	o Add a GUC variable to allow output of interval values in ISO8601
< 	  format
212a211,223
> 	o Add a GUC variable to allow output of interval values in ISO8601
> 	  format
> 	o Improve timestamptz subtraction to be DST-aware
>
> 	  Currently, subtracting one date from another that crosses a
> 	  daylight savings time adjustment can return '1 day 1 hour', but
> 	  adding that back to the first date returns a time one hour in
> 	  the future.  This is caused by the adjustment of '25 hours' to
> 	  '1 day 1 hour', and '1 day' is the same time the next day, even
> 	  if daylight savings adjustments are involved.
>
> 	o Fix interval display to support values exceeding 2^31 hours
> 	o Add overflow checking to timestamp and interval arithmetic
2005-10-27 02:33:31 +00:00
4a309defb4 Add info about using rsync to make base backups. Per report from
Jeff Frost, it may be necessary to ignore specific exit codes.
2005-10-26 20:42:35 +00:00
fc5894bf77 Adjust parser so that POSTQUEL-style implicit RTEs are stored with
inFromCl true, meaning that they will list out as explicit RTEs if they
are in a view or rule.  Update comments about inFromCl to reflect the way
it's now actually used.  Per recent discussion.
2005-10-26 19:21:55 +00:00
7d9ff58b22 Rename config section headings.
Simon Riggs
2005-10-26 12:55:07 +00:00
62cfa0f75c Add:
>
> 	o Add auto-expanded mode so expanded output is used if the row
> 	  length is wider than the screen width.
>
> 	  Consider using auto-expanded mode for backslash commands like \df+.
2005-10-25 18:50:56 +00:00
602007842c Convert explanation of interval change into something resembling grammatical
English, and fix the incorrect example.
2005-10-25 17:54:30 +00:00
c78f3039f2 Small grammar correction. 2005-10-25 15:47:51 +00:00
b83547201f Update 24 hours/1 day distinction in release notes. 2005-10-25 15:12:22 +00:00
352a7841bf Update the URL for "The Hitch-Hiker's Guide to Evolutionary Computation".
Sergey E. Koposov
2005-10-25 13:38:09 +00:00
404bc385d1 IBM has addressed the socket address storage issue as of AIX 5.3
maintenance level 5300-03; the following patch adds documentation to
FAQ_AIX.

Chris Browne
2005-10-24 22:30:35 +00:00
9507b56031 Add:
> * Allow user-defined functions retuning a domain value to enforce domain
>   constraints
2005-10-24 18:08:52 +00:00
42b689aed4 More forcefully recommend MD5 over crypt authentication. 2005-10-24 15:49:54 +00:00