aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* Add Aggref and ArrayRef to the set of node types that transformExprTom Lane1999-05-18
| | | | | | will pass through rather than spitting up. This is necessary to handle cases where coerce_type causes a subexpression to be retransformed, as in SELECT count(*) + 1.0 FROM table
* Now that hashjoin is reliable for large joins (knock on wood),Tom Lane1999-05-18
| | | | | | remove optimizer's arbitrary limit on how large a join it will use hashing for. (The limit was too large to prevent the problems we'd been seeing, anyway...)
* Remove no-longer-used fields in Hash and HashJoin nodes.Tom Lane1999-05-18
|
* Rewrite hash join to use simple linked lists instead of aTom Lane1999-05-18
| | | | | | | fixed-size hashtable. This should prevent 'hashtable out of memory' errors, unless you really do run out of memory. Note: target size for hashtable is now taken from -S postmaster switch, not -B, since it is local memory in the backend rather than shared memory.
* All works on linux now by my tests and regression(with patch below).Bruce Momjian1999-05-17
| | | | | ALTER TABLE RENAME with extents. Ole Gjerde
* Skip junk nodes when comparing UNION target list lengths.Bruce Momjian1999-05-17
|
* Change resjunk to a boolean.Bruce Momjian1999-05-17
|
* This is actually more of a fundamental problem with mdtruncate. ItBruce Momjian1999-05-17
| | | | | | | | | | | | looks like someone just didn't add support for multiple segments for truncation. The following patch seems to do the right thing, for me at least. It passed my tests, my data looks right(no data that shouldn't be in there) and regression is ok. Ole Gjerde
* Prior patch added 2 more characters to string allocatedTom Lane1999-05-17
| | | | for SERIAL column's constraint, but forgot to increase space palloc'd...
* SELECT * error message fix.Bruce Momjian1999-05-17
|
* Apply freebsd specific patches dealign with ELF system from FreeBSD'sMarc G. Fournier1999-05-17
| | | | ports collection ...
* Move IN to proper place.Bruce Momjian1999-05-17
|
* CleanupBruce Momjian1999-05-17
|
* Fix typo in change.Bruce Momjian1999-05-17
|
* Tighten coding in new_join_pathkey, which seems to be a hotspotTom Lane1999-05-17
| | | | for GEQO ...
* Change GEQO optimizer to release memory after each geneTom Lane1999-05-17
| | | | | is evaluated. This bounds memory usage to something reasonable even when many tables are being joined.
* Require IN in LOCK syntax.Bruce Momjian1999-05-17
|
* Change md* call to smgr*.Bruce Momjian1999-05-17
|
* Minor code cleanup in optimizer.Tom Lane1999-05-16
|
* Fix some typos in geqo optimizer --- it now generatesTom Lane1999-05-16
| | | | | reasonable plans again. Still eats memory like there's no tomorrow, however :-(.
* I made it so it rolled over files at 1MB. My table ended up with 120Bruce Momjian1999-05-15
| | | | | | | | | | | | | | | | | | | segments, and my indexes had 3(Yes, it DOES work!). DROP TABLE removed ALL segments from the table, but only the main index segment. So it looks like removing the table itself is using mdunlink in md.c, while removing indexes uses FileNameUnlink() which only unlinks 1 file. As far as I can tell, calling FileNameUnlink() and mdunlink() is basically the same, except mdunlink() deletes any extra segments. I've done some testing and it seems to work. It also passes regression tests(except float8, geometry and rules, but that's normal). If this patch is right, this fixes all known multi-segment problems on Linux. Ole Gjerde
* Hi, Bruce!Bruce Momjian1999-05-13
| | | | | | | These are my last changes to lmgr fixing deadlock handling. Please apply them to cvs... Vadim
* Add double quotes around the sequence name generated to support theThomas G. Lockhart1999-05-13
| | | | | | SERIAL data type DEFAULT clause. This fixes a problem finding the sequence name when mixed case table names are involved.
* Surround a variable declaration with ENABLE_OUTER_JOINS to suppressThomas G. Lockhart1999-05-13
| | | | compiler warnings about an unused variable.
* set client_encoding to <nothing> crashes backend.Tatsuo Ishii1999-05-13
|
* Rip out QueryTreeList structure, root and branch. QuerytreeTom Lane1999-05-13
| | | | | | | | | | lists are now plain old garden-variety Lists, allocated with palloc, rather than specialized expansible-array data allocated with malloc. This substantially simplifies their handling and eliminates several sources of memory leakage. Several basic types of erroneous queries (syntax error, attempt to insert a duplicate key into a unique index) now demonstrably leak zero bytes per query.
* Release allocated memory during AtAbort_Memory.Tom Lane1999-05-13
|
* Fixed small bug in ruleutils and added output of pg_views andJan Wieck1999-05-12
| | | | | | pg_rules to rules regression test. Jan
* Fixed wrong hasAggs when aggregate columns of view aren'tJan Wieck1999-05-12
| | | | | | | | selected. Disabled ability of defining DISTINCT or ORDER BY on views. Jan
* Replaced targetlist entry in GroupClause by reference numberJan Wieck1999-05-12
| | | | | | | in Resdom and GroupClause so changing of resno's doesn't confuse the grouping any more. Jan
* I am sorry, I misinterpreted the still failing trigger regression test.Bruce Momjian1999-05-12
| | | | | | | | | | | | | | | | | The offending code has been removed, the action is now always dependent :-) I suggest the following patch, to finally make trigger regression happy again: <<refint1.patch>> After that you can remove the following from TODO: Remove ERROR: check_primary_key: even number of arguments should be specified Trigger regression test fails Andreas
* Add keywords to implement Vadim's transaction isolationThomas G. Lockhart1999-05-12
| | | | | | | | | | and lock syntax as fully parsed tokens. Two keywords for isolation are non-reserved SQL92 (COMMITTED, SERIALIZABLE). All other new keywords are non-reserved Postgres (not SQL92) (ACCESS, EXCLUSIVE, MODE, SHARE). Add syntax to allow CREATE [GLOBAL|LOCAL] TEMPORARY TABLE, throwing an error if GLOBAL is specified.
* Fix problem with multiple indices defined if using column- and table-Thomas G. Lockhart1999-05-12
| | | | | | | constraints. Reported by Tom Lane. Now, check for duplicate indices and retain the one which is a primary-key. Adjust elog NOTICE messages to surround table and column names with single quotes.
* Handle conversion of floating point constants to internal strings.Thomas G. Lockhart1999-05-12
|
* Keep long non-quoted numeric strings *as* untyped strings if they failThomas G. Lockhart1999-05-12
| | | | | | the obvious conversion. Define a new pattern "decimal" which is non-exponential floating point for use with numeric() and decimal() types.
* Changed debug options:Jan Wieck1999-05-11
| | | | | | | | | -d4 now prints compressed trees from nodeToString() -d5 prints pretty trees via nodeDisplay() new pg_options: pretty_plan, pretty_parse, pretty_rewritten Jan
* clean up commentsBruce Momjian1999-05-11
|
* Check for NUMERIC overflow a second time after roundingJan Wieck1999-05-10
| | | | Jan
* Update to PyGreSQL 2.3.Bruce Momjian1999-05-10
|
* Rename MAP_FILE to USERMAP_FILE for Digital Unix.Bruce Momjian1999-05-10
|
* Fix initdb problem introduced by recent patch.Bruce Momjian1999-05-10
|
* Change error messages to oids come out as %u and not %d. Change has noBruce Momjian1999-05-10
| | | | real affect now.
* Rearrange top-level rewrite operations so that EXPLAIN worksTom Lane1999-05-09
| | | | on queries involving UNION, EXCEPT, INTERSECT.
* Running lo_read/lo_write under different memory contextTatsuo Ishii1999-05-09
| | | | | | cause troubles. See Message-Id: <199905090312.MAA00466@ext16.sra.co.jp> for more details.
* Mistyping by me.Vadim B. Mikheev1999-05-09
| | | | Fixed by Hiroshi.
* Fix some miscellaneous places that were using raw open() orTom Lane1999-05-09
| | | | fopen(), instead of going through fd.c ... naughty naughty.
* Update hash and join routines to use fd.c's new temp-fileTom Lane1999-05-09
| | | | code, instead of not-very-bulletproof stuff they had before.
* Add 'temporary file' facility to fd.c, and arrange for tempTom Lane1999-05-09
| | | | | | | | | files to be closed automatically at transaction abort or commit, should they still be open. Also close any still-open stdio files allocated with AllocateFile at abort/commit. This should eliminate problems with leakage of file descriptors after an error. Also, put in some primitive buffered-IO support so that psort.c can use virtual files without severe performance penalties.
* Fix LMGR for MVCC.Vadim B. Mikheev1999-05-07
| | | | Get rid of Extend lock mode.
* Fix oversights in flatten_tlistentry and replace_clause_joinvar_refsTom Lane1999-05-06
| | | | that led to CASE expressions not working very well in joined queries.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 13:12:14 +0000