]> granicus.if.org Git - postgresql/log
postgresql
25 years agovacuumlo deals with large objects not referenced by any tables and removes them.
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.

25 years agoFix CREATE OPERATOR ... LANGUAGE 'internal', which I broke while
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.

25 years agoAdd section from Tom Lane on hashjoin characteristics of operators.
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.

25 years agoAdd 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.

25 years agoFix some more hashjoin-related bugs in pg_operator. Fix
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.

25 years agoPrepare multi-byte support document for 6.5
Tatsuo Ishii [Wed, 7 Apr 1999 05:14:51 +0000 (05:14 +0000)]
Prepare multi-byte support document for 6.5

25 years agoUnmark 'hashable' operators that can't really be used for
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.

25 years agoFix markup to include all closing tags.
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.

25 years agoStart indenting markup. No text changes.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:38:10 +0000 (15:38 +0000)]
Start indenting markup. No text changes.

25 years agoFix XREF markup and typo.
Thomas G. Lockhart [Tue, 6 Apr 1999 15:36:56 +0000 (15:36 +0000)]
Fix XREF markup and typo.

25 years agoVersion string was truncating the last character.
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.

25 years agoOn reflection, filesize limit ought to be an exact power
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.

25 years agoReduce default file size limit to 1Gb, and move the
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.

25 years agoFix HEAP_MOVED_OFF handling in HeapTupleSatisfiesDirty
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).

25 years agoFix potential overflow problems when relation size exceeds
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.

25 years agoWe use CFLAGS = -O2 on every other gcc platform, so why not
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?

25 years agoUse MAXALIGN value found by configure instead of a
Tom Lane [Sun, 4 Apr 1999 20:10:12 +0000 (20:10 +0000)]
Use MAXALIGN value found by configure instead of a
hardwired assumption.

25 years agoGive a better error message if an SQL-language function is
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.

25 years agoFix bogus pg_amop entries for int8 hash, cidr btree,
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.

25 years agoFix nasty bug in optimization of multiway joins: optimizer
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.

25 years agoRepair problems with omitted password and VALID UNTIL
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.

25 years agoRemove overly presumptuous use of __STDC__ in c.h, replacing
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 :-(.)

25 years agoClean up compile errors and warnings, cf Billy Allie's
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).

25 years agoUpdate config.guess and config.sub to versions from
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.

25 years agoFix up small markup problems. Force omit-tags to nil so we have tag
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.

25 years agoRepair cut-and-paste typo which described createdb rather than destroydb.
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.

25 years agoInclude libpq+.sgml in the doc set.
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.

25 years agoUpdates from Vince Vielhaber are the first since 1997.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:21:42 +0000 (15:21 +0000)]
Updates from Vince Vielhaber are the first since 1997.

25 years agoMarkup fixes from Vince Vielhaber.
Thomas G. Lockhart [Tue, 30 Mar 1999 15:20:43 +0000 (15:20 +0000)]
Markup fixes from Vince Vielhaber.

25 years agoAdd -E option
Tatsuo Ishii [Tue, 30 Mar 1999 05:14:03 +0000 (05:14 +0000)]
Add -E option

25 years agoBug fixes and enhances to psql submitted by Masaaki Sakaida
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

25 years agoSmall cleanups.
Bruce Momjian [Tue, 30 Mar 1999 01:37:28 +0000 (01:37 +0000)]
Small cleanups.

25 years agoAddition to test/locale submitted by Oleg Broytmann. Comments from him:
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).

25 years agochange comparison char* and NULL to char* and '\0'. This should be
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.

25 years agoModify fmgr so that internal name (compiler name) of a built-in
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.

25 years ago1. Vacuum is updated for MVCC.
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.

25 years agoExpanded opr_sanity test to look at pg_proc and other
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.

25 years agoNew regression test to cross-check pg_type, pg_class,
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.

25 years agoClean up various minor irregularities detected by type_sanity
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.

25 years agoRemove pg_attribute_check.sql: these checks merged into new
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'.

25 years agoFix bogus function signature for areajoinsel.
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.

25 years agoDelete unused system table pg_parg.
Tom Lane [Sat, 27 Mar 1999 17:26:26 +0000 (17:26 +0000)]
Delete unused system table pg_parg.

25 years agoNo longer need this file here; superseded by oidjoins regress test.
Tom Lane [Fri, 26 Mar 1999 08:04:53 +0000 (08:04 +0000)]
No longer need this file here; superseded by oidjoins regress test.

25 years agoAdd results of findoidjoins as a standard regression test.
Tom Lane [Fri, 26 Mar 1999 08:02:52 +0000 (08:02 +0000)]
Add results of findoidjoins as a standard regression test.

