OSDN Git Service
Bruce Momjian [Fri, 31 Oct 2003 04:32:36 +0000 (04:32 +0000)]
Update HISTORY.
Bruce Momjian [Fri, 31 Oct 2003 04:30:22 +0000 (04:30 +0000)]
Update with more comments.
Jan Wieck [Fri, 31 Oct 2003 03:58:21 +0000 (03:58 +0000)]
Fix for possible referential integrity violation when a qualified ON INSERT
rule split the query into one INSERT and one UPDATE where the UPDATE
then hit's the just created row without modifying the key fields again.
In this special case, the new key slipped in totally unchecked.
Jan
Tom Lane [Fri, 31 Oct 2003 03:58:15 +0000 (03:58 +0000)]
Small fix to Christopher's recent improvements --- underscore is not
a special character in regexes, but it is for LIKE, so NOT LIKE 'pg_%'
is incorrect. Need NOT LIKE 'pg\_%'.
Tom Lane [Fri, 31 Oct 2003 00:18:55 +0000 (00:18 +0000)]
Use Tcl ByteArray objects to avoid unwanted character set translation
in libpgtcl's lo_read/lo_write commands. Also, deal correctly with
failure return from lo_read(). ljb and Tom Lane.
Tom Lane [Thu, 30 Oct 2003 21:37:38 +0000 (21:37 +0000)]
Further work on tab completion code: arrange for system catalogs to be
offered for completion only when the input-so-far is at least 'pg_'.
This seems to be the best compromise behavior emerging from yesterday's
discussion. While at it, refactor code to eliminate repetitive use of
nearly identical queries, which was exceedingly tedious to maintain.
Also const-ify code more thoroughly in hopes of moving constant data into
text segment, and remove unnecessary length limit on queries.
Bruce Momjian [Thu, 30 Oct 2003 20:49:47 +0000 (20:49 +0000)]
Fix markup by using <note> for comments.
Bruce Momjian [Thu, 30 Oct 2003 20:31:24 +0000 (20:31 +0000)]
More SGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:29:35 +0000 (20:29 +0000)]
SGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:25:36 +0000 (20:25 +0000)]
Update SGML release notes with Peter's direction. Does not compile
because of section adjustments still needed.
Bruce Momjian [Thu, 30 Oct 2003 19:43:01 +0000 (19:43 +0000)]
Mark release note comments as new subsections rather than footnotes, per
Peter.
Remove "Changes" section and pull all sections below it up one level.
More comment additions.
Tom Lane [Thu, 30 Oct 2003 17:18:55 +0000 (17:18 +0000)]
Allow the query for a plpgsql cursor to begin with '(' as well as 'SELECT'.
Per example from Kumar, 30-Oct-03.
Dave Cramer [Thu, 30 Oct 2003 12:18:56 +0000 (12:18 +0000)]
use the result set to set the fetchsize
Michael Meskes [Thu, 30 Oct 2003 10:19:30 +0000 (10:19 +0000)]
Applied patch by Dave Cramer to fix several bugs in compatlib.
Bruce Momjian [Thu, 30 Oct 2003 03:46:42 +0000 (03:46 +0000)]
Fix markup for new release footnotes.
Bruce Momjian [Thu, 30 Oct 2003 02:40:29 +0000 (02:40 +0000)]
Update FAQ_DEV: elog => ereport.
Bruce Momjian [Wed, 29 Oct 2003 23:28:59 +0000 (23:28 +0000)]
Update more release descriptions.
Bruce Momjian [Wed, 29 Oct 2003 22:54:01 +0000 (22:54 +0000)]
Add more footnote comments to the release notes.
Tom Lane [Wed, 29 Oct 2003 22:20:54 +0000 (22:20 +0000)]
Fix some corner cases in ACL manipulation: don't foul up on an empty
ACL array, and force languages to be treated as owned by the bootstrap
user ID. (pg_language should have a lanowner column, but until it does
this will have to do as a workaround.)
Bruce Momjian [Wed, 29 Oct 2003 20:38:19 +0000 (20:38 +0000)]
Add first release note detail item.
Bruce Momjian [Wed, 29 Oct 2003 20:20:12 +0000 (20:20 +0000)]
Update for 7.4 --- prefer IN to EXISTS.
Tom Lane [Wed, 29 Oct 2003 18:10:15 +0000 (18:10 +0000)]
Give a useful error message if a RangeVar is encountered in an expression.
Per example from Ian Barwick, 28-Oct-03.
Tom Lane [Wed, 29 Oct 2003 17:36:57 +0000 (17:36 +0000)]
compact_fsm_storage() does need to handle the case where a relation's
FSM data has to be both moved down and compressed. Per report from
Dror Matalon.
Bruce Momjian [Wed, 29 Oct 2003 13:42:55 +0000 (13:42 +0000)]
Update for OSF 4.0 platform.
Dave Cramer [Wed, 29 Oct 2003 02:39:10 +0000 (02:39 +0000)]
Patches from Oliver Jowett to fix CursorFetchTest, 7.4 now does not automatically delete cursors
Tom Lane [Tue, 28 Oct 2003 23:35:52 +0000 (23:35 +0000)]
Don't include "schema." in the set of possible tab completions once
"schema." has been typed. This allows readline to complete subsequent
characters immediately if all relations in the target schema start with
the same prefix. This actually worked before, but I unintentionally
broke it a few days ago.
Also, make completion schema-aware for GRANT, REVOKE, VACUUM.
Tom Lane [Tue, 28 Oct 2003 21:55:58 +0000 (21:55 +0000)]
Include -lkrb5 when needed for shlibs depending on libpq. Per report
from Johan Henselmans.
Tom Lane [Tue, 28 Oct 2003 21:05:29 +0000 (21:05 +0000)]
Don't choke when the handler for a procedural language is located in
the pg_catalog schema. Per bug report some months back from Jochem van Dieten.
Tom Lane [Tue, 28 Oct 2003 20:26:47 +0000 (20:26 +0000)]
Guard against Ant versions that print CLASSPATH before the version number
in -version output. Per report from Johann Uhrmann.
Tom Lane [Tue, 28 Oct 2003 20:18:09 +0000 (20:18 +0000)]
Adjust wording to avoid giving the impression that schema USAGE
privilege hides system catalog entries.
Bruce Momjian [Tue, 28 Oct 2003 19:39:18 +0000 (19:39 +0000)]
Add --describe-config to top of postgres manual page.
Bruce Momjian [Tue, 28 Oct 2003 15:01:27 +0000 (15:01 +0000)]
Document --describe-config.
Bruce Momjian [Mon, 27 Oct 2003 18:30:07 +0000 (18:30 +0000)]
Change Solaris tests to test for SHM_SHARE_MMU, per Tom.
Bruce Momjian [Mon, 27 Oct 2003 15:35:10 +0000 (15:35 +0000)]
Update Win32 clients.
Tom Lane [Mon, 27 Oct 2003 07:42:34 +0000 (07:42 +0000)]
Un-break Darwin port.
Bruce Momjian [Mon, 27 Oct 2003 02:52:45 +0000 (02:52 +0000)]
Here is an update to the dbmirror README file.
-References to older versions of PostgreSQL have been removed(It no
longer
compiles against older versions)
-Added a link to PgPerl at GBorg.
Steven Singer
Bruce Momjian [Mon, 27 Oct 2003 02:51:39 +0000 (02:51 +0000)]
Fix MOVE/FETCH wording.
Bruce Momjian [Sun, 26 Oct 2003 14:31:09 +0000 (14:31 +0000)]
Update intel solaris.
Bruce Momjian [Sun, 26 Oct 2003 13:28:46 +0000 (13:28 +0000)]
Improve indenting of port entries.
Bruce Momjian [Sun, 26 Oct 2003 13:26:41 +0000 (13:26 +0000)]
Update Solaris 5.6.
Peter Eisentraut [Sun, 26 Oct 2003 11:14:39 +0000 (11:14 +0000)]
Correct version numbers.
Michael Meskes [Sun, 26 Oct 2003 09:50:47 +0000 (09:50 +0000)]
Fixed bug with indicators when storage for the string is dynamically allocated.
Bruce Momjian [Sun, 26 Oct 2003 04:54:44 +0000 (04:54 +0000)]
'sun' => '__sun__'
Bruce Momjian [Sun, 26 Oct 2003 04:53:24 +0000 (04:53 +0000)]
Test for 'sun' rather than 'solaris' for intimate shared memory.
Bruce Momjian [Sun, 26 Oct 2003 04:51:51 +0000 (04:51 +0000)]
Fix two bugs in funcs.source that made the tutorial script fail.
Make a LOT of fixes to syscat.source to:
* Set search_path properly (and reset it)
* Add schema name to all results
* Add schema name to ORDER BY first
* Make checks for user-defined objects match reality
* format_type all type names
* Respect attisdropped
* Change !~ to 'not like' since it's more standard
Christopher Kings-Lynne
Bruce Momjian [Sun, 26 Oct 2003 04:50:16 +0000 (04:50 +0000)]
Update MOVE/FETCH release note mention.
Bruce Momjian [Sun, 26 Oct 2003 04:43:55 +0000 (04:43 +0000)]
Add:
> * Change LIMIT/OFFSET to use int8
Bruce Momjian [Sun, 26 Oct 2003 04:34:05 +0000 (04:34 +0000)]
Add mention of quotes on function body to NOTES section.
Oliver Elphick
Bruce Momjian [Sun, 26 Oct 2003 04:29:15 +0000 (04:29 +0000)]
Allow win32 client compiles with MSC.
Hiroshi Saito
Bruce Momjian [Sun, 26 Oct 2003 04:21:43 +0000 (04:21 +0000)]
*** empty log message ***
Bruce Momjian [Sun, 26 Oct 2003 02:57:39 +0000 (02:57 +0000)]
Add:
> * Allow more ISOLATION LEVELS to be accepted, but issue a warning for them
Bruce Momjian [Sun, 26 Oct 2003 02:53:45 +0000 (02:53 +0000)]
Uppercase a few keywords in queries.
Bruce Momjian [Sun, 26 Oct 2003 01:41:10 +0000 (01:41 +0000)]
Update for m68k from Peter.
Bruce Momjian [Sun, 26 Oct 2003 01:39:43 +0000 (01:39 +0000)]
Update for Noèl Köthe in SGML.
Bruce Momjian [Sun, 26 Oct 2003 01:32:36 +0000 (01:32 +0000)]
Mark Linux/ppc as working.
Bruce Momjian [Sun, 26 Oct 2003 01:19:57 +0000 (01:19 +0000)]
Mark linux m68k, alpha as working.
Bruce Momjian [Sun, 26 Oct 2003 01:17:31 +0000 (01:17 +0000)]
Remove very old platforms as unsupported, <=7.0.
Bruce Momjian [Sun, 26 Oct 2003 01:06:35 +0000 (01:06 +0000)]
Mark true64 os version as 5.1.
Bruce Momjian [Sun, 26 Oct 2003 01:05:53 +0000 (01:05 +0000)]
Mark true64 alpha port as working.
Bruce Momjian [Sun, 26 Oct 2003 00:58:31 +0000 (00:58 +0000)]
Fix Hans' name in SGML.
Bruce Momjian [Sun, 26 Oct 2003 00:31:48 +0000 (00:31 +0000)]
Update aix port.
Bruce Momjian [Sun, 26 Oct 2003 00:27:59 +0000 (00:27 +0000)]
Fix #elif typo.
Bruce Momjian [Sun, 26 Oct 2003 00:26:13 +0000 (00:26 +0000)]
Update linux/mips port.
Add m68k to linux port.
Bruce Momjian [Sun, 26 Oct 2003 00:22:51 +0000 (00:22 +0000)]
Update linux/mips port.
Bruce Momjian [Sun, 26 Oct 2003 00:21:04 +0000 (00:21 +0000)]
update linux ports for arm, s390, itanium.
Bruce Momjian [Sun, 26 Oct 2003 00:00:40 +0000 (00:00 +0000)]
Update for port freebsd/alpha.
Peter Eisentraut [Sat, 25 Oct 2003 20:18:53 +0000 (20:18 +0000)]
Get Tru64/cc to compile. Need to add -ieee so that it doesn't choke on
0.0/0.0. That option appears to affect the regression test result as well.
The compiler documentation doesn't recommend -O4 for universal use, so
let's stick to the conservative -O (== -O2) by default.
Peter Eisentraut [Sat, 25 Oct 2003 18:18:19 +0000 (18:18 +0000)]
Translation update
Peter Eisentraut [Sat, 25 Oct 2003 18:03:21 +0000 (18:03 +0000)]
Translation updates
Peter Eisentraut [Sat, 25 Oct 2003 15:32:11 +0000 (15:32 +0000)]
Fix CFLAGS selection to actually work. Add test to detect whether gcc's
option -fno-strict-aliasing is available.
Bruce Momjian [Sat, 25 Oct 2003 03:48:47 +0000 (03:48 +0000)]
Remove socket credentials defines not referenced.
Bruce Momjian [Sat, 25 Oct 2003 03:23:47 +0000 (03:23 +0000)]
Update Netbsd/i386 port.
Bruce Momjian [Sat, 25 Oct 2003 03:17:43 +0000 (03:17 +0000)]
Update ports for Solaris.
Bruce Momjian [Fri, 24 Oct 2003 21:28:52 +0000 (21:28 +0000)]
Remove weird test in ccsym
Bruce Momjian [Fri, 24 Oct 2003 21:09:08 +0000 (21:09 +0000)]
Update openbsd port.
Bruce Momjian [Fri, 24 Oct 2003 20:48:10 +0000 (20:48 +0000)]
Don't reference pthread.h unless we have threads enabled, per Peter.
Bruce Momjian [Fri, 24 Oct 2003 20:44:19 +0000 (20:44 +0000)]
Update for osX 10.3.
Bruce Momjian [Fri, 24 Oct 2003 20:39:09 +0000 (20:39 +0000)]
Update ports for freebsd, cygwin.
Peter Eisentraut [Fri, 24 Oct 2003 20:31:43 +0000 (20:31 +0000)]
Use AROPT, not hard-coded flags.
Bruce Momjian [Fri, 24 Oct 2003 16:30:53 +0000 (16:30 +0000)]
Update Linux/Sparc 32-bit port.
Bruce Momjian [Fri, 24 Oct 2003 16:29:00 +0000 (16:29 +0000)]
Update Linux x86 port.
Bruce Momjian [Fri, 24 Oct 2003 15:56:29 +0000 (15:56 +0000)]
Update OSX port.
Bruce Momjian [Fri, 24 Oct 2003 15:31:29 +0000 (15:31 +0000)]
Mark BSD/OS as working in 7.4.
Bruce Momjian [Fri, 24 Oct 2003 15:30:52 +0000 (15:30 +0000)]
Move pre-7.3 platforms to unsupported.
Peter Eisentraut [Fri, 24 Oct 2003 12:07:56 +0000 (12:07 +0000)]
Translation updates
Bruce Momjian [Fri, 24 Oct 2003 03:24:56 +0000 (03:24 +0000)]
Move 2phase discussion to 7.5 queue, not TODO.detail.
Bruce Momjian [Fri, 24 Oct 2003 03:24:32 +0000 (03:24 +0000)]
Move 2phase discussion to 7.5 queue, not TODO.detail.
< o Queries across databases or servers (two-phase commit) [2phase]
> o Queries across databases or servers (two-phase commit)
Bruce Momjian [Fri, 24 Oct 2003 03:21:37 +0000 (03:21 +0000)]
Add 2-phase TODO.detail.
Bruce Momjian [Fri, 24 Oct 2003 03:20:36 +0000 (03:20 +0000)]
Add TODO.detail:
> o Queries across databases or servers (two-phase commit) [2phase]
Bruce Momjian [Thu, 23 Oct 2003 16:40:14 +0000 (16:40 +0000)]
Update INSTALL to say beta5.
Tom Lane [Thu, 23 Oct 2003 13:58:43 +0000 (13:58 +0000)]
Remove obsolete information about altering default optimization flags for
gcc. Per comment from original author, Brian Gallew:
"Ancient history. Kill it fast."
Tom Lane [Wed, 22 Oct 2003 22:28:10 +0000 (22:28 +0000)]
Move docs about index cost estimation functions and writing a procedural
language handler to the 'Internals' area, per my proposal of yesterday.
Clean up the trigger documentation a bit. Push SPI chapter to the end
of its part, and reorder the Internals chapters into what seems a more
sensible order (at the moment anyway).
Bruce Momjian [Wed, 22 Oct 2003 18:10:53 +0000 (18:10 +0000)]
Here is a documentation patch that makes zulu, etc. all more consistent.
Bruce Momjian [Wed, 22 Oct 2003 17:27:14 +0000 (17:27 +0000)]
Release notes updates from Neil Conway.
Bruce Momjian [Wed, 22 Oct 2003 17:14:39 +0000 (17:14 +0000)]
Add:
> * Allow functions to have a search path specified at creation time
Tom Lane [Wed, 22 Oct 2003 16:43:42 +0000 (16:43 +0000)]
Add missing semicolon, per Johann Uhrmann.
Avoids warnings from newer bisons.
Bruce Momjian [Wed, 22 Oct 2003 05:09:12 +0000 (05:09 +0000)]
Add mention that "today" doesn't work as column default anymore.
PostgreSQL Daemon [Wed, 22 Oct 2003 04:16:39 +0000 (04:16 +0000)]
up configure to beta5
Tom Lane [Wed, 22 Oct 2003 03:50:27 +0000 (03:50 +0000)]
Another example-to-documentation difference. Maybe we can find a
better way to keep these in sync...
Tom Lane [Tue, 21 Oct 2003 23:28:42 +0000 (23:28 +0000)]
Ooops, missed updating this part of the complex-datatype example.