aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* Fix subquery pullup logic to not be fooled when a view that appearsTom Lane2004-01-10
| | | | | | 'simple' references another view that is not simple. Must recheck conditions after performing recursive pullup. Per example from Laurent Perez, 9-Jan-04.
* Translation updatesPeter Eisentraut2004-01-07
|
* Fix discrepancy in prototypes for HPUX pg_dlerror.Tom Lane2004-01-04
|
* Avoid running out of memory during hash_create, by not passing aTom Lane2003-12-30
| | | | | number-of-buckets that exceeds the size we actually plan to allow the hash table to grow to. Per trouble report from Sean Shanny.
* Fix broken IDENT support for FreeBSD (appears to have been broken byTom Lane2003-12-20
| | | | | ill-considered conditional logic in getpeereid patch of 3-Dec-2002). Per bug #1021.
* Forbid REVOKE on untrusted languages, and don't dump privileges ofPeter Eisentraut2003-12-19
| | | | untrusted languages (in case they sneak in).
* Make to_hex() behave portably on negative input values (treat them asTom Lane2003-12-19
| | | | unsigned integers). Per report from Jim Crate.
* Use a shutdown callback to ensure proper clean up when rescanningJoe Conway2003-12-19
| | | | | partially-evaluated SRFs. Per report found here: http://archives.postgresql.org/pgsql-general/2003-12/msg00851.php
* Fix memory leak with SSL connections due to missing X509_free() calls.Tom Lane2003-12-18
| | | | Per Neil Conway.
* Use a shutdown callback to clear setArgsValid in a FuncExprState that isTom Lane2003-12-18
| | | | | evaluating a set-valued function. This fixes some additional problems with rescanning partially-evaluated SRFs.
* Ensure set-returning functions in the targetlist of a plan node will beTom Lane2003-12-18
| | | | | | shut down cleanly if the plan node is ReScanned before the SRFs are run to completion. This fixes the problem for SQL-language functions, but still need work on functions using the SRF_XXX() macros.
* information_schema.constraint_column_usage and key_column_usage shouldTom Lane2003-12-17
| | | | | not discriminate against system columns, since we support constraints on system columns, and in fact constraints on OID are moderately useful.
* Fix DecodeInterval to handle '-0.1' sanely, per gripe from Tilo Schwarz.Tom Lane2003-12-17
|
* Reorder tests in parse_coerce so that ANY/ANYELEMENT/ANYARRAY coercionTom Lane2003-12-17
| | | | | | does not affect UNKNOWN-type literals or Params. This fixes the recent complaint about count('x') being broken, and improves consistency in a few other respects too.
* Repair planner failure when there are multiple IN clauses, each withTom Lane2003-12-17
| | | | | | | a join in its subselect. In this situation we *must* build a bushy plan because there are no valid left-sided or right-sided join trees. Accordingly, hoary sanity check needs an update. Per report from Alessandro Depase.
* Fix constraint_column_usage for foreign keys.Peter Eisentraut2003-12-16
|
* query_tree_mutator should copy RangeTblEntry nodes even when it's notTom Lane2003-12-09
| | | | | | | planning to modify them itself. Otherwise we end up with shared RTE substructure, which breaks inheritance_planner because the rte->inh flag needs to be independent in each copied subquery. Per bug report from Chris Piker.
* Whole-row references were broken for subqueries and functions, becauseTom Lane2003-12-08
| | | | | attr_needed/attr_widths optimization failed to allow for Vars with attno zero in this case. Per report from Tatsuo Ishii.
* Remove test on c.relkind from check_constraints view; unnecessary andTom Lane2003-12-07
| | | | | prevents view from showing constraints on domains. This addresses the other half of Claus Colloseus' bug report.
* Fix typmod interpretation for bit types. (It was erroneously assumed thatPeter Eisentraut2003-12-07
| | | | for bit(x), the typmod stores x+4, like for the character types.)
* Repair indexed bytea like operations, and related selectivityJoe Conway2003-12-07
| | | | | functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php
* Guard against bug in Solaris' bsearch(), per Michael Wildpaner.Tom Lane2003-12-05
|
* Planner failed to be smart about binary-compatible expressions in pathkeysTom Lane2003-12-03
| | | | | | and hash bucket-size estimation. Issue has been there awhile but is more critical in 7.4 because it affects varchar columns. Per report from Greg Stark.
* netmask() and hostmask() functions should return maximum-length masklen,Tom Lane2003-12-01
| | | | per gripe from Joe Sunday.
* Force zero_damaged_pages to be effectively ON during recovery from WAL,Tom Lane2003-12-01
| | | | | since there is no need to worry about damaged pages when we are going to overwrite them anyway from the WAL. Per recent discussion.
* Make PQescapeBytea and byteaout consistent with each other, andJoe Conway2003-11-30
| | | | | | octal escape all octets outside the range 0x20 to 0x7e. This fixes the problem pointed out by Sergey Yatskevich here: http://archives.postgresql.org/pgsql-bugs/2003-11/msg00140.php
* Second try at fixing no-room-to-move-down PANIC in compact_fsm_storage.Tom Lane2003-11-26
| | | | | | Ward's report that it can still happen in RC2 forces me to realize that this is not a can't-happen condition after all, and that the compaction code had better cope rather than panicking.
* Repair subselect.c's occasional assignment of the wrong vartypmod toTom Lane2003-11-25
| | | | | | | Vars created to fill subplan args lists. This is an ancient error, going back at least to 7.0, but is more easily triggered in 7.4 than before because we no longer compare varlevelsup when deciding whether a Param slot can be re-used. Fixes bug reported by Klint Gore.
* Band-aid solution for problems with SubPlans used in hash join clauses,Tom Lane2003-11-25
| | | | | | | | | | per report from Andrew Holm-Hansen. The difficulty arises from the fact that the planner allowed a Hash node's hashkeys to share substructure with the parent HashJoin node's hashclauses, plus some rather bizarre choices about who initializes what during executor startup. A cleaner but more invasive solution is to not store hashkeys separately in the plan tree at all, but let the HashJoin node deconstruct hashclauses during executor startup. I plan to fix it that way in HEAD.
* Overdue code review for ALTER SEQUENCE patch. Don't generate illegal NodeTom Lane2003-11-24
| | | | | | tree for CYCLE option; don't assume zeros are invalid values for sequence fields other than increment_by; don't reset cache_value when not told to; simplify code for testing whether to apply defaults.
* Repair missed renamings of show_statement_stats and show_executor_stats.Tom Lane2003-11-24
|
* Fix datetime input parsing to accept YYYY-MONTHNAME-DD and related syntaxes,Tom Lane2003-11-16
| | | | | | which had been unintentionally broken by recent changes to tighten up the DateStyle rules for all-numeric date input. Add documentation and regression tests for this, too.
* Translation update for last-minute changePeter Eisentraut2003-11-16
|
* Make creation of statistics collection socket more robust, by allowing itTom Lane2003-11-15
| | | | | to try additional addresses returned from getaddrinfo() if the first one fails at the bind() or connect() steps. Per yesterday's discussion.
* Translation updatesPeter Eisentraut2003-11-15
|
* Translation updatesPeter Eisentraut2003-11-14
|
* Default ioctlsocket_ret to 1 in case Cygwin needs it for 7.4 --- alreadyBruce Momjian2003-11-11
| | | | in HEAD.
* Correct misspellings of REFERENCES.Tom Lane2003-11-08
|
* Don't need hack copy of system() anymore in OS X 10.3.Tom Lane2003-11-08
|
* Fix process-status handling for OS X 10.3.Tom Lane2003-11-08
|
* Cause stats processes to detach from shared memory when started, so thatTom Lane2003-11-07
| | | | | they do not prevent the postmaster from deleting the shmem segment during a post-backend-crash restart cycle. Per recent discussion.
* zero_damaged_pages must absolutely NOT be marked GUC_DISALLOW_IN_FILE,Tom Lane2003-11-07
| | | | | else it cannot be used to handle failures detected during WAL replay. Fortunately this flag isn't actually enforced yet, but get it right.
* Fix for this problem:Tom Lane2003-11-05
| | | | | | | | | | | regression=# select 1 from tenk1 ta cross join tenk1 tb for update; ERROR: no relation entry for relid 3 7.3 said "SELECT FOR UPDATE cannot be applied to a join", which was better but still wrong, considering that 7.2 took the query just fine. Fix by making transformForUpdate() ignore JOIN and other special RTE types, rather than trying to mark them FOR UPDATE. The actual error message now only appears if you explicitly name the join in FOR UPDATE.
* Update future-tense comments in README to present tense. Noted byTom Lane2003-10-31
| | | | Neil Conway.
* When a superuser does GRANT or REVOKE on an object he doesn't own,Tom Lane2003-10-31
| | | | | | | | | process the command as though it were issued by the object owner. This prevents creating weird scenarios in which the same privileges may appear to flow from different sources, and ensures that a superuser can in fact revoke all privileges if he wants to. In particular this means that the regression tests work when run by a superuser other than the original bootstrap userid. Per report from Larry Rosenman.
* Fix for possible referential integrity violation when a qualified ON INSERTJan Wieck2003-10-31
| | | | | | | | rule split the query into one INSERT and one UPDATE where the UPDATE then hit's the just created row without modifying the key fields again. In this special case, the new key slipped in totally unchecked. Jan
* Fix some corner cases in ACL manipulation: don't foul up on an emptyTom Lane2003-10-29
| | | | | | ACL array, and force languages to be treated as owned by the bootstrap user ID. (pg_language should have a lanowner column, but until it does this will have to do as a workaround.)
* Give a useful error message if a RangeVar is encountered in an expression.Tom Lane2003-10-29
| | | | Per example from Ian Barwick, 28-Oct-03.
* compact_fsm_storage() does need to handle the case where a relation'sTom Lane2003-10-29
| | | | | FSM data has to be both moved down and compressed. Per report from Dror Matalon.
* Change Solaris tests to test for SHM_SHARE_MMU, per Tom.Bruce Momjian2003-10-27
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 01:03:16 +0000