]> granicus.if.org Git - postgresql/log
postgresql
21 years agoSpell checking, consistent terminology.
Peter Eisentraut [Sat, 1 Nov 2003 01:56:29 +0000 (01:56 +0000)]
Spell checking, consistent terminology.

21 years agoUpdate future-tense comments in README to present tense. Noted by
Tom Lane [Fri, 31 Oct 2003 22:48:08 +0000 (22:48 +0000)]
Update future-tense comments in README to present tense.  Noted by
Neil Conway.

21 years agoRewrite GiST documentation into something actually useful.
Tom Lane [Fri, 31 Oct 2003 22:41:21 +0000 (22:41 +0000)]
Rewrite GiST documentation into something actually useful.

Christopher Kings-Lynne

21 years agoFix broken markup.
Tom Lane [Fri, 31 Oct 2003 22:22:10 +0000 (22:22 +0000)]
Fix broken markup.

21 years agoTranslation update
Peter Eisentraut [Fri, 31 Oct 2003 22:14:15 +0000 (22:14 +0000)]
Translation update

21 years agoWhen a superuser does GRANT or REVOKE on an object he doesn't own,
Tom Lane [Fri, 31 Oct 2003 20:00:49 +0000 (20:00 +0000)]
When a superuser does GRANT or REVOKE on an object he doesn't own,
process the command as though it were issued by the object owner.
This prevents creating weird scenarios in which the same privileges
may appear to flow from different sources, and ensures that a superuser
can in fact revoke all privileges if he wants to.  In particular this
means that the regression tests work when run by a superuser other than
the original bootstrap userid.  Per report from Larry Rosenman.

21 years agonew protocol, faster startup.
Bruce Momjian [Fri, 31 Oct 2003 19:51:14 +0000 (19:51 +0000)]
new protocol, faster startup.

21 years agoUpdate for polymorphic functions, needs more work.
Bruce Momjian [Fri, 31 Oct 2003 19:49:40 +0000 (19:49 +0000)]
Update for polymorphic functions, needs more work.

21 years agoMAC OS X => Mac OS X
Bruce Momjian [Fri, 31 Oct 2003 19:33:17 +0000 (19:33 +0000)]
MAC OS X => Mac OS X

21 years agoRelease updates suggested by Tom.
Bruce Momjian [Fri, 31 Oct 2003 19:24:17 +0000 (19:24 +0000)]
Release updates suggested by Tom.

21 years agoMinor cleanup of PQunescapeBytea(). Avoid unportable assumptions about
Tom Lane [Fri, 31 Oct 2003 17:43:10 +0000 (17:43 +0000)]
Minor cleanup of PQunescapeBytea().  Avoid unportable assumptions about
behavior of malloc and realloc when request size is 0.  Fix escape
sequence recognizer so that only valid 3-digit octal sequences are
treated as escape sequences ... isdigit() is not a correct test.

21 years agoMoved the recently added test for foreign key disabled by rewrite
Jan Wieck [Fri, 31 Oct 2003 14:27:57 +0000 (14:27 +0000)]
Moved the recently added test for foreign key disabled by rewrite
rule into the rule.sql since it affects the latter if run in paralell.

Jan

21 years agoIf EOF is found inside a string/comment/etc. stop parsing.
Michael Meskes [Fri, 31 Oct 2003 14:10:41 +0000 (14:10 +0000)]
If EOF is found inside a string/comment/etc. stop parsing.

21 years agoRemove <note> take, use another paragraph for description.
Bruce Momjian [Fri, 31 Oct 2003 04:44:25 +0000 (04:44 +0000)]
Remove <note> take, use another paragraph for description.

21 years agoUpdate HISTORY.
Bruce Momjian [Fri, 31 Oct 2003 04:32:36 +0000 (04:32 +0000)]
Update HISTORY.

21 years agoUpdate with more comments.
Bruce Momjian [Fri, 31 Oct 2003 04:30:22 +0000 (04:30 +0000)]
Update with more comments.

21 years agoFix for possible referential integrity violation when a qualified ON INSERT
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

21 years agoSmall fix to Christopher's recent improvements --- underscore is not
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\_%'.

21 years agoUse Tcl ByteArray objects to avoid unwanted character set translation
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.

21 years agoFurther work on tab completion code: arrange for system catalogs to be
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.

21 years agoFix markup by using <note> for comments.
Bruce Momjian [Thu, 30 Oct 2003 20:49:47 +0000 (20:49 +0000)]
Fix markup by using <note> for comments.

