OSDN Git Service
Peter Eisentraut [Fri, 1 Mar 2002 22:17:10 +0000 (22:17 +0000)]
array_ref() should set isNull to false explicitly if it's not going to
return NULL.
Tom Lane [Fri, 1 Mar 2002 20:50:20 +0000 (20:50 +0000)]
Fix thinko: cost_mergejoin must pay attention to which side of the
mergeclause is which when extracting selectivity info.
Bruce Momjian [Fri, 1 Mar 2002 20:38:12 +0000 (20:38 +0000)]
Revert quotes, 7.2 doesn't need them for CREATE FUNCTION.
Bruce Momjian [Fri, 1 Mar 2002 19:01:22 +0000 (19:01 +0000)]
Oops, we didn't have single quotes around 'langname' in CREATE FUNCTION
manual page; pointed out by IRC user.
Hiroshi Inoue [Fri, 1 Mar 2002 07:18:34 +0000 (07:18 +0000)]
Add files for Unicode support.
Tom Lane [Fri, 1 Mar 2002 06:01:20 +0000 (06:01 +0000)]
Second thoughts dept: arrange to cache mergejoin scan selectivity
in RestrictInfo nodes, instead of recomputing on every use.
Tom Lane [Fri, 1 Mar 2002 04:09:28 +0000 (04:09 +0000)]
Teach planner about the idea that a mergejoin won't necessarily read
both input streams to the end. If one variable's range is much less
than the other, an indexscan-based merge can win by not scanning all
of the other table. Per example from Reinhard Max.
Tom Lane [Wed, 27 Feb 2002 23:16:07 +0000 (23:16 +0000)]
Tweak pg_exec_query_string so that we close down transaction command
before reporting command-complete message for the final command of a
query string. This way, any errors detected during finish_xact_command
(such as RI violations) will appear to be part of the final command,
rather than coming out after the command is reported complete. This
avoids confusing PQendcopy and other not-overly-bright clients.
Per Lee Harr's bug report of 25-Feb-02.
Peter Eisentraut [Wed, 27 Feb 2002 21:14:54 +0000 (21:14 +0000)]
Some cleanups in CREATE/ALTER/DROP USER ref pages.
Tom Lane [Wed, 27 Feb 2002 20:59:05 +0000 (20:59 +0000)]
#ifdef out pg_dump's check on whether a sequence's sequence_name field
matches the sequence name from pg_class. This fails if the sequence has
been renamed, and seems rather pointless in any case.
Also improve a couple of error messages about inconsistencies.
Tom Lane [Wed, 27 Feb 2002 19:52:41 +0000 (19:52 +0000)]
Paranoia about data structure lifetime ...
Tom Lane [Wed, 27 Feb 2002 19:36:13 +0000 (19:36 +0000)]
Clean up BeginCommand and related routines. BeginCommand and EndCommand
are now both invoked once per received SQL command (raw parsetree) from
pg_exec_query_string. BeginCommand is actually just an empty routine
at the moment --- all its former operations have been pushed into tuple
receiver setup routines in printtup.c. This makes for a clean distinction
between BeginCommand/EndCommand (once per command) and the tuple receiver
setup/teardown routines (once per ExecutorRun call), whereas the old code
was quite ad hoc. Along the way, clean up the calling conventions for
ExecutorRun a little bit.
Bruce Momjian [Wed, 27 Feb 2002 04:52:19 +0000 (04:52 +0000)]
Update FAQ.
Hiroshi Inoue [Wed, 27 Feb 2002 01:43:24 +0000 (01:43 +0000)]
Improve the handling of ODBC escape(a request from Marcelo Aceto).
Change SQLGetFunctions() to reply not yet implemented ODBC 3.0
functions precisely.
Tatsuo Ishii [Wed, 27 Feb 2002 01:34:41 +0000 (01:34 +0000)]
Fix bug in COPY FROM when DELIMITER is not in ASCII range.
See pgsql-bugs/pgsql-hackers discussion "COPY FROM is not 8bit clean"
around 2002/02/26 for more details -- Tatsuo Ishii
Tom Lane [Tue, 26 Feb 2002 22:47:12 +0000 (22:47 +0000)]
Restructure command-completion-report code so that there is just one
report for each received SQL command, regardless of rewriting activity.
Also ensure that this report comes from the 'original' command, not the
last command generated by rewrite; this fixes 7.2 breakage for INSERT
commands that have actions added by rules. Fernando Nasser and Tom Lane.
Tom Lane [Tue, 26 Feb 2002 15:59:08 +0000 (15:59 +0000)]
Correct typo noticed by Christopher Kings-Lynne.
Dave Cramer [Tue, 26 Feb 2002 02:15:55 +0000 (02:15 +0000)]
Implementation for cancelQuery by Grant Finnemore <grantf@guruhut.co.za>
Tom Lane [Tue, 26 Feb 2002 00:00:08 +0000 (00:00 +0000)]
Use quote-marks to try to clarify a plpgsql error message, per
gripe from Dan Langille.
Tom Lane [Mon, 25 Feb 2002 21:37:42 +0000 (21:37 +0000)]
Tweak psql's \connect command to not downcase unquoted database and user
names. This is a temporary measure to allow backwards compatibility with
7.2 and earlier pg_dump. 7.2.1 and later pg_dump will double-quote mixed
case names in \connect. Once we feel that older dumps are not a problem
anymore, we can revert this change and treat \connect arguments as normal
SQL identifiers.
Bruce Momjian [Mon, 25 Feb 2002 20:30:19 +0000 (20:30 +0000)]
Added:
> * Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)
Bruce Momjian [Mon, 25 Feb 2002 20:29:39 +0000 (20:29 +0000)]
Update FAQ_DEV.
Bruce Momjian [Mon, 25 Feb 2002 20:29:22 +0000 (20:29 +0000)]
Update FAQ.
Bruce Momjian [Mon, 25 Feb 2002 20:07:02 +0000 (20:07 +0000)]
Fix for PAM error message display:
> and that the right fix is to make each of the subsequent calls be in
> this same pattern, not to try to emulate their nonsensical style.
Dominic J. Eidson
Bruce Momjian [Mon, 25 Feb 2002 18:48:54 +0000 (18:48 +0000)]
Add items and JDBC maintainers:
> o Add LISTEN/NOTIFY support to the JDBC driver (Barry)
479a481
> * Barry is Barry Lind <barry@xythos.com>
482a485
> * Dave is Dave Cramer <dave@fastcrypt.com>
Tom Lane [Mon, 25 Feb 2002 17:11:22 +0000 (17:11 +0000)]
Add note that BLCKSZ must be a power of 2.
Thomas G. Lockhart [Mon, 25 Feb 2002 16:17:04 +0000 (16:17 +0000)]
Add a large number of time zones to the lookup table.
Fix a few apparently-wrong TZ vs DTZ declarations.
Bruce Momjian [Mon, 25 Feb 2002 06:23:54 +0000 (06:23 +0000)]
Update completed items:
> * -Prevent SIGHUP and 'pg_ctl reload' from changing command line
> * -Remove LIMIT #,# and force use LIMIT and OFFSET clauses in 7.3 (Bruce)
> * -Prevent create/drop scripts from allowing extra args (Bruce)
> * -Have pg_dump -C dump database location and encoding information
Bruce Momjian [Mon, 25 Feb 2002 04:21:55 +0000 (04:21 +0000)]
This patch will allow arbitrary levels of analyze / rewriting
by making the static variables extra_before and extra_after
automatic so we can use recursion.
It gets much easier to generate extra commands now, and one can rest
assured that the extra commands will be properly analyzed/rewritten.
Without this patch, if a command produced by transformation tries to
use these static lists their first contents would be lost with
unpredictable results. I know I could fix this by just using nconc()
instead of assignments, but the resulting order of the commands would
not be exactly what one could expect.
--
Fernando Nasser
Tom Lane [Mon, 25 Feb 2002 04:16:58 +0000 (04:16 +0000)]
Try to make makefile actually work ...
Bruce Momjian [Mon, 25 Feb 2002 04:08:03 +0000 (04:08 +0000)]
Fix typo in Makefile.
Bruce Momjian [Mon, 25 Feb 2002 04:06:52 +0000 (04:06 +0000)]
I've attached a simple patch which should improve the performance of
hashname() and reduce the penalty incured when NAMEDATALEN is increased.
I posted this to -hackers a couple days ago, and there haven't been any
major complaints. It passes the regression tests. See -hackers for more
discussion, as well as the suggestion from Tom Lane on which this patch
is based.
Unless anyone sees any problems, please apply for 7.3.
Cheers,
Neil Conway
Bruce Momjian [Mon, 25 Feb 2002 03:59:39 +0000 (03:59 +0000)]
Fix typo in filename.
Bruce Momjian [Mon, 25 Feb 2002 03:45:27 +0000 (03:45 +0000)]
Add integer aggregator to /contrib.
mlw
Bruce Momjian [Mon, 25 Feb 2002 03:37:36 +0000 (03:37 +0000)]
*** empty log message ***
Bruce Momjian [Mon, 25 Feb 2002 03:37:14 +0000 (03:37 +0000)]
Re-add equals documentation with CREATE DATABASE.
Bruce Momjian [Mon, 25 Feb 2002 02:53:46 +0000 (02:53 +0000)]
Remove documentation of equals in CREATE DATABASE. Mention removal of
equals hack for the future.
Tom Lane [Sun, 24 Feb 2002 23:59:36 +0000 (23:59 +0000)]
Fix bogus createdb option syntax recommended by initlocation message.
Tom Lane [Sun, 24 Feb 2002 23:55:31 +0000 (23:55 +0000)]
Fix copy-and-paste typo.
Tom Lane [Sun, 24 Feb 2002 23:27:58 +0000 (23:27 +0000)]
Add -O/--owner switch to createdb script, in support of new OWNER option
for CREATE DATABASE.
Tom Lane [Sun, 24 Feb 2002 21:57:23 +0000 (21:57 +0000)]
Modify pg_dumpall so that output script uses new OWNER option of CREATE
DATABASE; also make it use SET SESSION AUTHORIZATION commands rather than
\connect commands. This makes it possible to restore databases belonging
to users who do not have CREATEDB privilege. It should also become at
least somewhat feasible to run the restore script under password
authentication --- you'll get one superuser password prompt per database,
rather than a large number of challenges for passwords belonging to
varying unspecified user names.
Tom Lane [Sun, 24 Feb 2002 20:20:21 +0000 (20:20 +0000)]
Add OWNER option to CREATE DATABASE, so superusers can create databases
on behalf of unprivileged users. Also, make '=' optional in CREATE
DATABASE syntax. From Gavin Sherry, with kibitzing and docs by Tom Lane.
Dave Cramer [Sun, 24 Feb 2002 16:12:51 +0000 (16:12 +0000)]
compiles correctly but still doesn't work with jdk 1.4
Bruce Momjian [Sun, 24 Feb 2002 02:33:33 +0000 (02:33 +0000)]
pgindent copy.c. Patch wasn't in proper format.
Bruce Momjian [Sun, 24 Feb 2002 02:32:26 +0000 (02:32 +0000)]
Free files on dir open failure in COPY.
Tatsuo Ishii [Sun, 24 Feb 2002 00:17:57 +0000 (00:17 +0000)]
Add -N option which disables updation of branches and tellers tables.
So there would be less contention with -N, that might be more realistic
test.
Bruce Momjian [Sat, 23 Feb 2002 21:53:37 +0000 (21:53 +0000)]
Added:
> * Add checks for missing parameters to shell script, to prevent
> over-shifting
Bruce Momjian [Sat, 23 Feb 2002 21:49:10 +0000 (21:49 +0000)]
OK'ed by Peter.
The attached patch enables plperl to build under Cygwin. It is
basically yet another BE_DLLLIBS patch with a perl MakeMaker twist. I
tried the patch under Red Hat 7.1 Linux too and I did not observe any
ill effects.
Jason Tishler
Bruce Momjian [Sat, 23 Feb 2002 21:46:03 +0000 (21:46 +0000)]
Add fstat / S_ISDIR checks to make sure we're not trying to use a
directory for COPY TO/FROM.
Brent Verner
Bruce Momjian [Sat, 23 Feb 2002 21:25:35 +0000 (21:25 +0000)]
Feature patch per prev thread for --with-tcl, only affects AIX
patch is low risc, thus could be applied now, but can also wait for 7.3
Old Makefile shows, that -bnoentry is available since 4.1 .
Andreas Zeugswetter
Tom Lane [Sat, 23 Feb 2002 20:55:46 +0000 (20:55 +0000)]
Guard against createdb --location=PGDATA foo; without this, the code
tries to create a symlink pointing at itself. Per trouble report from
Kenneth McDowell.
Bruce Momjian [Sat, 23 Feb 2002 20:09:40 +0000 (20:09 +0000)]
Update FAQ_DEV.
Bruce Momjian [Sat, 23 Feb 2002 05:06:04 +0000 (05:06 +0000)]
Add type conversion discussion.
Peter Eisentraut [Sat, 23 Feb 2002 04:17:47 +0000 (04:17 +0000)]
Heimdal support (Kerberos V implementation from KTH)
Peter Eisentraut [Sat, 23 Feb 2002 04:16:04 +0000 (04:16 +0000)]
Add -Wno-error to CFLAGS, so the rest of the tree can compile with
-Werror.
Peter Eisentraut [Sat, 23 Feb 2002 01:31:37 +0000 (01:31 +0000)]
Save source of GUC settings, allowing different sources to be processed in
any order without affecting results.
Bruce Momjian [Sat, 23 Feb 2002 01:01:30 +0000 (01:01 +0000)]
Make factorial(0) return 1, as per spec.
Bruce Momjian [Fri, 22 Feb 2002 23:05:35 +0000 (23:05 +0000)]
I've written on like that a while ago:
http://webmail.postgresql.org/~petere/dbsize.html
The tarball can be rolled into contrib -- now that I think of it I don't
know why I never did that.
Never imagined this would have anything to do with that TODO item,
though.
I figured oid2name accomplished that.
Peter Eisentraut peter_e@gmx.net
Bruce Momjian [Fri, 22 Feb 2002 16:21:21 +0000 (16:21 +0000)]
Record for future use if we ever change the protocol:
> * Allow psql to show transaction status if backend protocol changes made
Bruce Momjian [Fri, 22 Feb 2002 15:39:42 +0000 (15:39 +0000)]
We had a problem with to compile pgsql-7.2 under SW-8.0.
In the mailing lists I found no informations.
See note for further informations.
Add missing AuthBlockSig.
regards Heiko
Bruce Momjian [Fri, 22 Feb 2002 12:48:55 +0000 (12:48 +0000)]
Add Russian FAQ from Viktor Vislobokov.
Bruce Momjian [Fri, 22 Feb 2002 05:47:50 +0000 (05:47 +0000)]
Please, apply attached patch of contrib/btree_gist to 7.2.1 and current
cvs.
The patch fixes memory leak during creation GiST index on timestamp
column.
Thank you.
--
Teodor Sigaev
teodor@stack.net
Bruce Momjian [Fri, 22 Feb 2002 05:42:44 +0000 (05:42 +0000)]
Modify:
> * Inline simple SQL functions to avoid overhead (Tom)
> * Precompile SQL functions to avoid overhead (Neil Conway)
Bruce Momjian [Fri, 22 Feb 2002 05:22:50 +0000 (05:22 +0000)]
Added:
< * Inline simple SQL functions to avoid overhead (Tom)
> * Inline simple SQL functions to avoid overhead (Neil Conway)
Bruce Momjian [Fri, 22 Feb 2002 04:19:37 +0000 (04:19 +0000)]
Add:
> * Inline simple SQL functions to avoid overhead (Tom)
Dave Cramer [Fri, 22 Feb 2002 03:22:31 +0000 (03:22 +0000)]
fixed compile error
Bruce Momjian [Fri, 22 Feb 2002 03:05:26 +0000 (03:05 +0000)]
Add NAMEDATALEN discussion.
< first, breaks notify API;
> first, breaks notify API; [namedatalen]
Bruce Momjian [Fri, 22 Feb 2002 03:04:48 +0000 (03:04 +0000)]
Add discussion.
Dave Cramer [Fri, 22 Feb 2002 02:58:24 +0000 (02:58 +0000)]
This patch fixes the exception thrown to inform the user the method
getColumnClassName(int) is not implemented. This will futher fixes method
ResultSet.getObject(int) since it requires the getColumnClassName(int) method to return the proper java class used to map the database column.
auther Ed Yu
Dave Cramer [Fri, 22 Feb 2002 02:40:09 +0000 (02:40 +0000)]
Patch from Cormac Twomey
fixes getIndexInfo throwing NullPointerException
fixes getIndexInfo improper results when multiple key indexs are used
Dave Cramer [Fri, 22 Feb 2002 02:17:13 +0000 (02:17 +0000)]
Patch from Cormac Twomey
fixes getIndexInfo throwing NullPointerException
fixes getIndexInfo improper results when multiple key indexs are used
Dave Cramer [Fri, 22 Feb 2002 02:07:30 +0000 (02:07 +0000)]
now compiles clean with jdk 1.4
Bruce Momjian [Fri, 22 Feb 2002 01:28:15 +0000 (01:28 +0000)]
Clarify:
< * Allow ability to easily build only certain interfaces (Marc)
> * Better document ability to build only certain interfaces (Marc)
Bruce Momjian [Fri, 22 Feb 2002 00:12:08 +0000 (00:12 +0000)]
More wording improvement.
Bruce Momjian [Fri, 22 Feb 2002 00:12:07 +0000 (00:12 +0000)]
Add:
> * Remove or relicense modules that are not under the BSD license, if possible
Bruce Momjian [Fri, 22 Feb 2002 00:10:11 +0000 (00:10 +0000)]
Improve wording of meaning of /contrib directory.
Bruce Momjian [Thu, 21 Feb 2002 22:58:11 +0000 (22:58 +0000)]
Update.
Bruce Momjian [Thu, 21 Feb 2002 22:56:16 +0000 (22:56 +0000)]
Update FAQ.
Bruce Momjian [Thu, 21 Feb 2002 22:42:04 +0000 (22:42 +0000)]
Small spacing cleanup.
Bruce Momjian [Thu, 21 Feb 2002 22:39:36 +0000 (22:39 +0000)]
Wrap some SQL syntax examples so \h shows them better.
Bruce Momjian [Thu, 21 Feb 2002 22:30:22 +0000 (22:30 +0000)]
Add to replication discussion.
Bruce Momjian [Thu, 21 Feb 2002 22:19:30 +0000 (22:19 +0000)]
Update FAQ.
Bruce Momjian [Thu, 21 Feb 2002 20:15:00 +0000 (20:15 +0000)]
Update FAQ.
Bruce Momjian [Thu, 21 Feb 2002 20:13:39 +0000 (20:13 +0000)]
Update FAQ.
Bruce Momjian [Thu, 21 Feb 2002 05:10:49 +0000 (05:10 +0000)]
Marc, you get this one. :-) You are the expert on the item:
> * Allow ability to easily build only certain interfaces (Marc)
Tom Lane [Wed, 20 Feb 2002 22:47:12 +0000 (22:47 +0000)]
Fix comment.
Bruce Momjian [Wed, 20 Feb 2002 03:50:33 +0000 (03:50 +0000)]
Add:
> o Allow cursors outside transactions [cursor]
Bruce Momjian [Wed, 20 Feb 2002 03:49:06 +0000 (03:49 +0000)]
Add cursors outside transactions thread.
Bruce Momjian [Wed, 20 Feb 2002 00:44:30 +0000 (00:44 +0000)]
Add savepoints discussion.
Bruce Momjian [Wed, 20 Feb 2002 00:42:01 +0000 (00:42 +0000)]
Add schema discussion.
Bruce Momjian [Tue, 19 Feb 2002 22:41:29 +0000 (22:41 +0000)]
Add:
> * Clarify use of 'application' and 'command' tags in SGML docs
Bruce Momjian [Tue, 19 Feb 2002 22:34:27 +0000 (22:34 +0000)]
Add:
> * Improve concurrency of hash indexes
> * Test hash index performance and recommend or discourage usage
Tom Lane [Tue, 19 Feb 2002 22:19:34 +0000 (22:19 +0000)]
Avoid failures in cash_out and cash_words for INT_MIN.
Also, 'fourty' -> 'forty'.
Bruce Momjian [Tue, 19 Feb 2002 21:38:29 +0000 (21:38 +0000)]
Clearify:
> * Make single-user local access permissions the default by limiting
> permissions on the socket file (Peter E)
Bruce Momjian [Tue, 19 Feb 2002 21:36:58 +0000 (21:36 +0000)]
Added:
---
> * Improve caching of attribute offsets when NULLs exist in the row
Tom Lane [Tue, 19 Feb 2002 20:45:04 +0000 (20:45 +0000)]
Add casts to suppress gcc warnings on Solaris (where apparently pid_t
is different from int).
Bruce Momjian [Tue, 19 Feb 2002 20:31:31 +0000 (20:31 +0000)]
Update as done:
> * -Cache system catalog information in per-database files (Tom)
Tom Lane [Tue, 19 Feb 2002 20:11:20 +0000 (20:11 +0000)]
A bunch of changes aimed at reducing backend startup time...
Improve 'pg_internal.init' relcache entry preload mechanism so that it is
safe to use for all system catalogs, and arrange to preload a realistic
set of system-catalog entries instead of only the three nailed-in-cache
indexes that were formerly loaded this way. Fix mechanism for deleting
out-of-date pg_internal.init files: this must be synchronized with transaction
commit, not just done at random times within transactions. Drive it off
relcache invalidation mechanism so that no special-case tests are needed.
Cache additional information in relcache entries for indexes (their pg_index
tuples and index-operator OIDs) to eliminate repeated lookups. Also cache
index opclass info at the per-opclass level to avoid repeated lookups during
relcache load.
Generalize 'systable scan' utilities originally developed by Hiroshi,
move them into genam.c, use in a number of places where there was formerly
ugly code for choosing either heap or index scan. In particular this allows
simplification of the logic that prevents infinite recursion between syscache
and relcache during startup: we can easily switch to heapscans in relcache.c
when and where needed to avoid recursion, so IndexScanOK becomes simpler and
does not need any expensive initialization.
Eliminate useless opening of a heapscan data structure while doing an indexscan
(this saves an mdnblocks call and thus at least one kernel call).
Tom Lane [Tue, 19 Feb 2002 19:54:43 +0000 (19:54 +0000)]
Remove some unnecessary pqsignal() calls to shave a few cycles off
backend startup.
Tom Lane [Tue, 19 Feb 2002 19:53:35 +0000 (19:53 +0000)]
Arrange to call localtime() during postmaster startup. On most Unixen,
the first call of localtime() in a process will read /usr/lib/tztab or
local equivalent. Better to do this once in the postmaster and inherit
the data by fork() than to have to do it during every backend start.