OSDN Git Service
Bruce Momjian [Mon, 18 Feb 2002 05:33:13 +0000 (05:33 +0000)]
Add HTML output option to pgcvslog.
Bruce Momjian [Mon, 18 Feb 2002 05:09:01 +0000 (05:09 +0000)]
Update FAQ.
Tatsuo Ishii [Mon, 18 Feb 2002 04:01:27 +0000 (04:01 +0000)]
Fix kanji-coversion key binding. This has been broken since 7.1
Per Yoshinori Ariie's report.
Bruce Momjian [Mon, 18 Feb 2002 03:40:13 +0000 (03:40 +0000)]
Add Neil's Name:
> * Have pg_dump use ADD PRIMARY KEY after COPY, for performance (Neil Conway)
Hiroshi Inoue [Mon, 18 Feb 2002 03:16:11 +0000 (03:16 +0000)]
The version is now 7.01.0010.
1) Handle parameter array.
2) Allow re-use of the connection handle after SQLDisconnect.
3) Reject NULL if no indicator specified.
4) Improve the handling of '_' in table name.
5) Unify internal begin/commit/abort operations.
6) Change SQLTables() to return null not "" for the
table_owner.
7) Fix a bug about parameter handling reported by Benoit Menendez.
8) Add cast in handling ODBC date/time escape sequences.
9) Fix a bug about cache_size handing in declare/fetch mode.
[ODBC3.0 related]
10) Improve the handling of descriptor handles(ODBC3.0).
11) Improve the type handling of some types for ODBC3.0.
[Thanks to Marcelo Aceto for his useful patches]
12) Allow nested ODBC escape.
13) Allow changing autocommit on/off inside the transaction
block.
14) Improve the handling of ODBC scalar functions.
Hiroshi Inoue [Mon, 18 Feb 2002 02:15:04 +0000 (02:15 +0000)]
Separate info30.c from info.c.
Bruce Momjian [Mon, 18 Feb 2002 02:00:43 +0000 (02:00 +0000)]
Add:
> * Have pg_dump use ADD PRIMARY KEY after COPY, for performance
Hiroshi Inoue [Mon, 18 Feb 2002 01:43:24 +0000 (01:43 +0000)]
Add files for ODBC3.0 support.
Bruce Momjian [Mon, 18 Feb 2002 01:17:16 +0000 (01:17 +0000)]
Added:
> * ODBC
> o ODBC 3.0 support
> o Unicode(UCS-2) support
> o Updatable cursors support
Bruce Momjian [Mon, 18 Feb 2002 01:15:46 +0000 (01:15 +0000)]
Remove ODBC todo, add to main TODO.
Bruce Momjian [Sun, 17 Feb 2002 13:29:00 +0000 (13:29 +0000)]
Fix SGML typo in previous patch.
Bruce Momjian [Sun, 17 Feb 2002 11:50:09 +0000 (11:50 +0000)]
I think it's important that it's actually documented that they can add
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
Bruce Momjian [Sat, 16 Feb 2002 23:45:48 +0000 (23:45 +0000)]
Clarify params to ALTER TABLE to clearly show single parameters.
e.g. table contraint definition -> table_constraint_definition.
Peter Eisentraut [Fri, 15 Feb 2002 17:46:57 +0000 (17:46 +0000)]
Remove warning about automatic inclusion of sqlca.
Bruce Momjian [Thu, 14 Feb 2002 17:15:00 +0000 (17:15 +0000)]
Update FAQ.
Tom Lane [Thu, 14 Feb 2002 15:24:10 +0000 (15:24 +0000)]
Ensure that a cursor is scanned under the same scanCommandId it was
originally created with, so that the set of visible tuples does not
change as a result of other activity. This essentially makes PG cursors
INSENSITIVE per the SQL92 definition. See bug report of 13-Feb-02.
Tom Lane [Wed, 13 Feb 2002 19:32:17 +0000 (19:32 +0000)]
Point out that --adduser actually makes the new user a superuser. This
was mentioned on the man page for the underlying CREATE USER command,
but it should be explained here too.
Bruce Momjian [Wed, 13 Feb 2002 14:36:43 +0000 (14:36 +0000)]
Add DROP COLUMN status from Hiroshi.
Tom Lane [Tue, 12 Feb 2002 23:41:25 +0000 (23:41 +0000)]
Use RTLD_NOW, not RTLD_LAZY, as binding mode for dlopen() on all platforms.
This restores the Linux behavior to what it was in PG 7.0 and 7.1, and
causes other platforms to agree. (Other well-tested platforms like HPUX
were doing it this way already.) Per pghackers discussion over the past
month or so.
Tom Lane [Tue, 12 Feb 2002 22:35:07 +0000 (22:35 +0000)]
Add warning not to use /usr/ucb/cc on Solaris.
Bruce Momjian [Tue, 12 Feb 2002 22:25:15 +0000 (22:25 +0000)]
Fix tutorial for references problem, from rainer.tammer@spg.schulergroup.com
Bruce Momjian [Tue, 12 Feb 2002 22:24:36 +0000 (22:24 +0000)]
Clarify working in 'top x items using sequential scan' item
Tom Lane [Tue, 12 Feb 2002 21:25:41 +0000 (21:25 +0000)]
Modify COPY TO to emit carriage returns and newlines as backslash escapes
(backslash-r, backslash-n) for protection against newline-conversion
munging. In future we will also tweak COPY FROM, but this part of the
change should be backwards-compatible. Per pghackers discussion.
Also, update COPY reference page to describe the backslash conversions
more completely and accurately.
Bruce Momjian [Tue, 12 Feb 2002 17:18:10 +0000 (17:18 +0000)]
Update FAQ.
Bruce Momjian [Tue, 12 Feb 2002 17:14:55 +0000 (17:14 +0000)]
Update FAQ.
Bruce Momjian [Mon, 11 Feb 2002 23:25:14 +0000 (23:25 +0000)]
Update wal files computation documentation.
Tom Lane [Mon, 11 Feb 2002 22:41:59 +0000 (22:41 +0000)]
Tweak GiST code to work correctly on machines where 8-byte alignment
of pointers is required. Patch from Teodor Sigaev per pghackers
discussion. It's an ugly kluge but avoids forcing initdb; we'll put
a better fix into 7.3 or later.
Peter Eisentraut [Mon, 11 Feb 2002 21:38:11 +0000 (21:38 +0000)]
Fix for old FreeBSD versions that don't have RTLD_GLOBAL
Tom Lane [Mon, 11 Feb 2002 20:10:50 +0000 (20:10 +0000)]
Repair problems with EvalPlanQual where target table is scanned as
inner indexscan (ie, one with runtime keys). ExecIndexReScan must
compute or recompute runtime keys even if we are rescanning in the
EPQ case. TidScan seems to have comparable problems. Per bug
noted by Barry Lind 11-Feb-02.
Bruce Momjian [Mon, 11 Feb 2002 18:14:56 +0000 (18:14 +0000)]
Fix typo.
< o prevent lose of indexes, permissions, inheritance (Bruce)
---
> o prevent loss of indexes, permissions, inheritance (Bruce)
Bruce Momjian [Mon, 11 Feb 2002 15:19:33 +0000 (15:19 +0000)]
Fix flag handling of pg_upgrade.
Tom Lane [Mon, 11 Feb 2002 00:18:20 +0000 (00:18 +0000)]
Be more wary about mixed-case database names and user names. Get
the CREATE DATABASE command right in pg_dump -C case.
Tom Lane [Mon, 11 Feb 2002 00:14:10 +0000 (00:14 +0000)]
pg_dump and pg_restore man pages need to mention that one should restore
into a virgin database, ie, one created from template0, if there are any
site-local additions in template1.
Tom Lane [Sun, 10 Feb 2002 22:56:31 +0000 (22:56 +0000)]
Don't Assert() that fsync() and close() never fail; I have seen this
crash on Solaris when over disk quota. Instead, report such failures
via elog(DEBUG).
Bruce Momjian [Fri, 8 Feb 2002 16:30:11 +0000 (16:30 +0000)]
Move sys/types.h to top, for hiroyuki hanai/ FreeBSD.
Bruce Momjian [Fri, 8 Feb 2002 14:47:56 +0000 (14:47 +0000)]
Upgrade my2pg version 1.23.
Bruce Momjian [Fri, 8 Feb 2002 06:41:30 +0000 (06:41 +0000)]
Oops, already completed:
< * Have checkpoint process identify itself via ps status display
Bruce Momjian [Fri, 8 Feb 2002 04:32:17 +0000 (04:32 +0000)]
Added:
> * Have checkpoint process identify itself via ps status display
Tom Lane [Thu, 7 Feb 2002 22:20:26 +0000 (22:20 +0000)]
pgstat's truncation of query string needs to be multibyte-aware.
Patch from sugita@sra.co.jp.
Tom Lane [Thu, 7 Feb 2002 22:11:43 +0000 (22:11 +0000)]
Repair some problems in GIST-index contrib modules. Patch from
Teodor Sigaev <teodor@stack.net>.
Hiroshi Inoue [Thu, 7 Feb 2002 00:27:30 +0000 (00:27 +0000)]
Removed a check for REINDEX TABLE.
Peter Eisentraut [Wed, 6 Feb 2002 20:29:35 +0000 (20:29 +0000)]
Fix for parallel make
Tom Lane [Wed, 6 Feb 2002 17:27:50 +0000 (17:27 +0000)]
Fix failure to reconnect as sequence's owner before issuing setval().
Bruce Momjian [Mon, 4 Feb 2002 20:51:22 +0000 (20:51 +0000)]
Update for Tom:
< * Allow row re-use with automatic vacuum (Tom)
356c355
<
---
> * Provide automatic scheduling of background vacuum (Tom)
Bruce Momjian [Mon, 4 Feb 2002 20:46:36 +0000 (20:46 +0000)]
Modified/Added
< * Allow row re-use without vacuum (Tom)
---
> * Allow row re-use with automatic vacuum (Tom)
> * Flush cached query plans when their underlying catalog data changes
Bruce Momjian [Sun, 3 Feb 2002 21:04:12 +0000 (21:04 +0000)]
Stamp configure/configure.in for 7.2, already did register.txt and
bug.template.
Bruce Momjian [Sun, 3 Feb 2002 21:00:09 +0000 (21:00 +0000)]
Stamp 7.2 for release.
Bruce Momjian [Sun, 3 Feb 2002 19:24:30 +0000 (19:24 +0000)]
Remove ENHANCEMENTS section, move subsections up.
Bruce Momjian [Sat, 2 Feb 2002 21:46:45 +0000 (21:46 +0000)]
Update FAQ.
Bruce Momjian [Sat, 2 Feb 2002 20:34:33 +0000 (20:34 +0000)]
Update FAQ.
Bruce Momjian [Sat, 2 Feb 2002 20:34:16 +0000 (20:34 +0000)]
Update for 7.2:
This fixes references to 7.1.3 (I think). It also
modifies the japanese
FAQ, so I'm not sure if that's done correctly.
Chris
Bruce Momjian [Fri, 1 Feb 2002 20:28:32 +0000 (20:28 +0000)]
Update FAQ_DEV.
Bruce Momjian [Fri, 1 Feb 2002 18:23:24 +0000 (18:23 +0000)]
Last Minute AIX_FAQ patch with small corrections for current version,
please apply.
Andreas
Bruce Momjian [Fri, 1 Feb 2002 17:00:17 +0000 (17:00 +0000)]
Added:
> * Prevent SIGHUP and 'pg_ctl reload' from changing command line
> specified parameters to postgresql.conf defaults
Bruce Momjian [Thu, 31 Jan 2002 21:20:03 +0000 (21:20 +0000)]
Consistend spelling for PL/pgSQL
Bruce Momjian [Thu, 31 Jan 2002 19:13:53 +0000 (19:13 +0000)]
Add mention of recovery using pg_upgrade.
Bruce Momjian [Thu, 31 Jan 2002 18:31:44 +0000 (18:31 +0000)]
Update HISTORY/release.sgml for Monday release.
Peter Eisentraut [Thu, 31 Jan 2002 00:51:32 +0000 (00:51 +0000)]
Uniformize spelling
Peter Eisentraut [Thu, 31 Jan 2002 00:46:26 +0000 (00:46 +0000)]
Rebuild from source.
Peter Eisentraut [Wed, 30 Jan 2002 21:59:33 +0000 (21:59 +0000)]
Update Win32-world version number of libpq++.
Peter Eisentraut [Wed, 30 Jan 2002 21:55:33 +0000 (21:55 +0000)]
Don't put empty paragraphs around tables. This messed up JadeTeX somehow,
and doesn't make sense strictly speaking.
Peter Eisentraut [Wed, 30 Jan 2002 21:54:17 +0000 (21:54 +0000)]
Remove Jade/TeX hack, now that OpenJade 1.3.1 has it fixed.
Peter Eisentraut [Wed, 30 Jan 2002 21:53:40 +0000 (21:53 +0000)]
Fix copy-and-paste bug in print style.
Tom Lane [Wed, 30 Jan 2002 19:34:55 +0000 (19:34 +0000)]
Add cast to suppress gcc warning on Darwin platform.
Peter Eisentraut [Tue, 29 Jan 2002 20:39:49 +0000 (20:39 +0000)]
update
Tom Lane [Tue, 29 Jan 2002 15:44:42 +0000 (15:44 +0000)]
Make S/390 TAS spell __inline__ the same way as the other eight GCC
inline routines do.
Tom Lane [Tue, 29 Jan 2002 15:40:45 +0000 (15:40 +0000)]
Remove gratuitous redefinition of inline, which should already have been
taken care of in pg_config.h.
Bruce Momjian [Sun, 27 Jan 2002 04:22:35 +0000 (04:22 +0000)]
Remove dashed items in preparations for 7.3.
Bruce Momjian [Sun, 27 Jan 2002 04:20:38 +0000 (04:20 +0000)]
Add:
> * Allow ORDER BY ... LIMIT to select top values without sort or index
Bruce Momjian [Sat, 26 Jan 2002 23:17:32 +0000 (23:17 +0000)]
Remove link:
> * -Allow LOCK TABLE tab1, tab2, tab3 so all tables locked in unison
Peter Eisentraut [Sat, 26 Jan 2002 19:00:11 +0000 (19:00 +0000)]
Updates from Serguei Mokhov
Tom Lane [Fri, 25 Jan 2002 19:13:15 +0000 (19:13 +0000)]
Overhaul plperl documentation.
Tom Lane [Fri, 25 Jan 2002 18:49:31 +0000 (18:49 +0000)]
Tweak pg_dump to say GRANT ALL when appropriate, rather than enumerating
the individual privilege bits. I regard this as an important change for
cross-version compatibility: without this, a 7.1 dump loaded into 7.2
is likely to be short a few privileges.
Tom Lane [Fri, 25 Jan 2002 15:40:13 +0000 (15:40 +0000)]
Fix typo in usage message, per Oleg.
Bruce Momjian [Fri, 25 Jan 2002 02:39:28 +0000 (02:39 +0000)]
Fix +/- mixup pointed out by Rod Taylor.
Bruce Momjian [Fri, 25 Jan 2002 02:33:39 +0000 (02:33 +0000)]
Add mention of UPDATE
> o Allow UPDATE/DELETE WHERE CURRENT OF cursor using per-cursor tid
Bruce Momjian [Fri, 25 Jan 2002 02:32:59 +0000 (02:32 +0000)]
Add mention of implementation:
> o Allow DELETE WHERE CURRENT OF cursor using per-cursor tid
> stored in the backend
Bruce Momjian [Fri, 25 Jan 2002 02:30:49 +0000 (02:30 +0000)]
Add URL for pgj.
PostgreSQL Daemon [Fri, 25 Jan 2002 02:09:26 +0000 (02:09 +0000)]
let's roll up rc2 ..
Bruce Momjian [Fri, 25 Jan 2002 01:04:47 +0000 (01:04 +0000)]
Add 128 mention:
> * Increase identifier length (NAMEDATALEN) if small performance hit,
> perhaps to standard length of 128; change struct pgNotify to use pid
> first, breaks notify API;
Bruce Momjian [Thu, 24 Jan 2002 23:50:09 +0000 (23:50 +0000)]
Updated:
> * Increase identifier length (NAMEDATALEN) if small performance hit;
> change struct pgNotify to use pid first, breaks notify API
Bruce Momjian [Thu, 24 Jan 2002 23:35:40 +0000 (23:35 +0000)]
Added:
> * Evaluate AIX cs() spinlock macro for performance optimizations (Tatsuo)
Bruce Momjian [Thu, 24 Jan 2002 22:20:18 +0000 (22:20 +0000)]
Another clarification.
Bruce Momjian [Thu, 24 Jan 2002 22:19:48 +0000 (22:19 +0000)]
Clarification on COPY failure options.
Tom Lane [Thu, 24 Jan 2002 21:40:44 +0000 (21:40 +0000)]
Tweak plperl.c to compile against threaded Perls, per report from
cturner@redhat.com.
Tom Lane [Thu, 24 Jan 2002 19:50:36 +0000 (19:50 +0000)]
Cope with gcc that outputs a multiline version string, per Trond.
Tom Lane [Thu, 24 Jan 2002 19:31:36 +0000 (19:31 +0000)]
pltcl's spi_execp didn't handle NULL arguments quite correctly.
It would try to call the input conversion routines for them anyway.
So, a valid input string for the datatype had to be supplied.
Tom Lane [Thu, 24 Jan 2002 18:28:15 +0000 (18:28 +0000)]
Fix documentation misstatement: OLD is not valid in ON SELECT.
Tom Lane [Thu, 24 Jan 2002 16:53:42 +0000 (16:53 +0000)]
Fix incorrect test for whether Perl code is returning undef. This
allows plperl routines to return NULL as intended.
Tom Lane [Thu, 24 Jan 2002 15:31:43 +0000 (15:31 +0000)]
Fix logic error in insert_fsm_page_entry: because compact_fsm_page_list
removes any empty chunks, the chunk previously added won't be there
anymore, so it's possible there is zero free space in the rel's page list
afterwards. Must loop back and rerun the part that adds a chunk to
the list.
Tom Lane [Wed, 23 Jan 2002 21:08:17 +0000 (21:08 +0000)]
Overhaul PL/Tcl documentation.
Bruce Momjian [Wed, 23 Jan 2002 19:22:08 +0000 (19:22 +0000)]
Add Goggle mention of previous discussion.
Tom Lane [Wed, 23 Jan 2002 18:48:39 +0000 (18:48 +0000)]
Remove long-obsolete version of pltcl documentation.
Tom Lane [Wed, 23 Jan 2002 18:45:41 +0000 (18:45 +0000)]
Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs,
rather than trying to persude gmake to do it.
Bruce Momjian [Wed, 23 Jan 2002 18:40:22 +0000 (18:40 +0000)]
Add new email;remove old entries.
Michael Meskes [Wed, 23 Jan 2002 16:34:06 +0000 (16:34 +0000)]
Added patch to temporarily disable locale for descriptors too (Christof)
Bruce Momjian [Wed, 23 Jan 2002 16:14:04 +0000 (16:14 +0000)]
Add:
> * Reorder postgresql.conf WAL items in order of importance
> * Remove wal_files postgresql.conf option because WAL files are now recycled
> * Find proper defaults for postgresql.conf WAL entries
> * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints
> that are too frequent
Bruce Momjian [Tue, 22 Jan 2002 22:22:34 +0000 (22:22 +0000)]
Clarify URL:
< http://www1.distributed.net/source, in client/common/cpucheck.cpp
---
> from distributted.net, http://www1.distributed.net/source,
> in client/common/cpucheck.cpp
Bruce Momjian [Tue, 22 Jan 2002 22:15:07 +0000 (22:15 +0000)]
Document SMP detection code.
Bruce Momjian [Tue, 22 Jan 2002 21:55:06 +0000 (21:55 +0000)]
Re-group items.