]> granicus.if.org Git - postgresql/log
postgresql
22 years agoAdd cross-reference to standalone-backend ref page.
Tom Lane [Sun, 25 Nov 2001 00:18:48 +0000 (00:18 +0000)]
Add cross-reference to standalone-backend ref page.

22 years agoMention -c also allows -- GNU long option format, all platforms.
Bruce Momjian [Sun, 25 Nov 2001 00:15:30 +0000 (00:15 +0000)]
Mention -c also allows -- GNU long option format, all platforms.

22 years agoRemove bogus pg_amop insertion commands, per discussion of 25-Oct.
Tom Lane [Sat, 24 Nov 2001 23:28:09 +0000 (23:28 +0000)]
Remove bogus pg_amop insertion commands, per discussion of 25-Oct.
No change in results of script, but perhaps less confusion for people
reading it.

22 years agoTweak int8in to accept -9223372036854775808, per recent discussion in
Tom Lane [Sat, 24 Nov 2001 19:57:06 +0000 (19:57 +0000)]
Tweak int8in to accept -9223372036854775808, per recent discussion in
pgsql-patches.

22 years agoMake initdb --help not line wrap.
Bruce Momjian [Sat, 24 Nov 2001 18:55:53 +0000 (18:55 +0000)]
Make initdb --help not line wrap.

22 years agoRemove extraneous space that somehow got into expected alter_table.out.
Tom Lane [Sat, 24 Nov 2001 04:10:47 +0000 (04:10 +0000)]
Remove extraneous space that somehow got into expected alter_table.out.
The default diff switches prevented regression tests from complaining,
but that doesn't make it correct.

22 years agoFix boundary condition in btbulkdelete: don't examine high key in case
Tom Lane [Fri, 23 Nov 2001 23:41:54 +0000 (23:41 +0000)]
Fix boundary condition in btbulkdelete: don't examine high key in case
where rightmost index page splits while we are waiting to obtain exclusive
lock on it.  Not clear this would actually hurt (probably the callback
would always fail), but better safe than sorry.
Also, improve comments describing concurrency considerations in this code.

22 years agoCopy-editing.
Tom Lane [Fri, 23 Nov 2001 22:06:20 +0000 (22:06 +0000)]
Copy-editing.

22 years agoCopy-editing.
Tom Lane [Fri, 23 Nov 2001 21:08:51 +0000 (21:08 +0000)]
Copy-editing.

22 years agoImprove wording.
Bruce Momjian [Fri, 23 Nov 2001 17:56:13 +0000 (17:56 +0000)]
Improve wording.

22 years agoDocument index entries are built first.
Bruce Momjian [Fri, 23 Nov 2001 17:15:30 +0000 (17:15 +0000)]
Document index entries are built first.