21 years agoMore SGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:31:24 +0000 (20:31 +0000)]
More SGML cleanup.

21 years agoSGML cleanup.
Bruce Momjian [Thu, 30 Oct 2003 20:29:35 +0000 (20:29 +0000)]
SGML cleanup.

21 years agoUpdate SGML release notes with Peter's direction. Does not compile
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.

21 years agoMark release note comments as new subsections rather than footnotes, per
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.

21 years agoAllow the query for a plpgsql cursor to begin with '(' as well as 'SELECT'.
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.

21 years agouse the result set to set the fetchsize
Dave Cramer [Thu, 30 Oct 2003 12:18:56 +0000 (12:18 +0000)]
use the result set to set the fetchsize

21 years agoApplied patch by Dave Cramer to fix several bugs in compatlib.
Michael Meskes [Thu, 30 Oct 2003 10:19:30 +0000 (10:19 +0000)]
Applied patch by Dave Cramer to fix several bugs in compatlib.

21 years agoFix markup for new release footnotes.
Bruce Momjian [Thu, 30 Oct 2003 03:46:42 +0000 (03:46 +0000)]
Fix markup for new release footnotes.

21 years agoUpdate FAQ_DEV: elog => ereport.
Bruce Momjian [Thu, 30 Oct 2003 02:40:29 +0000 (02:40 +0000)]
Update FAQ_DEV:  elog => ereport.

21 years agoUpdate more release descriptions.
Bruce Momjian [Wed, 29 Oct 2003 23:28:59 +0000 (23:28 +0000)]
Update more release descriptions.

21 years agoAdd more footnote comments to the release notes.
Bruce Momjian [Wed, 29 Oct 2003 22:54:01 +0000 (22:54 +0000)]
Add more footnote comments to the release notes.

21 years agoFix some corner cases in ACL manipulation: don't foul up on an empty
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.)

21 years agoAdd first release note detail item.
Bruce Momjian [Wed, 29 Oct 2003 20:38:19 +0000 (20:38 +0000)]
Add first release note detail item.

21 years agoUpdate for 7.4 --- prefer IN to EXISTS.
Bruce Momjian [Wed, 29 Oct 2003 20:20:12 +0000 (20:20 +0000)]
Update for 7.4 --- prefer IN to EXISTS.

21 years agoGive a useful error message if a RangeVar is encountered in an expression.
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.

21 years agocompact_fsm_storage() does need to handle the case where a relation's
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.

21 years agoUpdate for OSF 4.0 platform.
Bruce Momjian [Wed, 29 Oct 2003 13:42:55 +0000 (13:42 +0000)]
Update for OSF 4.0 platform.

21 years agoPatches from Oliver Jowett to fix CursorFetchTest, 7.4 now does not automatically...
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

21 years agoDon't include "schema." in the set of possible tab completions once
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.

21 years agoInclude -lkrb5 when needed for shlibs depending on libpq. Per report
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.

21 years agoDon't choke when the handler for a procedural language is located in
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.

21 years agoGuard against Ant versions that print CLASSPATH before the version number
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.

21 years agoAdjust wording to avoid giving the impression that schema USAGE
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.

21 years agoAdd --describe-config to top of postgres manual page.
Bruce Momjian [Tue, 28 Oct 2003 19:39:18 +0000 (19:39 +0000)]
Add --describe-config to top of postgres manual page.

21 years agoDocument --describe-config.
Bruce Momjian [Tue, 28 Oct 2003 15:01:27 +0000 (15:01 +0000)]
Document --describe-config.

21 years agoChange Solaris tests to test for SHM_SHARE_MMU, per Tom.
Bruce Momjian [Mon, 27 Oct 2003 18:30:07 +0000 (18:30 +0000)]
Change Solaris tests to test for SHM_SHARE_MMU, per Tom.

21 years agoUpdate Win32 clients.
Bruce Momjian [Mon, 27 Oct 2003 15:35:10 +0000 (15:35 +0000)]
Update Win32 clients.

21 years agoUn-break Darwin port.
Tom Lane [Mon, 27 Oct 2003 07:42:34 +0000 (07:42 +0000)]
Un-break Darwin port.

21 years agoHere is an update to the dbmirror README file.
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

21 years agoFix MOVE/FETCH wording.
Bruce Momjian [Mon, 27 Oct 2003 02:51:39 +0000 (02:51 +0000)]
Fix MOVE/FETCH wording.

