aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* 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.
* fix_indxqual_references didn't cope with ArrayRef nodes,Tom Lane1999-05-06
| | | | | | meaning that this failed: select proname,typname,prosrc from pg_proc,pg_type where proname = 'float8' and pg_proc.proargtypes[0] = pg_type.oid;
* Fix some nasty coredump bugs in hashjoin. This code was justTom Lane1999-05-06
| | | | | | | | | | about certain to fail anytime it decided the relation to be hashed was too big to fit in memory --- the code for 'batching' a series of hashjoins had multiple errors. I've fixed the easier problems. A remaining big problem is that you can get 'hashtable out of memory' if the code's guesstimate about how much overflow space it will need turns out wrong. That will require much more extensive revisions to fix, so I'm committing these fixes now before I start on that problem.
* I have two patches for 6.5.0:Bruce Momjian1999-05-05
| | | | | | | | | | arrayfuncs.patch fixes a small bug in my previous patches for arrays array-regress.patch adds _bpchar and _varchar to regression tests -- Massimo Dal Zotto
* small error message improvement from Dmitry SamersoffBruce Momjian1999-05-05
|
* Repair incorrectly-figured snprintf length restriction.Tom Lane1999-05-04
|
* Use sprintf() to convert float8 to a string during conversion to numeric.Thomas G. Lockhart1999-05-04
| | | | | Original code used float8out(), but the resulting exponential notation was not handled (e.g. '3E9' was decoded as '3').
* Make sure targetlist generated for subplan does not shareTom Lane1999-05-04
| | | | | nodes with HAVING qualifier of upper plan. Have not seen any failures, just being a little bit paranoid...
* Correct declaration of array_map() so that it doesn't makeTom Lane1999-05-03
| | | | gcc quite so unhappy.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 19:50:19 +0000