hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-20 21:37:11 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 3752e85bad Determine the set of constraints applied to a domain at executor startup, not in the parser; this allows ALTER DOMAIN to work correctly with domain constraint operations stored in rules. Rod Taylor; code review by Tom Lane. Tom Lane 2003-02-03 21:15:45 +00:00
  • caa72ad57f Add mention of CURRENT_SCHEMA for object creation. REL7_3_2 Bruce Momjian 2003-02-03 15:57:03 +00:00
  • 464598b637 Add mention of CURRENT_SCHEMA for object creation. Bruce Momjian 2003-02-03 15:56:50 +00:00
  • 6b196c0754 Don't print NO ACTION foreign key actions in dumps and psql \d. Bruce Momjian 2003-02-03 15:17:24 +00:00
  • 4cff59d8d5 Tweak planner and executor to avoid doing ExecProject() in table scan nodes where it's not really necessary. In many cases where the scan node is not the topmost plan node (eg, joins, aggregation), it's possible to just return the table tuple directly instead of generating an intermediate projection tuple. In preliminary testing, this reduced the CPU time needed for 'SELECT COUNT(*) FROM foo' by about 10%. Tom Lane 2003-02-03 15:07:08 +00:00
  • 0d3e36b668 Move pg_service.conf.sample to /interfaces/libpq. Bruce Momjian 2003-02-03 14:24:07 +00:00
  • 802a4d4111 Change MOVE LAST to MOVE ALL. Bruce Momjian 2003-02-03 14:04:24 +00:00
  • c7bceca156 Implement EXPLAIN EXECUTE. By Neil Conway, with some kibitzing from Tom Lane. Tom Lane 2003-02-02 23:46:38 +00:00
  • 0f36c544d9 Brand 7.3.2. Tom Lane 2003-02-02 19:56:46 +00:00
  • 84fdea1be7 Update release history for 7.3.2. Tom Lane 2003-02-02 19:48:30 +00:00
  • 6adb475f77 Update release history for 7.3.2. Tom Lane 2003-02-02 19:48:20 +00:00
  • e59750d684 Fix nodeUnique to behave correctly when reversing direction after reaching either end of subplan results. This prevents misbehavior of cursors on SELECT DISTINCT ... queries. Per bug report 1-Feb-02. Tom Lane 2003-02-02 19:09:08 +00:00
  • 967e8a37ab Fix nodeUnique to behave correctly when reversing direction after reaching either end of subplan results. This prevents misbehavior of cursors on SELECT DISTINCT ... queries. Per bug report 1-Feb-02. Tom Lane 2003-02-02 19:08:57 +00:00
  • d77c6396bb Remove restriction that cast functions cannot be volatile. This restriction was debatable to begin with, but it has now become obvious that it breaks forward-porting of user-defined types; contrib/lo being the most salient example. Tom Lane 2003-02-01 22:09:41 +00:00
  • 6ba8af9d5d Remove restriction that cast functions cannot be volatile. This restriction was debatable to begin with, but it has now become obvious that it breaks forward-porting of user-defined types; contrib/lo being the most salient example. Tom Lane 2003-02-01 22:09:26 +00:00
  • af30b95618 Cleaner solution to the problem of loading pre-7.3 dumps containing columns of type lo (see contrib/lo). Rather than hacking the function definitions on-the-fly, just modify the queries issued by FixupBlobRefs so that they work even if CREATE CAST hasn't been issued. Tom Lane 2003-02-01 22:07:14 +00:00
  • e0a1ee2053 Cleaner solution to the problem of loading pre-7.3 dumps containing columns of type lo (see contrib/lo). Rather than hacking the function definitions on-the-fly, just modify the queries issued by FixupBlobRefs so that they work even if CREATE CAST hasn't been issued. Tom Lane 2003-02-01 22:06:59 +00:00
  • 90ad65a8ab Changes of 6-Sep-02 broke pg_restore's ability to recognize tar-format files. Fix it. Tom Lane 2003-02-01 19:29:26 +00:00
  • 330b4e4215 Changes of 6-Sep-02 broke pg_restore's ability to recognize tar-format files. Fix it. Tom Lane 2003-02-01 19:29:16 +00:00
  • c80184552f Fix assign_session_authorization() to not be confused by all-numeric user names. Per recent reports. Tom Lane 2003-02-01 18:31:37 +00:00
  • 21166170c8 Fix assign_session_authorization() to not be confused by all-numeric user names. Per recent reports. Tom Lane 2003-02-01 18:31:28 +00:00
  • 3be050da32 Prevent core dump from calling Tcl_DontCallWhenDeleted() with a null interp pointer. Per report from Gerhard Hintermayer. Tom Lane 2003-02-01 00:22:23 +00:00
  • 361eaa185f Prevent core dump from calling Tcl_DontCallWhenDeleted() with a null interp pointer. Per report from Gerhard Hintermayer. Tom Lane 2003-02-01 00:22:12 +00:00
  • a85d1d5468 Apply ljb's patch to prevent both memory leak and core dump during connection shutdown. This is a grotty workaround for a Tcl bug, but said bug has been there long enough that I'm not holding my breath for a real fix. Per discussions and testing from ljb and g.hintermayer. Tom Lane 2003-02-01 00:07:19 +00:00
  • 032235cafe Apply ljb's patch to prevent both memory leak and core dump during connection shutdown. This is a grotty workaround for a Tcl bug, but said bug has been there long enough that I'm not holding my breath for a real fix. Per discussions and testing from ljb and g.hintermayer. Tom Lane 2003-02-01 00:07:03 +00:00
  • c8d7686c70 Make plpython's spi_execute interface handle NULLs properly. From Andrew Bosma. Tom Lane 2003-01-31 22:35:27 +00:00
  • f51c7ca182 Make plpython's spi_execute interface handle NULLs properly. From Andrew Bosma. Tom Lane 2003-01-31 22:35:24 +00:00
  • 4ff31fbd01 Clean up plpython error reporting so that its regression test passes with some amount of cleanliness. I see no need to report the internal Python name rather than the SQL procedure name in error tracebacks. Tom Lane 2003-01-31 22:25:18 +00:00
  • 6f49703f0e Clean up plpython error reporting so that its regression test passes with some amount of cleanliness. I see no need to report the internal Python name rather than the SQL procedure name in error tracebacks. Tom Lane 2003-01-31 22:25:14 +00:00
  • b52fe8dcc8 Tweak bison build rules so that we get the same error messages from bison 1.875 and later as we did from earlier bison releases. Eventually we will probably want to adopt the newer message spelling ... but not yet. Per recent discussion on pgpatches. Note: I didn't change the build rules for bootstrap, ecpg, or plpgsql grammars, since these do not affect regression test results. Tom Lane 2003-01-31 20:58:28 +00:00
  • 9d00798720 Tweak bison build rules so that we get the same error messages from bison 1.875 and later as we did from earlier bison releases. Eventually we will probably want to adopt the newer message spelling ... but not yet. Per recent discussion on pgpatches. Note: I didn't change the build rules for bootstrap, ecpg, or plpgsql grammars, since these do not affect regression test results. Tom Lane 2003-01-31 20:58:00 +00:00
  • bd96dd1184 Allow a time zone to be specified (and silently ignored) in the input for type 'time without time zone', as we already did for type 'timestamp without time zone'. This patch was proposed by Tom Lockhart on 7-Nov-02, but he never got around to applying it. Adjust regression tests and documentation to match. Tom Lane 2003-01-31 01:08:08 +00:00
  • bb0c948bb0 Handle mixed-case names properly in plpgsql_parse_tripwordtype. From Neil Conway. Tom Lane 2003-01-31 00:32:00 +00:00
  • 37b247a5e9 Handle mixed-case names properly in plpgsql_parse_tripwordtype. From Neil Conway. Tom Lane 2003-01-31 00:31:53 +00:00
  • 0de771dd5c Fix typo, per Neil Conway. Tom Lane 2003-01-31 00:10:51 +00:00
  • 5c508b7da1 Fix regression in .pgpass support. From Neil Conway. Tom Lane 2003-01-30 19:50:07 +00:00
  • 4ec457ad58 Fix regression in .pgpass support. From Neil Conway. Tom Lane 2003-01-30 19:49:54 +00:00
  • 887edf4ff7 Update release history for 7.2.4. Tom Lane 2003-01-29 22:14:08 +00:00
  • cc16e49789 Update release history for 7.2.4. Tom Lane 2003-01-29 22:13:56 +00:00
  • 895491bc22 Brand 7.2.4. REL7_2_4 Tom Lane 2003-01-29 22:13:19 +00:00
  • d106c799e6 Update release history for 7.2.4. Tom Lane 2003-01-29 22:12:42 +00:00
  • dd10354587 Back-patch fix to avoid integer overflow in ExecHashJoinGetBatch(), which leads to core dump in large-enough hash joins. Tom Lane 2003-01-29 19:37:23 +00:00
  • d6242b373b SPI_exec shouldn't return SPI_OK_SELECT if it hasn't actually returned a tuple table. Fixes core dump in pltcl (and probably other PLs) when executing a query rewritten by a rule. Per bug report from Wolfgang Walter. Tom Lane 2003-01-29 15:24:57 +00:00
  • 26f56131ae SPI_exec shouldn't return SPI_OK_SELECT if it hasn't actually returned a tuple table. Fixes core dump in pltcl (and probably other PLs) when executing a query rewritten by a rule. Per bug report from Wolfgang Walter. Tom Lane 2003-01-29 15:24:46 +00:00
  • 6976205b4b Update release steps. Bruce Momjian 2003-01-29 03:41:54 +00:00
  • 5fdb142f16 Tweak ArrayCount() to forestall possible access to temp[-1]. Problem cannot actually happen at present because ArrayCount() is only called on strings beginning with '{', but seems best to prevent it going forward. Per report from Yichen Xie. Tom Lane 2003-01-29 01:28:33 +00:00
  • 3cb282f3e6 Guard against array overrun, per report from Yichen Xie. This case can only occur if the constant DEFAULT_CLIENT_AUTHSVC is given a bogus value, so it doesn't seem worth back-patching, but I'll fix it in HEAD. Tom Lane 2003-01-29 01:18:21 +00:00
  • 726b7f3b3c Repair array subscript overrun identified by Yichen Xie. Reduce the value of MAX_TIME_PRECISION in floating-point-timestamp-storage case from 13 to 10, which is as much as time_out is actually willing to print. (The alternative of increasing the number of digits we are willing to print looks risky; we might find ourselves printing roundoff garbage.) Tom Lane 2003-01-29 01:09:03 +00:00
  • 23b8a0ce61 Repair array subscript overrun identified by Yichen Xie. Reduce the value of MAX_TIME_PRECISION in floating-point-timestamp-storage case from 13 to 10, which is as much as time_out is actually willing to print. (The alternative of increasing the number of digits we are willing to print looks risky; we might find ourselves printing roundoff garbage.) Tom Lane 2003-01-29 01:08:42 +00:00
  • 8672494da5 Fix array subscript overruns identified by Yichen Xie. Tom Lane 2003-01-29 01:01:15 +00:00
  • b8add56ed0 Fix array subscript overruns identified by Yichen Xie. Tom Lane 2003-01-29 01:01:05 +00:00
  • 2e46b762eb Extend join-selectivity API (oprjoin interface) so that join type is passed to join selectivity estimators. Make use of this in eqjoinsel to derive non-bogus selectivity for IN clauses. Further tweaking of cost estimation for IN. initdb forced because of pg_proc.h changes. Tom Lane 2003-01-28 22:13:41 +00:00
  • 955a1f81a7 Factor out the code that detects the long long int snprintf format into a separate macro. Also add support for %I64d which is the way on Windows. Peter Eisentraut 2003-01-28 21:57:12 +00:00
  • c95ed02c49 Convert variable name to canonical spelling before checking for matches in GUCArrayAdd/GUCArrayDelete. This prevents the multiple-entry bug exhibited by Frank Lupo 28-Jan-2003. Tom Lane 2003-01-28 18:04:13 +00:00
  • c0276244b1 Convert variable name to canonical spelling before checking for matches in GUCArrayAdd/GUCArrayDelete. This prevents the multiple-entry bug exhibited by Frank Lupo 28-Jan-2003. Tom Lane 2003-01-28 18:04:02 +00:00
  • 93c3f36d22 Revert off setting mention for client_min_messages. Bruce Momjian 2003-01-28 03:44:09 +00:00
  • 7af352d091 Revert off setting mention for client_min_messages. Bruce Momjian 2003-01-28 03:43:47 +00:00
  • f21fb30dfc Revert optimizer page count change. Bruce Momjian 2003-01-28 03:34:29 +00:00
  • bd175cc9fb Set log_min_error_messages to the proper and agreed-upon default, PANIC (off). Bruce Momjian 2003-01-27 23:55:38 +00:00
  • d42a476621 Add blank line. Bruce Momjian 2003-01-27 23:19:18 +00:00
  • c177ba99bd Move: Bruce Momjian 2003-01-27 23:16:52 +00:00
  • 9b9b14915b Fix typo 233 pages -> 333 pages. Bruce Momjian 2003-01-27 22:40:56 +00:00
  • 70fba70430 Upgrade cost estimation for joins, per discussion with Bradley Baetz. Try to model the effect of rescanning input tuples in mergejoins; account for JOIN_IN short-circuiting where appropriate. Also, recognize that mergejoin and hashjoin clauses may now be more than single operator calls, so we have to charge appropriate execution costs. Tom Lane 2003-01-27 20:51:54 +00:00
  • b2773d4099 Remove mention of 6.5 max backends. Bruce Momjian 2003-01-27 06:25:03 +00:00
  • 33875872fd Get rid of last few unadorned 'permission denied' messages. Tom Lane 2003-01-27 00:51:06 +00:00
  • 938a562d22 Prevent core dump when die_horribly() is called with null AH pointer. Problem reported and fixed by Oliver Elphick. Tom Lane 2003-01-27 00:23:49 +00:00
  • 4b833d080b Prevent core dump when die_horribly() is called with null AH pointer. Problem reported and fixed by Oliver Elphick. Tom Lane 2003-01-27 00:23:38 +00:00
  • 2357fd166f Back-patch fixes to detoast pg_group.grolist. Tom Lane 2003-01-26 23:16:23 +00:00
  • 12fa07750e Back-patch fixes to ensure t_ctid always has correct value (prevents some instances of 'No one parent tuple' VACUUM error, and perhaps worse things). Tom Lane 2003-01-26 23:09:37 +00:00
  • 3c877e57f3 Back-patch fix for alphabetization mistakes in datetime token tables. Tom Lane 2003-01-26 22:33:16 +00:00
  • 4dc2bceef4 Mark IN performance problem as fixed in 7.4 Bruce Momjian 2003-01-26 02:43:55 +00:00
  • dc87ea755c Include IPv6 addresses in pg_hba.conf even if IPv6 is not supported; at suggestion of Peter. Bruce Momjian 2003-01-26 01:19:22 +00:00
  • 677d77817d Add: Bruce Momjian 2003-01-26 01:13:34 +00:00
  • 9f5f212475 Allow the planner to collapse explicit inner JOINs together, rather than necessarily following the JOIN syntax to develop the query plan. The old behavior is still available by setting GUC variable JOIN_COLLAPSE_LIMIT to 1. Also create a GUC variable FROM_COLLAPSE_LIMIT to control the similar decision about when to collapse sub-SELECT lists into their parent lists. (This behavior existed already, but the limit was always GEQO_THRESHOLD/2; now it's separately adjustable.) Tom Lane 2003-01-25 23:10:30 +00:00
  • 15ab7a8720 Where available, use utime() or utimes() to update the file mod time of the socket file and socket lock file; this should prevent both of them from being removed by even the stupidest varieties of /tmp-cleaning script. Per suggestion from Giles Lean. Tom Lane 2003-01-25 05:19:47 +00:00
  • 80727ce14f Use stat(2) to probe for existing xlog segments in InstallXLogFileSegment, rather than actually opening the files. This eliminates some corner cases where the file indeed exists but open() fails for another reason, such as being out of file descriptors. The net reliability gain is probably tiny, since xlog.c is full of other file open calls that will elog(PANIC) if they fail for any reason; but this specific failure mode has been observed in the field, so we may as well fix it. Tom Lane 2003-01-25 03:06:04 +00:00
  • 7a196bab23 Suppress gcc warnings. Tom Lane 2003-01-24 21:53:29 +00:00
  • a307ee1ccb Back-patch fix for not shell-quoting editor name, as it also fixes silly buffer overrun (someone needs to learn to count characters...) Tom Lane 2003-01-24 05:23:55 +00:00
  • f5e83662d0 Modify planner's implied-equality-deduction code so that when a set of known-equal expressions includes any constant expressions (including Params from outer queries), we actively suppress any 'var = var' clauses that are or could be deduced from the set, generating only the deducible 'var = const' clauses instead. The idea here is to push down the restrictions implied by the equality set to base relations whenever possible. Once we have applied the 'var = const' clauses, the 'var = var' clauses are redundant, and should be suppressed both to save work at execution and to avoid double-counting restrictivity. Tom Lane 2003-01-24 03:58:44 +00:00
  • ef7422510e Grant options, and cascading revoke. Grant options are allowed only for users right now, not groups. Extension of has_foo_privileges functions to query the grant options. Extension of aclitem type to store grantor. Peter Eisentraut 2003-01-23 23:39:07 +00:00
  • aa78ca3a95 added fix from Joel Hock to get the inserted row into the current buffer Dave Cramer 2003-01-23 18:49:22 +00:00
  • a825ad2bda Fix obsolete error message (isImmutable doesn't exist). Tom Lane 2003-01-23 15:18:50 +00:00
  • 36777c1e35 Fix obsolete error message (isImmutable doesn't exist). Tom Lane 2003-01-23 15:18:40 +00:00
  • 01376c215c Change CREATE TABLE AS / SELECT INTO to create the new table with OIDs, for backwards compatibility with pre-7.3 behavior. Per discussion on pgsql-general and pgsql-hackers. Tom Lane 2003-01-23 05:10:57 +00:00
  • 790d5bc992 Change CREATE TABLE AS / SELECT INTO to create the new table with OIDs, for backwards compatibility with pre-7.3 behavior. Per discussion on pgsql-general and pgsql-hackers. Tom Lane 2003-01-23 05:10:41 +00:00
  • d73531209c Update 'Mathematical Functions' table to reflect 7.3 addition of float8 forms of ceil(), floor(), sign(). Back-patch this and other recent doc fixes in this file to the 7.3 branch. Tom Lane 2003-01-23 01:23:14 +00:00
  • 742403bdad Update 'Mathematical Functions' table to reflect 7.3 addition of float8 forms of ceil(), floor(), sign(). Back-patch this and other recent doc fixes in this file to the 7.3 branch. Tom Lane 2003-01-23 01:22:59 +00:00
  • b3d7af46a9 Fix sloppy comment. Tom Lane 2003-01-22 20:44:20 +00:00
  • c0f8da118b Make estimation of mergejoin scan selectivities more robust, per recent example from RaÇl GutiÅrrez. Tom Lane 2003-01-22 20:17:07 +00:00
  • c4d0ff32e9 Make estimation of mergejoin scan selectivities more robust, per recent example from RaÇl GutiÅrrez. Tom Lane 2003-01-22 20:16:42 +00:00
  • c7b4047234 Improve print_expr() a little. It's still not very bright though. Tom Lane 2003-01-22 19:26:35 +00:00
  • e2114817c7 Implement choice between hash-based and sort-based grouping for doing DISTINCT processing on the output of an IN sub-select. Tom Lane 2003-01-22 00:07:00 +00:00
  • 1f74045675 Fix coredump problem in plpgsql's RETURN NEXT. When a SELECT INTO that's selecting into a RECORD variable returns zero rows, make it assign an all-nulls row to the RECORD; this is consistent with what happens when the SELECT INTO target is not a RECORD. In support of this, tweak the SPI code so that a valid tuple descriptor is returned even when a SPI select returns no rows. Tom Lane 2003-01-21 22:06:36 +00:00
  • a4482f4c4c Fix coredump problem in plpgsql's RETURN NEXT. When a SELECT INTO that's selecting into a RECORD variable returns zero rows, make it assign an all-nulls row to the RECORD; this is consistent with what happens when the SELECT INTO target is not a RECORD. In support of this, tweak the SPI code so that a valid tuple descriptor is returned even when a SPI select returns no rows. Tom Lane 2003-01-21 22:06:12 +00:00
  • f8d8266ac5 Synced parser. Michael Meskes 2003-01-21 20:01:12 +00:00
  • 08b798e2ba Back-patch typprtlen fix, two other minor post-7.3 fixes. Tom Lane 2003-01-21 19:57:50 +00:00
  • adf852ba4a Back-patch fix to ensure pg_clog updates are not only written but sync'ed before we consider the checkpoint to be done. Tom Lane 2003-01-21 19:51:42 +00:00
  • 1a7c6ee8c6 Avoid gratuitous variation in spelling of same error message. Tom Lane 2003-01-21 19:44:26 +00:00
  • 0c3cf79244 Back-patch fixes for integer overflows in circle_poly(), path_encode(), and path_add() --- from Neil Conway. Also, repair recently-detected errors in lseg_eq(), lseg_ne(), lseg_center(). Tom Lane 2003-01-21 19:41:26 +00:00
  • 474f1130c6 Back-patch fix for VACUUM being confused by SELECT FOR UPDATE of tuple that was previously outdated by a transaction that later aborted. Also, prevent VACUUM from being called inside function. Tom Lane 2003-01-21 19:38:21 +00:00