21 years agoUpdate intel solaris.
Bruce Momjian [Sun, 26 Oct 2003 14:31:09 +0000 (14:31 +0000)]
Update intel solaris.

21 years agoImprove indenting of port entries.
Bruce Momjian [Sun, 26 Oct 2003 13:28:46 +0000 (13:28 +0000)]
Improve indenting of port entries.

21 years agoUpdate Solaris 5.6.
Bruce Momjian [Sun, 26 Oct 2003 13:26:41 +0000 (13:26 +0000)]
Update Solaris 5.6.

21 years agoCorrect version numbers.
Peter Eisentraut [Sun, 26 Oct 2003 11:14:39 +0000 (11:14 +0000)]
Correct version numbers.

21 years agoFixed bug with indicators when storage for the string is dynamically allocated.
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.

21 years ago'sun' => '__sun__'
Bruce Momjian [Sun, 26 Oct 2003 04:54:44 +0000 (04:54 +0000)]
'sun' => '__sun__'

21 years agoTest for 'sun' rather than 'solaris' for intimate shared memory.
Bruce Momjian [Sun, 26 Oct 2003 04:53:24 +0000 (04:53 +0000)]
Test for 'sun' rather than 'solaris' for intimate shared memory.

21 years agoFix two bugs in funcs.source that made the tutorial script fail.
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

21 years agoUpdate MOVE/FETCH release note mention.
Bruce Momjian [Sun, 26 Oct 2003 04:50:16 +0000 (04:50 +0000)]
Update MOVE/FETCH release note mention.

21 years agoAdd:
Bruce Momjian [Sun, 26 Oct 2003 04:43:55 +0000 (04:43 +0000)]
Add:

> * Change LIMIT/OFFSET to use int8

21 years agoAdd mention of quotes on function body to NOTES section.
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

21 years agoAllow win32 client compiles with MSC.
Bruce Momjian [Sun, 26 Oct 2003 04:29:15 +0000 (04:29 +0000)]
Allow win32 client compiles with MSC.

Hiroshi Saito

21 years ago*** empty log message ***
Bruce Momjian [Sun, 26 Oct 2003 04:21:43 +0000 (04:21 +0000)]
*** empty log message ***

21 years agoAdd:
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

21 years agoUppercase a few keywords in queries.
Bruce Momjian [Sun, 26 Oct 2003 02:53:45 +0000 (02:53 +0000)]
Uppercase a few keywords in queries.

21 years agoUpdate for m68k from Peter.
Bruce Momjian [Sun, 26 Oct 2003 01:41:10 +0000 (01:41 +0000)]
Update for m68k from Peter.

21 years agoUpdate for No&egrave;l K&ouml;the in SGML.
Bruce Momjian [Sun, 26 Oct 2003 01:39:43 +0000 (01:39 +0000)]
Update for No&egrave;l K&ouml;the in SGML.

21 years agoMark Linux/ppc as working.
Bruce Momjian [Sun, 26 Oct 2003 01:32:36 +0000 (01:32 +0000)]
Mark Linux/ppc as working.

21 years agoMark linux m68k, alpha as working.
Bruce Momjian [Sun, 26 Oct 2003 01:19:57 +0000 (01:19 +0000)]
Mark linux m68k, alpha as working.

21 years agoRemove very old platforms as unsupported, <=7.0.
Bruce Momjian [Sun, 26 Oct 2003 01:17:31 +0000 (01:17 +0000)]
Remove very old platforms as unsupported, <=7.0.

21 years agoMark true64 os version as 5.1.
Bruce Momjian [Sun, 26 Oct 2003 01:06:35 +0000 (01:06 +0000)]
Mark true64 os version as 5.1.

21 years agoMark true64 alpha port as working.
Bruce Momjian [Sun, 26 Oct 2003 01:05:53 +0000 (01:05 +0000)]
Mark true64 alpha port as working.

21 years agoFix Hans' name in SGML.
Bruce Momjian [Sun, 26 Oct 2003 00:58:31 +0000 (00:58 +0000)]
Fix Hans' name in SGML.

21 years agoUpdate aix port.
Bruce Momjian [Sun, 26 Oct 2003 00:31:48 +0000 (00:31 +0000)]
Update aix port.

21 years agoFix #elif typo.
Bruce Momjian [Sun, 26 Oct 2003 00:27:59 +0000 (00:27 +0000)]
Fix #elif typo.