22 years agoUpdate TODO list.
Bruce Momjian [Fri, 23 Nov 2001 02:22:04 +0000 (02:22 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Fri, 23 Nov 2001 01:48:38 +0000 (01:48 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 22 Nov 2001 17:18:51 +0000 (17:18 +0000)]
Update TODO list.

22 years agoRemove compile errors of psql.exe and libpq.dll under
Hiroshi Inoue [Thu, 22 Nov 2001 10:18:52 +0000 (10:18 +0000)]
Remove compile errors of psql.exe and libpq.dll under
Multibyte mode.

22 years agoAdd mention that ALTER TABLE RENAME affects indexes and sequences too.
Bruce Momjian [Thu, 22 Nov 2001 03:42:32 +0000 (03:42 +0000)]
Add mention that ALTER TABLE RENAME affects indexes and sequences too.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 22 Nov 2001 03:10:16 +0000 (03:10 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 22 Nov 2001 03:05:29 +0000 (03:05 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 22 Nov 2001 02:46:49 +0000 (02:46 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Thu, 22 Nov 2001 01:34:12 +0000 (01:34 +0000)]
Update TODO list.

22 years agoAdd description of SSL request protocol. Miscellaneous copy-editing.
Tom Lane [Thu, 22 Nov 2001 01:22:10 +0000 (01:22 +0000)]
Add description of SSL request protocol.  Miscellaneous copy-editing.

22 years ago/doc/src -> /doc for Peter.
Bruce Momjian [Wed, 21 Nov 2001 23:19:25 +0000 (23:19 +0000)]
/doc/src -> /doc for Peter.

22 years agoSpell 'precedes', 'preceding' correctly in various places.
Tom Lane [Wed, 21 Nov 2001 22:57:01 +0000 (22:57 +0000)]
Spell 'precedes', 'preceding' correctly in various places.

22 years agoAdd documentation for pg_get_ruledef and friends.
Tom Lane [Wed, 21 Nov 2001 22:33:14 +0000 (22:33 +0000)]
Add documentation for pg_get_ruledef and friends.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 21 Nov 2001 21:25:28 +0000 (21:25 +0000)]
Update TODO list.

22 years agoRemove mention of internals.ps.
Bruce Momjian [Wed, 21 Nov 2001 21:16:58 +0000 (21:16 +0000)]
Remove mention of internals.ps.

22 years agoSpelling and grammatical corrections.
Tom Lane [Wed, 21 Nov 2001 21:12:34 +0000 (21:12 +0000)]
Spelling and grammatical corrections.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 21 Nov 2001 18:49:50 +0000 (18:49 +0000)]
Update TODO list.

22 years agoUpdate TODO list.
Bruce Momjian [Wed, 21 Nov 2001 18:49:10 +0000 (18:49 +0000)]
Update TODO list.

22 years agoInsert CommandCounterIncrement call into SPI_cursor_open.
Tom Lane [Wed, 21 Nov 2001 18:30:58 +0000 (18:30 +0000)]
Insert CommandCounterIncrement call into SPI_cursor_open.

22 years agoTweak interval_avg support to avoid coredump with Alpha/Tru64 compiler.
Tom Lane [Wed, 21 Nov 2001 18:29:48 +0000 (18:29 +0000)]
Tweak interval_avg support to avoid coredump with Alpha/Tru64 compiler.
Per report from Bernd Tegge.

22 years agoUpdate regress tests to reflect removal of 'current'.
Tom Lane [Wed, 21 Nov 2001 18:27:25 +0000 (18:27 +0000)]
Update regress tests to reflect removal of 'current'.

22 years agoMove internals.ps to web cvs.
Bruce Momjian [Wed, 21 Nov 2001 15:38:15 +0000 (15:38 +0000)]
Move internals.ps to web cvs.

22 years agoPoint to doc/src/postgres.tar.gz, which is where the tarball will be
Bruce Momjian [Wed, 21 Nov 2001 15:08:32 +0000 (15:08 +0000)]
Point to doc/src/postgres.tar.gz, which is where the tarball will be
built, not /doc.

22 years agoDeprecate 'current' date/time constant.
Thomas G. Lockhart [Wed, 21 Nov 2001 06:09:45 +0000 (06:09 +0000)]
Deprecate 'current' date/time constant.
Purge "Postgres" in favor of "PostgreSQL" in docs. ref/ not yet done.

22 years agoAdd a few new time zones, and list every time zone mentioned in my
Thomas G. Lockhart [Wed, 21 Nov 2001 05:58:51 +0000 (05:58 +0000)]
Add a few new time zones, and list every time zone mentioned in my
 Linux box's time zone database.
Do not allow 'current' as a date/time input value.

22 years agoRepair swapped sign for time minus time routine (time_mi_time()).
Thomas G. Lockhart [Wed, 21 Nov 2001 05:57:33 +0000 (05:57 +0000)]
Repair swapped sign for time minus time routine (time_mi_time()).
 Problem reported by Manuel Sugawara (masm@fciencias.unam.mx).

22 years agoAllow 'PostgreSQL' as a date/time formatting style. Formerly, recognized
Thomas G. Lockhart [Wed, 21 Nov 2001 05:55:18 +0000 (05:55 +0000)]
Allow 'PostgreSQL' as a date/time formatting style. Formerly, recognized
 'Postgres' only, but now accepts both.

22 years agoDeprecate 'current' for date/time input.
Thomas G. Lockhart [Wed, 21 Nov 2001 05:53:41 +0000 (05:53 +0000)]
Deprecate 'current' for date/time input.
Fix up references to "PostgreSQL" rather than "Postgres". Was roughly
 evenly split between the two before. ref/ files not yet done.

22 years agoUpdate for first platforms reported as working
Thomas G. Lockhart [Wed, 21 Nov 2001 05:52:01 +0000 (05:52 +0000)]
Update for first platforms reported as working
 for the upcoming 7.2 release.

22 years agoI think it's patch's size problem that I can't
Bruce Momjian [Wed, 21 Nov 2001 05:45:31 +0000 (05:45 +0000)]
I think it's patch's size problem that I can't
send patches to pgsql-patches list.
the zh_CN NLS patch is about 80K,
but sended twice and still can emerge on list.
so I've put it at:

http://laser.zhengmai.com.cn/download/zh_CN.po.diff.tar.gz

If possible, please download it and apply it.
(for current CVS).

    regards   laser

22 years agoFix beta build, for Marc.
Bruce Momjian [Wed, 21 Nov 2001 05:41:15 +0000 (05:41 +0000)]
Fix beta build, for Marc.

22 years ago// -> /* */, per Tatsuo.
Bruce Momjian [Wed, 21 Nov 2001 05:03:16 +0000 (05:03 +0000)]
// -> /* */, per Tatsuo.

22 years agoPeter Eisentraut wrote:
Bruce Momjian [Wed, 21 Nov 2001 03:17:22 +0000 (03:17 +0000)]
Peter Eisentraut wrote:

> So I would base this discussion on the premise "bytea stores binary data"
> (insert examples).
>
> Some stylistic issues:
>
> bytea => <type>bytea</type>
>
> NULLs => zero bytes/bytes of value zero ("NULL" is too overloaded)
>
> 'non-printable' => <quote>nonprintable</quote>
>
> MUST => <emphasis>must</emphasis>
>

Here's a patch against *CVS tip* to address Peter's comments. Please let
me know what you think!

Joe Conway

22 years agoUpdate for bytea, from Joe Conway
Bruce Momjian [Wed, 21 Nov 2001 03:15:54 +0000 (03:15 +0000)]
Update for bytea, from Joe Conway

22 years agoUpdate my2pg.pl for release.
Bruce Momjian [Wed, 21 Nov 2001 02:43:30 +0000 (02:43 +0000)]
Update my2pg.pl for release.

22 years agoUpdate HISTORY, for Tatsuo.
Bruce Momjian [Wed, 21 Nov 2001 02:20:11 +0000 (02:20 +0000)]
Update HISTORY, for Tatsuo.

22 years agoBruce's octet_length change breaks this regression test.
Tom Lane [Tue, 20 Nov 2001 22:22:24 +0000 (22:22 +0000)]
Bruce's octet_length change breaks this regression test.

22 years agoInclude sys/types.h in crypt-des.c. FreeBSD netinet/in.h
Bruce Momjian [Tue, 20 Nov 2001 21:10:38 +0000 (21:10 +0000)]
Include sys/types.h in crypt-des.c.  FreeBSD netinet/in.h
needs it.

Seems it is getting compileable...

Marko Kreen

22 years agoAdded a few paragraphs to explain current restricted execution environment,
Bruce Momjian [Tue, 20 Nov 2001 21:09:53 +0000 (21:09 +0000)]
Added a few paragraphs to explain current restricted execution environment,
and error handling behavior.

Bradley McLean

22 years agoHere's a patch adding documentation for the PQescapeBytea function to
Bruce Momjian [Tue, 20 Nov 2001 20:28:31 +0000 (20:28 +0000)]
Here's a patch adding documentation for the PQescapeBytea function to
libpq.sgml

I was trying (but gave up) to cross-reference back to the input escape
table in the User's Guide, but could not get the documentation to
compile with a cross-book xref (missing IDREF error). Can a cross-book
xref be done?

 Joe Conway

22 years agoDuh, my regexp's missed bunch of them. Here's next batch, this
Bruce Momjian [Tue, 20 Nov 2001 18:54:07 +0000 (18:54 +0000)]
Duh, my regexp's missed bunch of them.  Here's next batch, this
should be all.

Marko Kreen

22 years agoAdd mention of template1 usage.
Bruce Momjian [Tue, 20 Nov 2001 18:23:37 +0000 (18:23 +0000)]
Add mention of template1 usage.

22 years agopgcrypto uses non-standard type uint, which causes compile
Bruce Momjian [Tue, 20 Nov 2001 15:50:53 +0000 (15:50 +0000)]
pgcrypto uses non-standard type uint, which causes compile
failures on FreeBSD.  This patch replaces uint -> unsigned.

This was reported by Daniel Holtzman against 0.4pre3 standalone
package, but it needs fixing in contrib/pgcrypto too.

Marko Kreen

22 years agoI've created a new section to func.sgml, "Binary String Functions and
Bruce Momjian [Tue, 20 Nov 2001 15:42:44 +0000 (15:42 +0000)]
I've created a new section to func.sgml, "Binary String Functions and
Operators", plagiarized shamelessly from the "String Functions and
Operators" section. There were enough differences that it made sense (at
least to me) to give this its own section instead of cramming it in with
normal string functions. This way I could also make the examples
relevant, which is particularly important for bytea.

One thing I think worth mentioning: while documenting the trim()
function I realized that I never implemented the bytea equivalent of
rtrim and ltrim. Therefore, the 'leading' and 'trailing' forms of trim,
available with text, are not available with bytea (I'd be happy to
correct this, but since it would require an initdb, I guess not until
7.3) -- the submitted doc accurately reflects this.

I will look for other areas of the docs that need mention of bytea, but
any guidance would be much appreciated.

--

Here's a second bytea documentation patch. This one significantly
expands the "Binary Data" section added by Bruce recently.

Joe Conway

22 years agoUpdate TODO list.
Bruce Momjian [Tue, 20 Nov 2001 15:28:37 +0000 (15:28 +0000)]
Update TODO list.

22 years agoExpand discussion of logfile management a little bit.
Tom Lane [Tue, 20 Nov 2001 04:27:49 +0000 (04:27 +0000)]
Expand discussion of logfile management a little bit.

22 years agoUpdate HISTORY to current changes.
Bruce Momjian [Tue, 20 Nov 2001 04:18:49 +0000 (04:18 +0000)]
Update HISTORY to current changes.

22 years agoupdate configure.in for b3 ...
PostgreSQL Daemon [Tue, 20 Nov 2001 03:51:31 +0000 (03:51 +0000)]
update configure.in for b3 ...

22 years agoSome minor tweaks of REINDEX processing: grab exclusive lock a little REL7_2_BETA3
Tom Lane [Tue, 20 Nov 2001 02:46:13 +0000 (02:46 +0000)]
Some minor tweaks of REINDEX processing: grab exclusive lock a little
earlier, make error checks more uniform.

22 years agoExpand description of how to use REINDEX.
Tom Lane [Tue, 20 Nov 2001 02:45:00 +0000 (02:45 +0000)]
Expand description of how to use REINDEX.

22 years agoSimplify pg_convert() in that it calls pg_convert2 using new fmgr interface.
Tatsuo Ishii [Tue, 20 Nov 2001 01:32:29 +0000 (01:32 +0000)]
Simplify pg_convert() in that it calls pg_convert2 using new fmgr interface.

22 years agoDouble quotes in ln command to guard against spaces in path.
Tom Lane [Tue, 20 Nov 2001 00:27:13 +0000 (00:27 +0000)]
Double quotes in ln command to guard against spaces in path.

22 years agoChange 'return ;' to 'return;'; remove space.
Bruce Momjian [Mon, 19 Nov 2001 23:19:21 +0000 (23:19 +0000)]
Change 'return ;' to 'return;'; remove space.

22 years agoFill in empty tutorial section about transactions.
Tom Lane [Mon, 19 Nov 2001 23:17:38 +0000 (23:17 +0000)]
Fill in empty tutorial section about transactions.

22 years agoIndent jdbc case labels using pgjindent.
Bruce Momjian [Mon, 19 Nov 2001 23:16:46 +0000 (23:16 +0000)]
Indent jdbc case labels using pgjindent.

22 years agoMore jdbc comment cleanups. Code looks very nice now.
Bruce Momjian [Mon, 19 Nov 2001 22:43:13 +0000 (22:43 +0000)]
More jdbc comment cleanups.  Code looks very nice now.

22 years agoUpdate pgindent README so it gets *.java.in files.
Bruce Momjian [Mon, 19 Nov 2001 22:36:11 +0000 (22:36 +0000)]
Update pgindent README so it gets *.java.in files.

22 years agoJDBC indenting, comment cleanups.
Bruce Momjian [Mon, 19 Nov 2001 22:33:39 +0000 (22:33 +0000)]
JDBC indenting, comment cleanups.

22 years agoUpdate TODO list.
Bruce Momjian [Mon, 19 Nov 2001 20:02:25 +0000 (20:02 +0000)]
Update TODO list.

22 years agoTweak format_type so that we get good behavior for both column type
Tom Lane [Mon, 19 Nov 2001 19:51:20 +0000 (19:51 +0000)]
Tweak format_type so that we get good behavior for both column type
display (with a typemod) and function arg/result type display (without
a typemod).

22 years agoFix arg coerect match text type, per Tom.
Bruce Momjian [Mon, 19 Nov 2001 19:15:07 +0000 (19:15 +0000)]
Fix arg coerect match text type, per Tom.

22 years agoTry to be a little bit clearer about the implications of GRANT TO PUBLIC
Tom Lane [Mon, 19 Nov 2001 19:03:56 +0000 (19:03 +0000)]
Try to be a little bit clearer about the implications of GRANT TO PUBLIC
and REVOKE FROM PUBLIC: the latter is not the same as 'revoke from all
users', but the ref page blurred the difference.

22 years agoMake text octet_length() return non-compressed length to be consistent
Bruce Momjian [Mon, 19 Nov 2001 18:21:10 +0000 (18:21 +0000)]
Make text octet_length() return non-compressed length to be consistent
with other data types, per disucssion.  Encoding issue still open.

22 years agoUpdate TODO list.
Bruce Momjian [Mon, 19 Nov 2001 18:10:38 +0000 (18:10 +0000)]
Update TODO list.

22 years agoGrammatical and spelling fixes.
Tom Lane [Mon, 19 Nov 2001 09:05:02 +0000 (09:05 +0000)]
Grammatical and spelling fixes.

22 years agoFix nasty bugs in pg_convert() and pg_convert2().
Tatsuo Ishii [Mon, 19 Nov 2001 06:48:39 +0000 (06:48 +0000)]
Fix nasty bugs in pg_convert() and pg_convert2().

    o they sometimes returns a result garbage string appended.
    o they do not work if client encoding is different from server
      encoding

22 years agoFix comment at top of file to match file name.
Hiroshi Inoue [Mon, 19 Nov 2001 06:26:00 +0000 (06:26 +0000)]
Fix comment at top of file to match file name.

22 years agopg_restore should exit with status 0, not 1, on success.
Tom Lane [Mon, 19 Nov 2001 06:06:21 +0000 (06:06 +0000)]
pg_restore should exit with status 0, not 1, on success.

22 years agoFix a few typos, grammatical problems, etc in new tutorial material.
Tom Lane [Mon, 19 Nov 2001 05:37:53 +0000 (05:37 +0000)]
Fix a few typos, grammatical problems, etc in new tutorial material.
Overall a really nice job here, Peter ...

22 years agoA bunch of small doco updates motivated by scanning the comments on
Tom Lane [Mon, 19 Nov 2001 03:58:25 +0000 (03:58 +0000)]
A bunch of small doco updates motivated by scanning the comments on
the interactive docs.

22 years agoAdd example of using 'sameuser' followed by 'all' pg_hba records to
Tom Lane [Sun, 18 Nov 2001 23:24:16 +0000 (23:24 +0000)]
Add example of using 'sameuser' followed by 'all' pg_hba records to
enforce a limit on who can connect to databases other than their own.
From a recent discussion in pg-admin.

22 years agoImprove comments about duplicate files.
Bruce Momjian [Sun, 18 Nov 2001 23:02:19 +0000 (23:02 +0000)]
Improve comments about duplicate files.

22 years agoFix some typos.
Tom Lane [Sun, 18 Nov 2001 22:27:00 +0000 (22:27 +0000)]
Fix some typos.

22 years agoUpdate various obsolete remarks about VACUUM.
Tom Lane [Sun, 18 Nov 2001 22:17:30 +0000 (22:17 +0000)]
Update various obsolete remarks about VACUUM.

22 years agoFix typo.
Tom Lane [Sun, 18 Nov 2001 22:13:48 +0000 (22:13 +0000)]
Fix typo.

22 years agoutils/geo-decls.h should be utils/geo_decls.h, per report from
Tom Lane [Sun, 18 Nov 2001 21:28:00 +0000 (21:28 +0000)]
utils/geo-decls.h should be utils/geo_decls.h, per report from
StÃ…phane Raimbault.

22 years agoMention that LIKE ... ESCAPE '' is allowed to specify no
Tom Lane [Sun, 18 Nov 2001 21:17:10 +0000 (21:17 +0000)]
Mention that LIKE ... ESCAPE '' is allowed to specify no
escape character.

22 years agoUpdate TODO list.
Bruce Momjian [Sun, 18 Nov 2001 21:17:04 +0000 (21:17 +0000)]
Update TODO list.

22 years agoPoint out that TRUNCATE can't be used inside a transaction block.
Tom Lane [Sun, 18 Nov 2001 21:14:20 +0000 (21:14 +0000)]
Point out that TRUNCATE can't be used inside a transaction block.

22 years agoInitial round of tweakage for man pages
Peter Eisentraut [Sun, 18 Nov 2001 20:35:02 +0000 (20:35 +0000)]
Initial round of tweakage for man pages

22 years agoUpdates about NLS
Peter Eisentraut [Sun, 18 Nov 2001 20:33:32 +0000 (20:33 +0000)]
Updates about NLS

22 years agoUpdate TODO list.
Bruce Momjian [Sun, 18 Nov 2001 15:32:39 +0000 (15:32 +0000)]
Update TODO list.

22 years agoOptimization for bpcharlen, textlen, varcharlen in case of single byte
Tatsuo Ishii [Sun, 18 Nov 2001 12:07:07 +0000 (12:07 +0000)]
Optimization for bpcharlen, textlen, varcharlen in case of single byte
encodings.

22 years agoMention the option to submit bug reports via a web-form. Minor
Tom Lane [Sun, 18 Nov 2001 07:14:49 +0000 (07:14 +0000)]
Mention the option to submit bug reports via a web-form.  Minor
copy editing.

22 years agoFix obsolete claim that only btree indexes support multiple columns;
Tom Lane [Sun, 18 Nov 2001 00:59:00 +0000 (00:59 +0000)]
Fix obsolete claim that only btree indexes support multiple columns;
GiST does now, too.  (Someone needs to write a description of GiST
to add to this chapter.  I don't know enough about it ...)

22 years agoClean up treatment of creating/dropping databases in User's Guide and
Tom Lane [Sun, 18 Nov 2001 00:38:00 +0000 (00:38 +0000)]
Clean up treatment of creating/dropping databases in User's Guide and
Admin Guide.  Move discussion of template databases out of footnotes
in CREATE DATABASE ref page and into a section of the Admin Guide.
Clean up various obsolete claims, do some copy-editing.

22 years agoCopy-editing.
Tom Lane [Sat, 17 Nov 2001 22:23:55 +0000 (22:23 +0000)]
Copy-editing.

22 years agoExpand documentation for sequence functions (nextval and friends).
Tom Lane [Sat, 17 Nov 2001 22:20:34 +0000 (22:20 +0000)]
Expand documentation for sequence functions (nextval and friends).
Place it in the expected place in the User's Guide, rather than
hiding it in the command reference page for CREATE SEQUENCE.

22 years agoUpdate TODO list.
Bruce Momjian [Sat, 17 Nov 2001 19:53:07 +0000 (19:53 +0000)]
Update TODO list.