25 years agoRemove a bunch of dead entries exposed by findoidjoins crosschecks.
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.

25 years agoUpdate findoidjoins for 6.5: remove workaround for long-dead bug,
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.

25 years agoRevise memutils.h to use alignment information gathered by
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.

25 years agoFix multi-byte+locale problem
Tatsuo Ishii [Thu, 25 Mar 1999 04:46:53 +0000 (04:46 +0000)]
Fix multi-byte+locale problem

25 years agoClean up att_align calculations so that XXXALIGN macros
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.

25 years ago*** empty log message ***
Michael Meskes [Wed, 24 Mar 1999 20:05:15 +0000 (20:05 +0000)]
*** empty log message ***

25 years ago*** empty log message ***
Michael Meskes [Wed, 24 Mar 1999 14:54:10 +0000 (14:54 +0000)]
*** empty log message ***

25 years agoAdd KOI8/WIN/ALT support
Tatsuo Ishii [Wed, 24 Mar 1999 07:02:17 +0000 (07:02 +0000)]
Add KOI8/WIN/ALT support

25 years agoThese small utilities are for generating internal tables from
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.

25 years agoAdd KOI8/WIN/ALT to set client_encoding command help
Tatsuo Ishii [Wed, 24 Mar 1999 06:57:20 +0000 (06:57 +0000)]
Add KOI8/WIN/ALT to set client_encoding command help

25 years agoFix typo. #ifdef MUTIBYTE --> #ifdef MULTIBYTE
Tatsuo Ishii [Wed, 24 Mar 1999 06:55:14 +0000 (06:55 +0000)]
Fix typo. #ifdef MUTIBYTE --> #ifdef MULTIBYTE

25 years agoAdd KOI8/WIN/ALT to the multi-byte encoding selections
Tatsuo Ishii [Wed, 24 Mar 1999 06:53:28 +0000 (06:53 +0000)]
Add KOI8/WIN/ALT to the multi-byte encoding selections

25 years agoAdd 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

25 years agoAdd 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

25 years agoRemove Tee code, move to _deadcode.
Bruce Momjian [Tue, 23 Mar 1999 16:51:04 +0000 (16:51 +0000)]
Remove Tee code, move to _deadcode.

25 years agocleanups
Bruce Momjian [Tue, 23 Mar 1999 05:41:00 +0000 (05:41 +0000)]
cleanups

25 years agoHi,
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

25 years agoAdd % to b_expr.
Bruce Momjian [Mon, 22 Mar 1999 05:07:32 +0000 (05:07 +0000)]
Add % to b_expr.

25 years agoCleanup of NULL in inet types.
Bruce Momjian [Mon, 22 Mar 1999 05:00:57 +0000 (05:00 +0000)]
Cleanup of NULL in inet types.

25 years agoCorrect some comments, fix a small memory wastage when datatype
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.

25 years agoThis patch fixes the bug that made it impossible to grant permissions to
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

25 years agoAdd .cvsignore file so cvs doesn't complain if you have lex/yacc
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.

25 years agocleanup
Bruce Momjian [Sun, 21 Mar 1999 02:30:22 +0000 (02:30 +0000)]
cleanup

25 years agoAh, *now* I understand: plpgsql lexer must be generated with flex -l ...
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 ...

25 years agoFix for %4 and 4%.
Bruce Momjian [Sun, 21 Mar 1999 02:26:56 +0000 (02:26 +0000)]
Fix for %4 and 4%.

25 years agoHmm, it seems some versions of flex declare yytext as extern char[]
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.

25 years ago*** empty log message ***
Michael Meskes [Sat, 20 Mar 1999 19:46:54 +0000 (19:46 +0000)]
*** empty log message ***

25 years agoRemove yacc/lex output files from CVS repository.
Tom Lane [Sat, 20 Mar 1999 18:45:27 +0000 (18:45 +0000)]
Remove yacc/lex output files from CVS repository.

25 years agoRemove 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.

25 years agoClean up build procedure: do not keep raw lex/yacc files around,
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.

25 years agomake clean should remove lex.yy.c
Tom Lane [Sat, 20 Mar 1999 17:58:21 +0000 (17:58 +0000)]
make clean should remove lex.yy.c

25 years agoScript for preparing derived files during tarball construction.
Tom Lane [Sat, 20 Mar 1999 17:53:54 +0000 (17:53 +0000)]
Script for preparing derived files during tarball construction.

25 years agoReverse out pfree agg part of patch from Erik Riedel.
Bruce Momjian [Sat, 20 Mar 1999 13:18:20 +0000 (13:18 +0000)]
Reverse out pfree agg part of patch from Erik Riedel.