21 years agoUpdate linux/mips port.
Bruce Momjian [Sun, 26 Oct 2003 00:26:13 +0000 (00:26 +0000)]
Update linux/mips port.

Add m68k to linux port.

21 years agoUpdate linux/mips port.
Bruce Momjian [Sun, 26 Oct 2003 00:22:51 +0000 (00:22 +0000)]
Update linux/mips port.

21 years agoupdate linux ports for arm, s390, itanium.
Bruce Momjian [Sun, 26 Oct 2003 00:21:04 +0000 (00:21 +0000)]
update linux ports for arm, s390, itanium.

21 years agoUpdate for port freebsd/alpha.
Bruce Momjian [Sun, 26 Oct 2003 00:00:40 +0000 (00:00 +0000)]
Update for port freebsd/alpha.

21 years agoGet Tru64/cc to compile. Need to add -ieee so that it doesn't choke on
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.

21 years agoTranslation update
Peter Eisentraut [Sat, 25 Oct 2003 18:18:19 +0000 (18:18 +0000)]
Translation update

21 years agoTranslation updates
Peter Eisentraut [Sat, 25 Oct 2003 18:03:21 +0000 (18:03 +0000)]
Translation updates

21 years agoFix CFLAGS selection to actually work. Add test to detect whether gcc's
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.

21 years agoRemove socket credentials defines not referenced.
Bruce Momjian [Sat, 25 Oct 2003 03:48:47 +0000 (03:48 +0000)]
Remove socket credentials defines not referenced.

21 years agoUpdate Netbsd/i386 port.
Bruce Momjian [Sat, 25 Oct 2003 03:23:47 +0000 (03:23 +0000)]
Update Netbsd/i386 port.

21 years agoUpdate ports for Solaris.
Bruce Momjian [Sat, 25 Oct 2003 03:17:43 +0000 (03:17 +0000)]
Update ports for Solaris.

21 years agoRemove weird test in ccsym
Bruce Momjian [Fri, 24 Oct 2003 21:28:52 +0000 (21:28 +0000)]
Remove weird test in ccsym

21 years agoUpdate openbsd port.
Bruce Momjian [Fri, 24 Oct 2003 21:09:08 +0000 (21:09 +0000)]
Update openbsd port.

21 years agoDon't reference pthread.h unless we have threads enabled, per Peter.
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.

21 years agoUpdate for osX 10.3.
Bruce Momjian [Fri, 24 Oct 2003 20:44:19 +0000 (20:44 +0000)]
Update for osX 10.3.

21 years agoUpdate ports for freebsd, cygwin.
Bruce Momjian [Fri, 24 Oct 2003 20:39:09 +0000 (20:39 +0000)]
Update ports for freebsd, cygwin.

21 years agoUse AROPT, not hard-coded flags.
Peter Eisentraut [Fri, 24 Oct 2003 20:31:43 +0000 (20:31 +0000)]
Use AROPT, not hard-coded flags.

21 years agoUpdate Linux/Sparc 32-bit port.
Bruce Momjian [Fri, 24 Oct 2003 16:30:53 +0000 (16:30 +0000)]
Update Linux/Sparc 32-bit port.

21 years agoUpdate Linux x86 port.
Bruce Momjian [Fri, 24 Oct 2003 16:29:00 +0000 (16:29 +0000)]
Update Linux x86 port.

21 years agoUpdate OSX port.
Bruce Momjian [Fri, 24 Oct 2003 15:56:29 +0000 (15:56 +0000)]
Update OSX port.

21 years agoMark BSD/OS as working in 7.4.
Bruce Momjian [Fri, 24 Oct 2003 15:31:29 +0000 (15:31 +0000)]
Mark BSD/OS as working in 7.4.

21 years agoMove pre-7.3 platforms to unsupported.
Bruce Momjian [Fri, 24 Oct 2003 15:30:52 +0000 (15:30 +0000)]
Move pre-7.3 platforms to unsupported.

21 years agoTranslation updates
Peter Eisentraut [Fri, 24 Oct 2003 12:07:56 +0000 (12:07 +0000)]
Translation updates

21 years agoMove 2phase discussion to 7.5 queue, not TODO.detail.
Bruce Momjian [Fri, 24 Oct 2003 03:24:56 +0000 (03:24 +0000)]
Move 2phase discussion to 7.5 queue, not TODO.detail.