OSDN Git Service
Thomas G. Lockhart [Thu, 15 Apr 1999 02:20:50 +0000 (02:20 +0000)]
Fix boolean assignment of return values to use "FALSE" rather than the
mis-copied "NULL", which happens to have the same binary value.
Previously, gcc gave non-fatal warnings.
Thomas G. Lockhart [Thu, 15 Apr 1999 02:19:02 +0000 (02:19 +0000)]
Code modified to reject out of range day of month.
Previously, dates falling within Unix system time range were run through
a call to localtime() to get the time zone, if it was not specified.
This had the effect that dates with DOMs which were larger than would be
valid for that month were "rotated" into the following months.
Thomas G. Lockhart [Thu, 15 Apr 1999 02:15:36 +0000 (02:15 +0000)]
Fix error message to match that returned by new regression test reference
machine (linux-2.0.36 RH5.2 with RH5.2 patches).
Tom Lane [Thu, 15 Apr 1999 00:09:00 +0000 (00:09 +0000)]
Correct documentation of CREATE OPERATOR.
Tom Lane [Wed, 14 Apr 1999 23:48:07 +0000 (23:48 +0000)]
Correct psql's online help for CREATE OPERATOR, which did
not match what the backend actually accepts.
Tom Lane [Wed, 14 Apr 1999 23:47:19 +0000 (23:47 +0000)]
pg_dump was trying to use an incorrect (or, perhaps, only obsolete?)
syntax for CREATE OPERATOR with SORT parameters. Fixed.
It is now actually possible to dump and reload a database containing
fully specified user-definable operators ...
Michael Meskes [Wed, 14 Apr 1999 18:51:37 +0000 (18:51 +0000)]
*** empty log message ***
Marc G. Fournier [Wed, 14 Apr 1999 14:04:41 +0000 (14:04 +0000)]
use new config.guess output for system specific expected files ..
Marc G. Fournier [Wed, 14 Apr 1999 14:02:00 +0000 (14:02 +0000)]
use config.guess instead of uname -s to figure out system, so that we can
include platform spcific changes ...
thanks to Mark Hollomon <mhh@nortelnetworks.com> for the awk script used
Bruce Momjian [Tue, 13 Apr 1999 19:04:33 +0000 (19:04 +0000)]
Fix adding columns to a temp table.
Bruce Momjian [Tue, 13 Apr 1999 17:42:26 +0000 (17:42 +0000)]
Add ARM32 support by Andrew McMurry
Bruce Momjian [Tue, 13 Apr 1999 17:28:35 +0000 (17:28 +0000)]
array_in is defined in the system catalog as taking two arguments while it
actually takes three. Please apply the following patch.
Massimo
Bruce Momjian [Tue, 13 Apr 1999 17:18:29 +0000 (17:18 +0000)]
There are some bugs about backward scanning using
indexes.
1. Index Scan using plural indexids never scan backward
as to the order of indexids.
2. The cursor using Index scan is not usable after moving
past the end.
This patch solves above bugs.
Moreover the change of _bt_first() would be useful to extend
ORDER BY patch by Jan Wieck for all descending order cases.
Hiroshi Inoue
Michael Meskes [Tue, 13 Apr 1999 12:36:38 +0000 (12:36 +0000)]
*** empty log message ***
Tatsuo Ishii [Tue, 13 Apr 1999 09:46:58 +0000 (09:46 +0000)]
Add -E option
Tatsuo Ishii [Tue, 13 Apr 1999 09:29:46 +0000 (09:29 +0000)]
Document updation for 6.5
Vadim B. Mikheev [Mon, 12 Apr 1999 16:57:27 +0000 (16:57 +0000)]
Fix HEAP_MOVED_IN handling in HeapTupleSatisfiesDirty().
Vadim B. Mikheev [Mon, 12 Apr 1999 16:56:36 +0000 (16:56 +0000)]
Some comments...
Vadim B. Mikheev [Mon, 12 Apr 1999 16:56:08 +0000 (16:56 +0000)]
Unique btree-s:
/*
* Have to check is inserted heap tuple deleted one
* (i.e. just moved to another place by vacuum)!
*/
Tatsuo Ishii [Mon, 12 Apr 1999 04:04:54 +0000 (04:04 +0000)]
add mipsel-unknown-linux-gnu support. config.guess seems slightly changed
since April 1?
Peter Mount [Sun, 11 Apr 1999 18:03:00 +0000 (18:03 +0000)]
Implement UpdateCount
Tom Lane [Sun, 11 Apr 1999 02:30:59 +0000 (02:30 +0000)]
Repair problems seen when CREATE OPERATOR mentions a
not-yet-defined operator in commutator, negator, etc links. This is
necessary in order to ensure that a pg_dump dump of user-defined operators
can be reloaded. There may still be a bug lurking here, because it's
provoking a 'Buffer Leak' notice message in one case. See my mail to
pgsql-hackers.
Tom Lane [Sat, 10 Apr 1999 23:53:00 +0000 (23:53 +0000)]
Fix another batch of bogosities in pg_operator table.
These were bogus selectivity-estimator links, like a '>' operator
pointing to intltsel when it should use intgtsel.
Tom Lane [Sat, 10 Apr 1999 23:51:16 +0000 (23:51 +0000)]
Tweak create_operator regress test so it doesn't illustrate
incorrect usage of commutator link.
Peter Mount [Sat, 10 Apr 1999 16:48:05 +0000 (16:48 +0000)]
vacuumlo deals with large objects not referenced by any tables and removes them.
Tom Lane [Fri, 9 Apr 1999 22:35:43 +0000 (22:35 +0000)]
Fix CREATE OPERATOR ... LANGUAGE 'internal', which I broke while
making prosrc instead of proname be the link to the actual internal function.
Thomas G. Lockhart [Thu, 8 Apr 1999 13:29:08 +0000 (13:29 +0000)]
Add section from Tom Lane on hashjoin characteristics of operators.
Add emacs editor hints to bottom of file.
Thomas G. Lockhart [Thu, 8 Apr 1999 13:28:22 +0000 (13:28 +0000)]
Add emacs editor hints to bottom of file.
Tom Lane [Wed, 7 Apr 1999 23:33:33 +0000 (23:33 +0000)]
Fix some more hashjoin-related bugs in pg_operator. Fix
hashjoin's hashFunc() so that it does the right thing with pass-by-value
data types (the old code would always return 0 for int2 or char values,
which would work but would slow things down a lot). Extend opr_sanity
regress test to catch more kinds of errors.
Tatsuo Ishii [Wed, 7 Apr 1999 05:14:51 +0000 (05:14 +0000)]
Prepare multi-byte support document for 6.5
Tom Lane [Wed, 7 Apr 1999 04:21:11 +0000 (04:21 +0000)]
Unmark 'hashable' operators that can't really be used for
hashjoins. Extend opr_sanity regress test to help detect similar mistakes.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:41:20 +0000 (15:41 +0000)]
Fix markup to include all closing tags.
Required by newest versions of DocBook and style sheets.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:38:10 +0000 (15:38 +0000)]
Start indenting markup. No text changes.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:36:56 +0000 (15:36 +0000)]
Fix XREF markup and typo.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:35:36 +0000 (15:35 +0000)]
Version string was truncating the last character.
Use memcpy() rather than StrNCpy() which had forced a string termination
character at the end.
Tom Lane [Tue, 6 Apr 1999 03:04:22 +0000 (03:04 +0000)]
On reflection, filesize limit ought to be an exact power
of 2 to save a few cycles in md.c. So, make it 2^30 not 10^9.
Tom Lane [Mon, 5 Apr 1999 22:25:11 +0000 (22:25 +0000)]
Reduce default file size limit to 1Gb, and move the
configuration constant to config.h.
Vadim B. Mikheev [Mon, 5 Apr 1999 10:55:49 +0000 (10:55 +0000)]
Fix HEAP_MOVED_OFF handling in HeapTupleSatisfiesDirty
(may be used while vacuuming unique btree-s).
Tom Lane [Mon, 5 Apr 1999 02:07:07 +0000 (02:07 +0000)]
Fix potential overflow problems when relation size exceeds
2gig. Fix failure to reliably put the smaller relation on the inside of
a hashjoin.
Tom Lane [Sun, 4 Apr 1999 20:16:50 +0000 (20:16 +0000)]
We use CFLAGS = -O2 on every other gcc platform, so why not
hpux_gcc too?
Tom Lane [Sun, 4 Apr 1999 20:10:12 +0000 (20:10 +0000)]
Use MAXALIGN value found by configure instead of a
hardwired assumption.
Tom Lane [Sat, 3 Apr 1999 22:57:29 +0000 (22:57 +0000)]
Give a better error message if an SQL-language function is
called through fmgr. Someday we should try to actually execute the function,
but that looks like it might be a major feature addition.
Not something to try during beta phase.
Tom Lane [Sat, 3 Apr 1999 18:07:47 +0000 (18:07 +0000)]
Fix bogus pg_amop entries for int8 hash, cidr btree,
polygon rtree, circle rtree indexes.
Tom Lane [Sat, 3 Apr 1999 00:18:28 +0000 (00:18 +0000)]
Fix nasty bug in optimization of multiway joins: optimizer
would sometimes generate a plan that omitted a sort step before merge.
Tom Lane [Fri, 2 Apr 1999 06:16:36 +0000 (06:16 +0000)]
Repair problems with omitted password and VALID UNTIL
parameters in CREATE USER.
Tom Lane [Fri, 2 Apr 1999 05:10:16 +0000 (05:10 +0000)]
Remove overly presumptuous use of __STDC__ in c.h, replacing
it with configure-script tests to see whether const, inline, volatile, etc
work or not. (Curiously, configure was already doing the work to see if
const and inline were OK, but the results were not getting plugged into
config.h :-(.)
Tom Lane [Fri, 2 Apr 1999 04:51:05 +0000 (04:51 +0000)]
Clean up compile errors and warnings, cf Billy Allie's
complaints (and some of my own).
Tom Lane [Fri, 2 Apr 1999 03:37:17 +0000 (03:37 +0000)]
Update config.guess and config.sub to versions from
autoconf 2.13.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:25:56 +0000 (15:25 +0000)]
Fix up small markup problems. Force omit-tags to nil so we have tag
completion as required by the newest DocBook conventions.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:24:49 +0000 (15:24 +0000)]
Repair cut-and-paste typo which described createdb rather than destroydb.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:23:03 +0000 (15:23 +0000)]
Include libpq+.sgml in the doc set.
Had been omitted from the integrated doc for no good reason.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:21:42 +0000 (15:21 +0000)]
Updates from Vince Vielhaber are the first since 1997.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:20:43 +0000 (15:20 +0000)]
Markup fixes from Vince Vielhaber.
Tatsuo Ishii [Tue, 30 Mar 1999 05:14:03 +0000 (05:14 +0000)]
Add -E option
Tatsuo Ishii [Tue, 30 Mar 1999 05:00:42 +0000 (05:00 +0000)]
Bug fixes and enhances to psql submitted by Masaaki Sakaida
1. Fix problems of PAGER and \? command
2. Add -E option that shows actual queries sent by \dt and friends
3. Add version number in startup banners for psql
Bruce Momjian [Tue, 30 Mar 1999 01:37:28 +0000 (01:37 +0000)]
Small cleanups.
Tatsuo Ishii [Mon, 29 Mar 1999 09:00:19 +0000 (09:00 +0000)]
Addition to test/locale submitted by Oleg Broytmann. Comments from him:
There are two subdirectories (ISO8859-7 and koi8-to-win1251) containing
tests for Greek locale and server<=>client recoding feature (recently
submitted by Tatsuo Ishii <t-ishii@sra.co.jp>; we've debugged his patches
together in the field of Cyrillic support).
Tatsuo Ishii [Mon, 29 Mar 1999 08:19:36 +0000 (08:19 +0000)]
change comparison char* and NULL to char* and '\0'. This should be
more portable way.
Tom Lane [Mon, 29 Mar 1999 01:30:45 +0000 (01:30 +0000)]
Modify fmgr so that internal name (compiler name) of a built-in
function is found in prosrc field of pg_proc, not proname. This allows
multiple aliases of a built-in to all be implemented as direct builtins,
without needing a level of indirection through an SQL function. Replace
existing SQL alias functions with builtin entries accordingly.
Save a few K by not storing string names of builtin functions in fmgr's
internal table (if you really want 'em, get 'em from pg_proc...).
Update opr_sanity with a few more cross-checks.
Vadim B. Mikheev [Sun, 28 Mar 1999 20:32:42 +0000 (20:32 +0000)]
1. Vacuum is updated for MVCC.
2. Much faster btree tuples deletion in the case when first on page
index tuple is deleted (no movement to the left page(s)).
3. Remember blkno of new root page in BTPageOpaque of
left/right siblings when root page is splitted.
Tom Lane [Sun, 28 Mar 1999 02:07:58 +0000 (02:07 +0000)]
Expanded opr_sanity test to look at pg_proc and other
related tables.
Tom Lane [Sun, 28 Mar 1999 02:06:23 +0000 (02:06 +0000)]
New regression test to cross-check pg_type, pg_class,
and related tables.
Tom Lane [Sun, 28 Mar 1999 02:01:39 +0000 (02:01 +0000)]
Clean up various minor irregularities detected by type_sanity
and newly expanded opr_sanity tests.
Tom Lane [Sun, 28 Mar 1999 01:57:32 +0000 (01:57 +0000)]
Remove pg_attribute_check.sql: these checks merged into new
regress test 'type_sanity'.
Tom Lane [Sun, 28 Mar 1999 01:56:12 +0000 (01:56 +0000)]
Fix bogus function signature for areajoinsel.
It still doesn't do anything, but at least now it does nothing correctly.
Tom Lane [Sat, 27 Mar 1999 17:26:26 +0000 (17:26 +0000)]
Delete unused system table pg_parg.
Tom Lane [Fri, 26 Mar 1999 08:04:53 +0000 (08:04 +0000)]
No longer need this file here; superseded by oidjoins regress test.
Tom Lane [Fri, 26 Mar 1999 08:02:52 +0000 (08:02 +0000)]
Add results of findoidjoins as a standard regression test.
Tom Lane [Fri, 26 Mar 1999 07:32:42 +0000 (07:32 +0000)]
Remove a bunch of dead entries exposed by findoidjoins crosschecks.
Apparently, whatever these things used to link to got recycled into
something else ... but the dependent entries didn't.
Tom Lane [Fri, 26 Mar 1999 07:21:58 +0000 (07:21 +0000)]
Update findoidjoins for 6.5: remove workaround for long-dead bug,
use NOT EXISTS() which is a lot faster than NOT IN (),
update documentation.
Tom Lane [Thu, 25 Mar 1999 19:05:19 +0000 (19:05 +0000)]
Revise memutils.h to use alignment information gathered by
configure, instead of having a bunch of crufty platform-specific guesses.
Tatsuo Ishii [Thu, 25 Mar 1999 04:46:53 +0000 (04:46 +0000)]
Fix multi-byte+locale problem
Tom Lane [Thu, 25 Mar 1999 03:49:34 +0000 (03:49 +0000)]
Clean up att_align calculations so that XXXALIGN macros
need not be bogus.
Michael Meskes [Wed, 24 Mar 1999 20:05:15 +0000 (20:05 +0000)]
*** empty log message ***
Michael Meskes [Wed, 24 Mar 1999 14:54:10 +0000 (14:54 +0000)]
*** empty log message ***
Tatsuo Ishii [Wed, 24 Mar 1999 07:02:17 +0000 (07:02 +0000)]
Add KOI8/WIN/ALT support
Tatsuo Ishii [Wed, 24 Mar 1999 07:01:37 +0000 (07:01 +0000)]
These small utilities are for generating internal tables from
rcode encoding tables.
Tatsuo Ishii [Wed, 24 Mar 1999 06:57:20 +0000 (06:57 +0000)]
Add KOI8/WIN/ALT to set client_encoding command help
Tatsuo Ishii [Wed, 24 Mar 1999 06:55:14 +0000 (06:55 +0000)]
Fix typo. #ifdef MUTIBYTE --> #ifdef MULTIBYTE
Tatsuo Ishii [Wed, 24 Mar 1999 06:53:28 +0000 (06:53 +0000)]
Add KOI8/WIN/ALT to the multi-byte encoding selections
Tatsuo Ishii [Wed, 24 Mar 1999 06:20:38 +0000 (06:20 +0000)]
Add KOI8/WIN/ALT to the multi-byte encoding selections
Tatsuo Ishii [Wed, 24 Mar 1999 04:22:13 +0000 (04:22 +0000)]
Add KOI8/WIN/ALT to the multi-byte encoding selections
Bruce Momjian [Tue, 23 Mar 1999 16:51:04 +0000 (16:51 +0000)]
Remove Tee code, move to _deadcode.
Bruce Momjian [Tue, 23 Mar 1999 05:41:00 +0000 (05:41 +0000)]
cleanups
Bruce Momjian [Mon, 22 Mar 1999 16:45:30 +0000 (16:45 +0000)]
Hi,
I have solved some problems with dynamic loading on NT. It is possible
to
run succesfully both trigger and plpgsql regression tests. The patch is
in
the included file "diff".
Dan
Bruce Momjian [Mon, 22 Mar 1999 05:07:32 +0000 (05:07 +0000)]
Add % to b_expr.
Bruce Momjian [Mon, 22 Mar 1999 05:00:57 +0000 (05:00 +0000)]
Cleanup of NULL in inet types.
Tom Lane [Sun, 21 Mar 1999 19:59:13 +0000 (19:59 +0000)]
Correct some comments, fix a small memory wastage when datatype
is pass-by-value.
Bruce Momjian [Sun, 21 Mar 1999 06:31:59 +0000 (06:31 +0000)]
This patch fixes the bug that made it impossible to grant permissions to
a user such as "www-data".
Oliver
Tom Lane [Sun, 21 Mar 1999 02:43:58 +0000 (02:43 +0000)]
Add .cvsignore file so cvs doesn't complain if you have lex/yacc
output files laying about.
Bruce Momjian [Sun, 21 Mar 1999 02:30:22 +0000 (02:30 +0000)]
cleanup
Tom Lane [Sun, 21 Mar 1999 02:27:47 +0000 (02:27 +0000)]
Ah, *now* I understand: plpgsql lexer must be generated with flex -l ...
Bruce Momjian [Sun, 21 Mar 1999 02:26:56 +0000 (02:26 +0000)]
Fix for %4 and 4%.
Tom Lane [Sun, 21 Mar 1999 01:07:07 +0000 (01:07 +0000)]
Hmm, it seems some versions of flex declare yytext as extern char[]
but others declare it as extern char *. gcc complains (quite rightly too).
Worked around it by rearranging the order of inclusions so that we don't
have to explicitly declare yytext; this should work with either variant.
Michael Meskes [Sat, 20 Mar 1999 19:46:54 +0000 (19:46 +0000)]
*** empty log message ***
Tom Lane [Sat, 20 Mar 1999 18:45:27 +0000 (18:45 +0000)]
Remove yacc/lex output files from CVS repository.
Tom Lane [Sat, 20 Mar 1999 18:03:37 +0000 (18:03 +0000)]
Remove yacc/lex output files from CVS repository.
Tom Lane [Sat, 20 Mar 1999 18:00:38 +0000 (18:00 +0000)]
Clean up build procedure: do not keep raw lex/yacc files around,
only the edited ones.
Tom Lane [Sat, 20 Mar 1999 17:58:21 +0000 (17:58 +0000)]
make clean should remove lex.yy.c
Tom Lane [Sat, 20 Mar 1999 17:53:54 +0000 (17:53 +0000)]
Script for preparing derived files during tarball construction.