]> granicus.if.org Git - postgresql/log
postgresql
23 years agoFix nasty memory leak in pg_restore: _PrintData called inflateInit but
Tom Lane [Tue, 27 Nov 2001 23:48:12 +0000 (23:48 +0000)]
Fix nasty memory leak in pg_restore: _PrintData called inflateInit but
never did inflateEnd, thus leaking some tens of KB per call.  Which
added up *real fast* when dealing with, say, thousands of BLOBs.
Thanks to Lane Rollins for the bug report.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 23:44:03 +0000 (23:44 +0000)]
Update FAQ_DEV.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 21:48:45 +0000 (21:48 +0000)]
Update FAQ_DEV.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 21:23:00 +0000 (21:23 +0000)]
Update TODO list.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 20:45:27 +0000 (20:45 +0000)]
Update FAQ_DEV.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 20:42:15 +0000 (20:42 +0000)]
Update TODO list.

23 years agoUpdate BSD/OS as supported on 7.2.
Bruce Momjian [Tue, 27 Nov 2001 20:35:08 +0000 (20:35 +0000)]
Update BSD/OS as supported on 7.2.

23 years agoAdd a section about loading libpgtcl; fix errors and omissions in
Tom Lane [Tue, 27 Nov 2001 20:33:29 +0000 (20:33 +0000)]
Add a section about loading libpgtcl; fix errors and omissions in
documentation of pg_select command.

23 years agoRemove unused entries.
Bruce Momjian [Tue, 27 Nov 2001 20:25:45 +0000 (20:25 +0000)]
Remove unused entries.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:35:38 +0000 (19:35 +0000)]
Update TODO list.

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 19:31:17 +0000 (19:31 +0000)]
Update TODO list.

23 years agoUpdate FAQ.
Bruce Momjian [Tue, 27 Nov 2001 19:16:55 +0000 (19:16 +0000)]
Update FAQ.

23 years agoUpdate FAQ.
Bruce Momjian [Tue, 27 Nov 2001 18:22:32 +0000 (18:22 +0000)]
Update FAQ.

23 years agostrcat should obviously be strcpy here.
Tom Lane [Tue, 27 Nov 2001 18:21:51 +0000 (18:21 +0000)]
strcat should obviously be strcpy here.

23 years agoChinese PO patch
Bruce Momjian [Tue, 27 Nov 2001 17:51:54 +0000 (17:51 +0000)]
Chinese PO patch

Laser.

23 years agoFix imcomplete SGML tag.
Tatsuo Ishii [Tue, 27 Nov 2001 13:02:33 +0000 (13:02 +0000)]
Fix imcomplete SGML tag.
Please check compile errors before you commit!

23 years agoUpdate TODO list.
Bruce Momjian [Tue, 27 Nov 2001 04:11:08 +0000 (04:11 +0000)]
Update TODO list.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:48:20 +0000 (02:48 +0000)]
Update FAQ_DEV.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:36:59 +0000 (02:36 +0000)]
Update FAQ_DEV.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:03:05 +0000 (02:03 +0000)]
Update FAQ_DEV.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Tue, 27 Nov 2001 02:01:55 +0000 (02:01 +0000)]
Update FAQ_DEV.

23 years agoformating and spelling fixes to my last doc update
Barry Lind [Tue, 27 Nov 2001 01:20:17 +0000 (01:20 +0000)]
formating and spelling fixes to my last doc update

23 years agoFix various bogosities in usage message.
Tom Lane [Mon, 26 Nov 2001 23:10:36 +0000 (23:10 +0000)]
Fix various bogosities in usage message.

23 years agoFix confusion about -f switch: it's output not input.
Tom Lane [Mon, 26 Nov 2001 23:09:21 +0000 (23:09 +0000)]
Fix confusion about -f switch: it's output not input.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Mon, 26 Nov 2001 22:42:51 +0000 (22:42 +0000)]
Update FAQ_DEV.