25 years agocleanup
Bruce Momjian [Sat, 20 Mar 1999 02:31:45 +0000 (02:31 +0000)]
cleanup

25 years agocleanup
Bruce Momjian [Sat, 20 Mar 1999 02:07:31 +0000 (02:07 +0000)]
cleanup

25 years agoFix for aggregate memory leaks from Erik Riedel.
Bruce Momjian [Sat, 20 Mar 1999 01:13:22 +0000 (01:13 +0000)]
Fix for aggregate memory leaks from Erik Riedel.

25 years agoFix &g.
Bruce Momjian [Sat, 20 Mar 1999 00:15:40 +0000 (00:15 +0000)]
Fix &g.

25 years agoFix shift/reduce for NULL = Var.
Bruce Momjian [Fri, 19 Mar 1999 23:48:50 +0000 (23:48 +0000)]
Fix shift/reduce for NULL = Var.

25 years agoFix for memory leak in executor with fjIsNull.
Bruce Momjian [Fri, 19 Mar 1999 22:31:39 +0000 (22:31 +0000)]
Fix for memory leak in executor with fjIsNull.

25 years agoI suggest the following portability patch, which does not
Bruce Momjian [Fri, 19 Mar 1999 18:56:43 +0000 (18:56 +0000)]
I suggest the following portability patch, which does not
change functionality, but makes the code more ANSI C'ish.
My AIX xlc compiler barfs on all of these. Can someone please
review and apply to current.

 <<port.patch>>
Thanks
Andreas

25 years agoAdd EXCEPT/INTERSECT doc changes.
Bruce Momjian [Fri, 19 Mar 1999 02:41:41 +0000 (02:41 +0000)]
Add EXCEPT/INTERSECT doc changes.

25 years agocleanup parser
Bruce Momjian [Thu, 18 Mar 1999 22:11:47 +0000 (22:11 +0000)]
cleanup parser

25 years agogrammar cleanup'
Bruce Momjian [Thu, 18 Mar 1999 22:03:59 +0000 (22:03 +0000)]
grammar cleanup'

25 years agocleanup of grammer.
Bruce Momjian [Thu, 18 Mar 1999 22:01:56 +0000 (22:01 +0000)]
cleanup of grammer.

25 years agoFix optimizer indexing not working for negative numbers.
Bruce Momjian [Thu, 18 Mar 1999 21:39:56 +0000 (21:39 +0000)]
Fix optimizer indexing not working for negative numbers.

25 years agocleanups
Bruce Momjian [Thu, 18 Mar 1999 19:59:55 +0000 (19:59 +0000)]
cleanups

25 years ago*** empty log message ***
Michael Meskes [Thu, 18 Mar 1999 15:20:33 +0000 (15:20 +0000)]
*** empty log message ***

25 years agoAdd new postgres -O option to allow system table structure changes.
Bruce Momjian [Wed, 17 Mar 1999 22:53:31 +0000 (22:53 +0000)]
Add new postgres -O option to allow system table structure changes.

25 years agogrammar cleanup
Bruce Momjian [Wed, 17 Mar 1999 21:58:25 +0000 (21:58 +0000)]
grammar cleanup

25 years agoINET/CIDR doc cleanup
Bruce Momjian [Wed, 17 Mar 1999 21:38:13 +0000 (21:38 +0000)]
INET/CIDR doc cleanup

25 years agoAdd docs about left-associativity of operators.
Bruce Momjian [Wed, 17 Mar 1999 21:27:02 +0000 (21:27 +0000)]
Add docs about left-associativity of operators.

25 years agoAdd documentation change for %'s precidence.
Bruce Momjian [Wed, 17 Mar 1999 21:24:17 +0000 (21:24 +0000)]
Add documentation change for %'s precidence.

25 years agoLeft associates all operators, instead of non-associating them.
Bruce Momjian [Wed, 17 Mar 1999 21:02:57 +0000 (21:02 +0000)]
Left associates all operators, instead of non-associating them.

25 years agoHave % operator have precedence like /.
Bruce Momjian [Wed, 17 Mar 1999 20:17:13 +0000 (20:17 +0000)]
Have % operator have precedence like /.

25 years agoUpdate sgml for 6.4.* release changes.
Bruce Momjian [Tue, 16 Mar 1999 21:03:00 +0000 (21:03 +0000)]
Update sgml for 6.4.* release changes.

25 years agoUpdate nextval() code.
Bruce Momjian [Tue, 16 Mar 1999 20:15:06 +0000 (20:15 +0000)]
Update nextval() code.