summaryrefslogtreecommitdiff
path: root/src/include
AgeCommit message (Collapse)Author
1999-04-13Add ARM32 support by Andrew McMurryBruce Momjian
1999-04-13array_in is defined in the system catalog as taking two arguments while itBruce Momjian
actually takes three. Please apply the following patch. Massimo
1999-04-10Fix another batch of bogosities in pg_operator table.Tom Lane
These were bogus selectivity-estimator links, like a '>' operator pointing to intltsel when it should use intgtsel.
1999-04-09Fix CREATE OPERATOR ... LANGUAGE 'internal', which I broke whileTom Lane
making prosrc instead of proname be the link to the actual internal function.
1999-04-07Fix some more hashjoin-related bugs in pg_operator. FixTom Lane
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.
1999-04-07Unmark 'hashable' operators that can't really be used forTom Lane
hashjoins. Extend opr_sanity regress test to help detect similar mistakes.
1999-04-06On reflection, filesize limit ought to be an exact powerTom Lane
of 2 to save a few cycles in md.c. So, make it 2^30 not 10^9.
1999-04-05Reduce default file size limit to 1Gb, and move theTom Lane
configuration constant to config.h.
1999-04-03Fix bogus pg_amop entries for int8 hash, cidr btree,Tom Lane
polygon rtree, circle rtree indexes.
1999-04-03Fix nasty bug in optimization of multiway joins: optimizerTom Lane
would sometimes generate a plan that omitted a sort step before merge.
1999-04-02Remove overly presumptuous use of __STDC__ in c.h, replacingTom Lane
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 :-(.)
1999-04-02Clean up compile errors and warnings, cf Billy Allie'sTom Lane
complaints (and some of my own).
1999-03-30Small cleanups.Bruce Momjian
1999-03-29Modify fmgr so that internal name (compiler name) of a built-inTom Lane
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.
1999-03-281. Vacuum is updated for MVCC.Vadim B. Mikheev
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.
1999-03-28Clean up various minor irregularities detected by type_sanityTom Lane
and newly expanded opr_sanity tests.
1999-03-28Remove pg_attribute_check.sql: these checks merged into newTom Lane
regress test 'type_sanity'.
1999-03-28Fix bogus function signature for areajoinsel.Tom Lane
It still doesn't do anything, but at least now it does nothing correctly.
1999-03-27Delete unused system table pg_parg.Tom Lane
1999-03-26No longer need this file here; superseded by oidjoins regress test.Tom Lane
1999-03-26Remove a bunch of dead entries exposed by findoidjoins crosschecks.Tom Lane
Apparently, whatever these things used to link to got recycled into something else ... but the dependent entries didn't.
1999-03-25Revise memutils.h to use alignment information gathered byTom Lane
configure, instead of having a bunch of crufty platform-specific guesses.
1999-03-25Clean up att_align calculations so that XXXALIGN macrosTom Lane
need not be bogus.
1999-03-24Add KOI8/WIN/ALT to the multi-byte encoding selectionsTatsuo Ishii
1999-03-23Remove Tee code, move to _deadcode.Bruce Momjian
1999-03-22Hi,Bruce Momjian
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
1999-03-19I suggest the following portability patch, which does notBruce Momjian
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
1999-03-17Add new postgres -O option to allow system table structure changes.Bruce Momjian
1999-03-16Here is a patch.Bruce Momjian
I have changed to call pg_exec_query_dest() instead of pg_exec_query(). Thanks. Hiroshi Inoue
1999-03-15Fix brain death in !!= operator ... it's still pretty bogusTom Lane
but at least now it does what it's supposed to do ...
1999-03-15Fix int8 configure one more time ... prior version didn'tTom Lane
define INT64_FORMAT in all cases.
1999-03-14Attempting to insert a value of 'now' into a datetime typeBruce Momjian
results in a bogus datetime value under AlphaLinux. (Note that the link to submit a port-specific bug on your website is broken) -Test Case: ---------- testdb=> create table dttest (dt datetime); testdb=> insert into dttest values ('now'); -------------------------------------------------------------------------- Solution: --------- The basic problem is the typedefs of AbsoluteTime and RelativeTime, which are both 'int32'. These types appear to be used synonymously with the 'time_t' type, which on AlphaLinux is typedef'd as a 'long int', which is 64-bits (not 32). The solution included here fixes the datetime type (it now passes the regression test), but does not pass the absolute and relative time regression tests. Presumably, a more thorough investigation of how these types are used is warranted. The included patch is from the v6.3.2 source, but can be applied to the v6.4.2 source. Please note that there is also a RedHat-specific patch distributed with the PostgreSQL source package from RedHat that was applied first. Rich Edwards
1999-03-14Cleanup of hash functions in pg_proc.Bruce Momjian
1999-03-14We have tested the patches on three platforms:Bruce Momjian
NetBSD/macppc LinuxPPC FreeBSD 2.2.6-RELEASE All of them seem happy with the regression test. Note that, however, compiling with optimization enabled on NetBSD/macppc causes an initdb failure (other two platforms are ok). After checking the asm code, we are suspecting that might be a compiler(egcs) bug. Tatsuo Ishii
1999-03-14Enclosed below I have a patch to allow a btree index on the int8 type.Bruce Momjian
I would like some feedback on what the hash function for the int8 hash function in the ./backend/access/hash/hashfunc.c should return. Also, could someone (maybe Tomas Lockhart?) look-over the patch and make sure the system table entries are correct? I've tried to research them as much as I could, but some of them are still not clear to me. Thanks, -Ryan
1999-03-10Make type 'regproc' binary-compatible with int4 and oid,Tom Lane
so that it has some SQL operators available. It's difficult to write automated tests of a data type that you haven't even got == for...
1999-03-10Fix some typos in argument and result types in pg_procTom Lane
and pg_operator. The lone error in pg_operator was reported as a bug by Michael Reifenberger; the multiple errors in pg_proc would only have been noticed if one invoked the functions by name rather than using operator syntax. I guess few people do that.
1999-03-09Changes to fix/improve the dynamic loading on NTMarc G. Fournier
From: Horak Daniel <horak@mmp.plzen-city.cz>
1999-03-08Have configure check for use of %lld for int64, and if that fails, check forMarc G. Fournier
use of %qd...a more generic solution then having #ifdef __<INSERT OS HERE>__ in the code...
1999-03-07Modify mcxt.h so that it doesn't pull in half of creation.Tom Lane
1999-03-07geqo now at 11 tablesBruce Momjian
1999-03-07Really remove Recipe.Bruce Momjian
1999-03-06Eliminate duplicated code in dt.hTom Lane
1999-03-06A few further tweaks to shared memory space estimation.Tom Lane
This change brings the default size of the main shmem block back under 1MB, which is a fairly popular value for the kernel's SHMMAX parameter.
1999-03-03Partial fix for copied-plan bugs reported by Hiroshi Inoue:Tom Lane
_copyResult didn't copy subPlan structure completely. _copyAgg is still busted, apparently because of changes from EXCEPT/INTERSECT patch (get_agg_tlist_references is no longer sufficient to find all aggregates). No time to look at that tonight, however.
1999-03-01Executor no longer cares about mergejoinop, mergerightorder, mergeleftorder,Tom Lane
so remove them from MergeJoin node. Hack together a partial solution for commuted mergejoin operators --- yesterday a mergejoin int4 = int8 would crash if the planner decided to commute it, today it works. The planner's representation of mergejoins really needs a rewrite though. Also, further testing of mergejoin ops in opr_sanity regress test.
1999-02-28Fix pg_operator entries for mergejoinable operators with different left andTom Lane
right side data types. Correct the opr_sanity regress test to check these entries properly. NOTE that opr_sanity will now fail until you do an initdb!
1999-02-28Fix executor to work correctly with mergejoins where left andTom Lane
right sides have different data types.
1999-02-27Put back T_RecipeStmt, since the system doesn't actually buildTom Lane
without it. Sloppy, sloppy.
1999-02-24Fix problem with selectivity error in added columns with ALTER TABLE.Bruce Momjian
Move files to deadcode.