OSDN Git Service
Bruce Momjian [Fri, 8 Aug 2003 03:18:40 +0000 (03:18 +0000)]
Cleanup.
Bruce Momjian [Fri, 8 Aug 2003 03:09:56 +0000 (03:09 +0000)]
Typo cleanup.
Bruce Momjian [Fri, 8 Aug 2003 03:03:54 +0000 (03:03 +0000)]
Makefile cleanup.
Bruce Momjian [Fri, 8 Aug 2003 03:00:31 +0000 (03:00 +0000)]
More thread.c cleanup.
Bruce Momjian [Fri, 8 Aug 2003 02:55:08 +0000 (02:55 +0000)]
More threading cleanups.
Bruce Momjian [Fri, 8 Aug 2003 02:48:24 +0000 (02:48 +0000)]
more thread.c consistency.
Bruce Momjian [Fri, 8 Aug 2003 02:46:40 +0000 (02:46 +0000)]
threads.c -> thread.c, be consistent.
Bruce Momjian [Fri, 8 Aug 2003 02:00:20 +0000 (02:00 +0000)]
Update done items:
< * Allow elog() to return error codes, module name, file name, line
< number, not just messages (Peter E)
< * Add error codes (Peter E)
< * Make error messages more consistent [error]
> * -Allow elog() to return error codes, module name, file name, line
> number, not just messages (Tom)
> * -Add error codes (Tom)
> * -Make error messages more consistent
40c40
< * Add GUC log_statement_and_duration to print statement and >= min duration
> * -Add GUC log_statement_and_duration to print statement and >= min duration
84c84
< * Allow current datestyle to restrict dates; prevent month/day swapping
> * -Allow current datestyle to restrict dates; prevent month/day swapping
86c86
< * Prevent month/day swapping of ISO dates to make invalid dates valid
> * -Prevent month/day swapping of ISO dates to make invalid dates valid
88c88
< * Delay resolution of array expression type so assignment coercion
> * -Delay resolution of array expression type so assignment coercion
93c93
< o Allow arrays to be ORDER'ed
> o -Allow arrays to be ORDER'ed
116c116
< * Remove Cyrillic recode support
> * -Remove Cyrillic recode support
144c144
< * Certain indexes will not shrink, e.g. indexes on ever-increasing
> * -Certain indexes will not shrink, e.g. indexes on ever-increasing
185c185
< * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle
> * -Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle
196c196
< o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod)
> o --Add ALTER TABLE tab SET WITHOUT OIDS (Rod)
221c221
< stored in the backend
> stored in the backend (Gavin)
235c235
< o Allow EXPLAIN EXECUTE to see prepared plans
> o -Allow EXPLAIN EXECUTE to see prepared plans
241d240
< o Add untrusted version of plpython
265c264
< * Allow psql to show transaction status if backend protocol changes made
> * -Allow psql to show transaction status if backend protocol changes made
272,
273c271,272
< * Modify pg_get_triggerdef() to take a boolean to pretty-print,
< and use that as part of pg_dump along with psql
> * -Modify pg_get_triggerdef() to take a boolean to pretty-print,
> and use that as part of pg_dump along with psql
292c291
< o Add SQLSTATE
> o -Add SQLSTATE
296c295
< o Implement SQLDA (do we really need this?)
> o -Implement SQLDA
364d362
< * Allow binding query args over FE/BE protocol
378c376,377
< * Provide automatic running of vacuum in the background (Tom) [vacuum]
> * Provide automatic running of vacuum in the background in backend
> rather than in /contrib [vacuum]
427c426
< * Allow Subplans to use efficient joins(hash, merge) with upper variable
> * -Allow Subplans to use efficient joins(hash, merge) with upper variable
429c428
< * Allow merge and hash joins on expressions not just simple variables (Tom)
> * -Allow merge and hash joins on expressions not just simple variables (Tom)
474c473
< * Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)
> * Remove memory/file descriptor freeing before ereport(ERROR) (Bruce)
489,
490c488,489
< o Show transaction status in psql
< o Allow binding of query parameters, support for prepared queries
> o -Show transaction status in psql
> o -Allow binding of query parameters, support for prepared queries
492,
494c491,493
< o Remove hard-coded limits on user/db/password names
< o Remove unused elements of startup packet (unused, tty, passlength)
< o Fix COPY/fastpath protocol?
> o -Remove hard-coded limits on user/db/password names
> o -Remove unused elements of startup packet (unused, tty, passlength)
> o -Fix COPY/fastpath protocol
496,
497c495
< o Replication support?
< o Error codes
> o -Error codes
500d497
< o ecpg improvements?
503c500
< o Report server version number, database encoding, client encoding
> o -Report server version number, database encoding, client encoding
Bruce Momjian [Fri, 8 Aug 2003 01:21:02 +0000 (01:21 +0000)]
Remove space between function name and opening paren in pg_dump, for
clarity.
Bruce Momjian [Fri, 8 Aug 2003 00:28:26 +0000 (00:28 +0000)]
No need for TODO.detail error.
Tom Lane [Fri, 8 Aug 2003 00:10:31 +0000 (00:10 +0000)]
Fix floating-point timestamp comparisons to not go nuts if NaN is
encountered; per bug report from Christian van der Leeden 8/7/03.
Also, adjust larger/smaller routines (MAX/MIN) to share code with
comparisons for timestamp, interval, timetz.
Bruce Momjian [Thu, 7 Aug 2003 23:43:32 +0000 (23:43 +0000)]
Clean up function header.
Tom Lane [Thu, 7 Aug 2003 21:38:55 +0000 (21:38 +0000)]
Fix typo.
Tom Lane [Thu, 7 Aug 2003 21:11:58 +0000 (21:11 +0000)]
Don't assume that struct option is available just because we can find a
getopt_long(). This is more or less the same problem as we saw earlier
with getaddrinfo() and struct addrinfo, and for the same reason: random
user-added libraries might contain the subroutine, but there's no
guarantee we will find the matching header files.
Tom Lane [Thu, 7 Aug 2003 19:37:13 +0000 (19:37 +0000)]
SCO_ACCEPT_BUG code didn't get updated for new SockAddr struct definition.
Tom Lane [Thu, 7 Aug 2003 19:20:24 +0000 (19:20 +0000)]
create_unique_plan() should not discard existing output columns of the
subplan it starts with, as they may be needed at upper join levels.
See comments added to code for the non-obvious reason why. Per bug report
from Robert Creager.
Tom Lane [Thu, 7 Aug 2003 16:45:21 +0000 (16:45 +0000)]
Don't use HAVE_STRUCT_ADDRINFO as a guide to whether netdb.h defines
macros like AI_NUMERICHOST; instead, test the macros individually.
Should fix recent reports of trouble on AIX and Unixware.
Bruce Momjian [Thu, 7 Aug 2003 16:37:31 +0000 (16:37 +0000)]
Make table column type TEXT.
Bruce Momjian [Thu, 7 Aug 2003 16:14:03 +0000 (16:14 +0000)]
Add iteration option to thread test program.
Bruce Momjian [Thu, 7 Aug 2003 15:02:43 +0000 (15:02 +0000)]
Update pgindent readme.
Tom Lane [Thu, 7 Aug 2003 14:36:31 +0000 (14:36 +0000)]
Remove unnecessary use of multiple cat processes to feed psql; this
reduces the number of concurrent processes launched during parallel
regression tests, possibly avoiding failures such as exceeding a user's
max number of processes. This essentially completes the reversion
of 1.27->1.28.
Bruce Momjian [Thu, 7 Aug 2003 14:12:50 +0000 (14:12 +0000)]
Move dollar sign items to object section.
Bruce Momjian [Thu, 7 Aug 2003 05:18:14 +0000 (05:18 +0000)]
Update typedef names for pgindent 7.4.
Bruce Momjian [Thu, 7 Aug 2003 05:12:00 +0000 (05:12 +0000)]
Update ecpg thread testing program to be more automated.
Barry Lind [Thu, 7 Aug 2003 05:06:40 +0000 (05:06 +0000)]
markup fixes
Bruce Momjian [Thu, 7 Aug 2003 04:44:26 +0000 (04:44 +0000)]
Include postgres_ext.h instead of postgres_fe.h. This allows ecpg
output C files to proper compile again.
Bruce Momjian [Thu, 7 Aug 2003 04:17:21 +0000 (04:17 +0000)]
Noticed broken markup in ecpg.sgml. Attached patch fixes it. Please
apply.
Joe Conway
Bruce Momjian [Thu, 7 Aug 2003 04:03:18 +0000 (04:03 +0000)]
Add -lm for ecpg/pgtypeslib/Makefile link so -lm isn't required for ecpg
compiles.
Barry Lind [Thu, 7 Aug 2003 04:03:13 +0000 (04:03 +0000)]
Sometimes the third time is the charm. Third try to fix the sql injection
vulnerability. This fix completely removes the ability (hack) of being able
to bind a list of values in an in clause. It was demonstrated that by allowing
that functionality you open up the possibility for certain types of
sql injection attacks. The previous fix attempts all focused on preventing
the insertion of additional sql statements (the semi-colon problem:
xxx; any new sql statement here). But that still left the ability to
change the where clause on the current statement or perform a subselect
which can circumvent applicaiton security logic and/or allow you to call
any stored function.
Modified Files:
jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
Bruce Momjian [Thu, 7 Aug 2003 03:59:25 +0000 (03:59 +0000)]
Update release items from Tom.
Barry Lind [Wed, 6 Aug 2003 23:50:19 +0000 (23:50 +0000)]
Applied doc patch for the jdbc docs submitted by Nic Ferrier for functionality
he supplied a few months ago, but didn't get around to docing until now. And
he also added some doc for calling stored functions in general from jdbc that was missing.
Modified Files:
sgml/jdbc.sgml
Bruce Momjian [Wed, 6 Aug 2003 23:36:02 +0000 (23:36 +0000)]
Add:
> o Add ALTER DATABASE ... OWNER TO newowner
Tom Lane [Wed, 6 Aug 2003 17:46:46 +0000 (17:46 +0000)]
Rename fields of DestReceiver to avoid collisions with (ill-considered)
macros in some platforms' sys/socket.h.
Tom Lane [Wed, 6 Aug 2003 16:43:43 +0000 (16:43 +0000)]
Adopt a random backoff algorithm for sleep delays when waiting for a
spinlock. Per recent pghackers discussion.
Tom Lane [Wed, 6 Aug 2003 15:54:06 +0000 (15:54 +0000)]
Fix compiler-detected problem for Alphas: it seems strlen returns
something wider than int on that platform. Also, remove bogus
assumption that sizeof("INT_MAX") has something to do with the maximum
number of digits in an int.
Teodor Sigaev [Wed, 6 Aug 2003 14:53:01 +0000 (14:53 +0000)]
OpenFTS vs Tsearch2 comment
Teodor Sigaev [Wed, 6 Aug 2003 09:41:13 +0000 (09:41 +0000)]
Add documentation about ts_debug
Teodor Sigaev [Wed, 6 Aug 2003 09:19:21 +0000 (09:19 +0000)]
Add ts_debug function for debugging configurations
Barry Lind [Wed, 6 Aug 2003 05:53:13 +0000 (05:53 +0000)]
Applied patch from kho@redhat.com to fix a problem with trying to use a fetch
when a cursor wasn't being used.
Modified Files:
jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
Bruce Momjian [Wed, 6 Aug 2003 02:19:51 +0000 (02:19 +0000)]
Add ecpg thread testing file.
Tom Lane [Tue, 5 Aug 2003 18:30:21 +0000 (18:30 +0000)]
Improve documentation of ParseDateTime(). Reorder tests to prevent
writing one more value into return arrays than will fit. This is
potentially a stack smash, though I do not think it is a problem in
current uses of the routine, since a failure return causes elog anyway.
Tom Lane [Tue, 5 Aug 2003 17:39:19 +0000 (17:39 +0000)]
Fix several places where fractional-second inputs were misprocessed
in HAVE_INT64_TIMESTAMP cases, including two potential stack smashes
when more than six fractional digits were supplied. Per bug report
from Philipp Reisner.
Bruce Momjian [Tue, 5 Aug 2003 15:31:33 +0000 (15:31 +0000)]
Modify:
Prevent interval from supressing ':00' seconds display
Bruce Momjian [Tue, 5 Aug 2003 15:04:16 +0000 (15:04 +0000)]
Remove Tom mention on array items.
Bruce Momjian [Tue, 5 Aug 2003 14:37:49 +0000 (14:37 +0000)]
Add mention of :00 seconds.
Bruce Momjian [Tue, 5 Aug 2003 14:35:12 +0000 (14:35 +0000)]
Update thread wording.
Bruce Momjian [Tue, 5 Aug 2003 14:33:30 +0000 (14:33 +0000)]
Modify tsearch2 to be Oleg,Teodor
Bruce Momjian [Tue, 5 Aug 2003 05:07:50 +0000 (05:07 +0000)]
Add tsearch2 mention.
Bruce Momjian [Tue, 5 Aug 2003 05:04:50 +0000 (05:04 +0000)]
Add Philip Yarra to threads item, remove my name.
Bruce Momjian [Tue, 5 Aug 2003 05:01:50 +0000 (05:01 +0000)]
Update release items from Joe Conway.
PostgreSQL Daemon [Tue, 5 Aug 2003 04:55:58 +0000 (04:55 +0000)]
can't mix and match .gz and .bz2 in here ... won't build
PostgreSQL Daemon [Tue, 5 Aug 2003 04:40:29 +0000 (04:40 +0000)]
seeing if building bz2 distributions actually works ...
PostgreSQL Daemon [Tue, 5 Aug 2003 04:18:51 +0000 (04:18 +0000)]
remove src/data from target list
Bruce Momjian [Tue, 5 Aug 2003 03:30:35 +0000 (03:30 +0000)]
Remove MOVE ALL item.
Tom Lane [Mon, 4 Aug 2003 23:59:41 +0000 (23:59 +0000)]
Fix some copyright notices that weren't updated. Improve copyright tool
so it won't miss 'em again.
PostgreSQL Daemon [Mon, 4 Aug 2003 22:30:30 +0000 (22:30 +0000)]
change tag to 7.4beta1 and update the Copyright to 2003
Guess what folks? We are now in Beta!!
Tom Lane [Mon, 4 Aug 2003 22:03:39 +0000 (22:03 +0000)]
Update vacuumlo to be properly schema-aware. Improve documentation.
Bruce Momjian [Mon, 4 Aug 2003 21:26:26 +0000 (21:26 +0000)]
Re-add USE_THREADS, used by ecpg.
Tom Lane [Mon, 4 Aug 2003 20:52:48 +0000 (20:52 +0000)]
Fix erroneous direct reference to postgres.tar.gz, per bug report
from Garrick Staples.
Tom Lane [Mon, 4 Aug 2003 20:34:26 +0000 (20:34 +0000)]
Sub-Makefiles need to explicitly add CFLAGS_SL to CFLAGS, else their
object files do not get built with -fpic.
Tom Lane [Mon, 4 Aug 2003 19:52:37 +0000 (19:52 +0000)]
Fix to build correctly outside source tree.
Tom Lane [Mon, 4 Aug 2003 19:10:40 +0000 (19:10 +0000)]
Must print server's failure message before trying reconnect, not after.
Tom Lane [Mon, 4 Aug 2003 18:40:50 +0000 (18:40 +0000)]
Fix pltcl and plpython to support STATEMENT triggers.
Joe Conway
Tom Lane [Mon, 4 Aug 2003 17:58:14 +0000 (17:58 +0000)]
SSL_read/SSL_write do not approximate the return conventions of recv()
and send() very well at all; and in any case we can't use retval==0
for EOF due to race conditions. Make the same fixes in the backend as
are required in libpq.
Tom Lane [Mon, 4 Aug 2003 17:25:14 +0000 (17:25 +0000)]
Fix some more problems with testing error returns from SSL.
Bruce Momjian [Mon, 4 Aug 2003 16:48:03 +0000 (16:48 +0000)]
Fix thread handling in configure.
Tom Lane [Mon, 4 Aug 2003 15:28:33 +0000 (15:28 +0000)]
Minor cleanups in S_LOCK_TEST code.
Tom Lane [Mon, 4 Aug 2003 15:06:45 +0000 (15:06 +0000)]
HPUX's horology behavior is OS-dependent, not hardware-dependent.
Teodor Sigaev [Mon, 4 Aug 2003 14:54:47 +0000 (14:54 +0000)]
make sub-Makefiles in the sub-directories
Teodor Sigaev [Mon, 4 Aug 2003 14:11:08 +0000 (14:11 +0000)]
Docs fixes
Peter Eisentraut [Mon, 4 Aug 2003 14:01:37 +0000 (14:01 +0000)]
Translation updates
Peter Eisentraut [Mon, 4 Aug 2003 14:00:14 +0000 (14:00 +0000)]
Add a note that AND and OR are commutative. Apparently, they are not in
certain other products.
Tom Lane [Mon, 4 Aug 2003 04:03:10 +0000 (04:03 +0000)]
Remove --enable-recode feature, since it's been broken by IPv6 changes,
and seems to have too few users to justify maintaining.
Bruce Momjian [Mon, 4 Aug 2003 02:40:20 +0000 (02:40 +0000)]
Update copyrights to 2003.
Bruce Momjian [Mon, 4 Aug 2003 02:27:25 +0000 (02:27 +0000)]
Fix for 2003 again.
Bruce Momjian [Mon, 4 Aug 2003 02:22:37 +0000 (02:22 +0000)]
Update copyright script for 2003.
Tom Lane [Mon, 4 Aug 2003 01:57:58 +0000 (01:57 +0000)]
Put back braces removed by pgindent (not really pgindent's fault).
Bruce Momjian [Mon, 4 Aug 2003 00:43:34 +0000 (00:43 +0000)]
pgindent run.
Bruce Momjian [Mon, 4 Aug 2003 00:26:49 +0000 (00:26 +0000)]
Remove extra paren in NOT_USED code, found by pgindent.
Tom Lane [Sun, 3 Aug 2003 23:46:37 +0000 (23:46 +0000)]
Tighten inline_function's test for overly complex parameters. This
should catch most situations where repeated inlining blows up the
expression complexity unreasonably, as in Joe Conway's recent example.
Tom Lane [Sun, 3 Aug 2003 23:44:44 +0000 (23:44 +0000)]
Reconsider context for calling callback functions --- original idea
that they aren't part of error processing is clearly faulty.
Bruce Momjian [Sun, 3 Aug 2003 23:27:24 +0000 (23:27 +0000)]
Update comments.
Bruce Momjian [Sun, 3 Aug 2003 23:26:05 +0000 (23:26 +0000)]
Update HISTORY file for 7.4.
Tom Lane [Sun, 3 Aug 2003 20:23:14 +0000 (20:23 +0000)]
Don't pull in libbind except on BeOS, per pgsql-bugs discussion around
12 Jun 2003.
Bruce Momjian [Sat, 2 Aug 2003 02:44:38 +0000 (02:44 +0000)]
Remove docs that say psql \encoding doesn't track SET client_encoding.
Tom Lane [Fri, 1 Aug 2003 23:40:10 +0000 (23:40 +0000)]
Comment out entries for IPv6 localhost connections, since they fail
on machines with no IPv6 support.
Tom Lane [Fri, 1 Aug 2003 23:25:00 +0000 (23:25 +0000)]
Postmaster erroneously rejected SSL connections on IPv6.
Tom Lane [Fri, 1 Aug 2003 23:24:28 +0000 (23:24 +0000)]
Fix some unprotected references to AF_UNIX ... wouldn't compile on
platforms without AF_UNIX sockets.
Tom Lane [Fri, 1 Aug 2003 23:22:52 +0000 (23:22 +0000)]
inet_recv() wasn't IPv6-ready.
Bruce Momjian [Fri, 1 Aug 2003 22:18:15 +0000 (22:18 +0000)]
Update, add Greg:
< * Fernando Nasser <fnasser@redhat.com> of Red Hat
< * Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering
> * Fernando is Fernando Nasser <fnasser@redhat.com> of Red Hat
> * Gavin is Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering
> * Greg is Greg Sabino Mullane <greg@turnstep.com>
Bruce Momjian [Fri, 1 Aug 2003 21:44:05 +0000 (21:44 +0000)]
Add:
<
> o Allow PL/pgSQL EXECUTE query_var INTO record_var;
Tom Lane [Fri, 1 Aug 2003 21:27:27 +0000 (21:27 +0000)]
Code review for sslmode patch: eliminate memory leak, avoid giving a
completely useless error message in 'allow' case, don't retry connection
at the sendauth stage (by then the server will either let us in or not,
no point in wasting cycles on another try in the other SSL state).
Tom Lane [Fri, 1 Aug 2003 19:12:52 +0000 (19:12 +0000)]
Since HPUX now exists for Itanium, we should decouple the assumption
that OS=hpux is the same as CPU=hppa. First steps at doing this.
With these patches, we still work on hppa with either gcc or HP's cc.
We might work on hpux/itanium with gcc, but I can't test it. Definitely
will not work on hpux/itanium with non-gcc compiler, for lack of spinlock
code.
Tom Lane [Fri, 1 Aug 2003 19:01:49 +0000 (19:01 +0000)]
Get the include ordering right for TCL includes vs whatever is coming
from --with-includes.
Michael Meskes [Fri, 1 Aug 2003 18:19:03 +0000 (18:19 +0000)]
Missed two places to replace union member.
Tom Lane [Fri, 1 Aug 2003 18:10:43 +0000 (18:10 +0000)]
Fix a few of the more blatantly unportable constructs in this file.
Tom Lane [Fri, 1 Aug 2003 18:03:57 +0000 (18:03 +0000)]
Fix inconsistent static-vs-not-static declarations.
Tom Lane [Fri, 1 Aug 2003 16:46:06 +0000 (16:46 +0000)]
Fix compile warning.
Peter Eisentraut [Fri, 1 Aug 2003 16:19:14 +0000 (16:19 +0000)]
Russian translation updates by Serguei Mokhov
Peter Eisentraut [Fri, 1 Aug 2003 16:18:04 +0000 (16:18 +0000)]
Use only two-part shared library version numbers, for better portability
and consistency.