23 years agoRename make_keywords.README to make_keywords.
Bruce Momjian [Mon, 26 Nov 2001 22:41:58 +0000 (22:41 +0000)]
Rename make_keywords.README to make_keywords.

23 years agoFix unportable, non-spec-compliant use of offsetof() with a nonconstant
Tom Lane [Mon, 26 Nov 2001 22:31:08 +0000 (22:31 +0000)]
Fix unportable, non-spec-compliant use of offsetof() with a nonconstant
member offset.

23 years agoUpdate FAQ_DEV.
Bruce Momjian [Mon, 26 Nov 2001 21:56:40 +0000 (21:56 +0000)]
Update FAQ_DEV.

23 years agoRename find_baddefs to find_badmacros
Bruce Momjian [Mon, 26 Nov 2001 21:42:24 +0000 (21:42 +0000)]
Rename find_baddefs to find_badmacros

23 years agoChange display of FieldSelect nodes from arg.field to field(arg),
Tom Lane [Mon, 26 Nov 2001 21:15:14 +0000 (21:15 +0000)]
Change display of FieldSelect nodes from arg.field to field(arg),
per bug report from Stefan Hadjistoytchev.  There are some cases
where the dot notation works, but there are more where it doesn't.
Eventually ought to consider fixing the parser to allow cases like
func().field, but for now this is the simplest patch.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Nov 2001 21:07:44 +0000 (21:07 +0000)]
Update TODO list.

23 years agoAdd MySQL file system mention.
Bruce Momjian [Mon, 26 Nov 2001 21:07:01 +0000 (21:07 +0000)]
Add MySQL file system mention.

23 years agoAdd LAZY messages.
Bruce Momjian [Mon, 26 Nov 2001 21:03:34 +0000 (21:03 +0000)]
Add LAZY messages.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Nov 2001 21:03:15 +0000 (21:03 +0000)]
Update TODO list.

23 years agoUpdate for all priviledge items.
Bruce Momjian [Mon, 26 Nov 2001 21:01:13 +0000 (21:01 +0000)]
Update for all priviledge items.

23 years agoAdd to TODO item about raw device performance.
Bruce Momjian [Mon, 26 Nov 2001 20:19:30 +0000 (20:19 +0000)]
Add to TODO item about raw device performance.

23 years agoAdd mention of UPDATE permissions.
Bruce Momjian [Mon, 26 Nov 2001 20:11:28 +0000 (20:11 +0000)]
Add mention of UPDATE permissions.

23 years agoAdd documentation about "--" not working on Free/OpenBSD.
Bruce Momjian [Mon, 26 Nov 2001 19:41:55 +0000 (19:41 +0000)]
Add documentation about "--" not working on Free/OpenBSD.

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Nov 2001 19:33:33 +0000 (19:33 +0000)]
Update TODO list.

23 years agoFix for "--" options. Allow --xxx as a valid flag, from NetBSD fix.
Bruce Momjian [Mon, 26 Nov 2001 19:30:58 +0000 (19:30 +0000)]
Fix for "--" options.  Allow --xxx as a valid flag, from NetBSD fix.

23 years agoMore tag cleanups.
Bruce Momjian [Mon, 26 Nov 2001 19:07:11 +0000 (19:07 +0000)]
More tag cleanups.

23 years agoFix SGML tag misspelling.
Bruce Momjian [Mon, 26 Nov 2001 18:51:19 +0000 (18:51 +0000)]
Fix SGML tag misspelling.

23 years agoChinese for psql and pg_dump.
Bruce Momjian [Mon, 26 Nov 2001 17:56:32 +0000 (17:56 +0000)]
Chinese for psql and pg_dump.

laser

23 years agoThis patch mark datatype txtidx as 'extended' storage type.
Bruce Momjian [Mon, 26 Nov 2001 17:45:41 +0000 (17:45 +0000)]
This patch mark datatype txtidx as 'extended' storage type.
Thanks.

Teodor Sigaev

23 years agoUpdate TODO list.
Bruce Momjian [Mon, 26 Nov 2001 06:36:04 +0000 (06:36 +0000)]
Update TODO list.

23 years agoUpdated JDBC todo items
Barry Lind [Mon, 26 Nov 2001 06:08:03 +0000 (06:08 +0000)]
Updated JDBC todo items

23 years agoUpdates to JDBC doc:
Barry Lind [Mon, 26 Nov 2001 05:57:57 +0000 (05:57 +0000)]
Updates to JDBC doc:
  Editing pass over entire chapter
  Rewrote section dealing with Large Objects to also talk about bytea support
  Removed secion on Serialize functionality a we intend to remove it in the
   next release

23 years agoRepair problem with listing rules that have a WHERE condition and
Tom Lane [Mon, 26 Nov 2001 00:29:15 +0000 (00:29 +0000)]
Repair problem with listing rules that have a WHERE condition and
have an INSERT...SELECT as the first or only action.  Per bug report
from Sergio Pili.

23 years agoThis patch fixes a bug reported by Graham Leggett (minfrin@sharp.fm).
Barry Lind [Sun, 25 Nov 2001 23:26:59 +0000 (23:26 +0000)]
This patch fixes a bug reported by Graham Leggett (minfrin@sharp.fm).
The bug was that any insert or update would fail if the returned oid was
larger than a signed int.  Since OIDs are unsigned int's it was
a bug that the code used a java signed int to deal with the values.  The bug
would result in the error message: "Unable to fathom update count".
While fixing the bug, it became apparent that other code made a similar
assumption about OIDs being signed ints.  Therefore some methods that returned
or took OIDs are arguements also needed to be changed.
Since we are so close to the 7.2 release I have added new methods that
return longs and deprecated the old methods returning ints.  Therefore all
old code should still work without requiring a code change to cast from long to int.  Also note that the methods below are PostgreSQL specific extensions to
the JDBC api are are not part of the spec from Sun, thus it is unlikely that
they are used much or at all.

The deprecated methods are:
  ResultSet.getInsertedOID()
  Statement.getInsertedOID()
  Serialize.store()
  Connection.putObject()
and are replaced by:
  ResultSet.getLastOID()
  Statement.getLastOID()
  Serialize.storeObject()
  Connection.storeObject()
All the deprecated methods returned int, while their replacements return long

This patch also fixes two comments in MD5Digest that the author Jeremy Wohl
submitted.

--Barry

23 years agoEncoding isn't necessarily multibyte
Peter Eisentraut [Sun, 25 Nov 2001 22:19:30 +0000 (22:19 +0000)]
Encoding isn't necessarily multibyte

23 years agoFix comment
Peter Eisentraut [Sun, 25 Nov 2001 22:17:27 +0000 (22:17 +0000)]
Fix comment

23 years agoBackend /po patch.
Bruce Momjian [Sun, 25 Nov 2001 18:25:54 +0000 (18:25 +0000)]
Backend /po patch.

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

Weiping He

23 years agoFurther work on postmaster and postgres reference pages.
Tom Lane [Sun, 25 Nov 2001 01:11:36 +0000 (01:11 +0000)]
Further work on postmaster and postgres reference pages.

23 years agoFix markup error I introduced.
Bruce Momjian [Sun, 25 Nov 2001 01:05:37 +0000 (01:05 +0000)]
Fix markup error I introduced.

23 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.

23 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.

23 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.

23 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.

23 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.

23 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.

23 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.

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

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

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

23 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.

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

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

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

23 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.

23 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.

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

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

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

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

23 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.

23 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.

23 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.

23 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.

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

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

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

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

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

23 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.

23 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.

23 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'.

23 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.

23 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.

23 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.

23 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.

23 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).

23 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.

23 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.

23 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.

23 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

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

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

23 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

23 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

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