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

Commit Graph

  • fe35ffe7e0 Major optimizer improvement for joining a large number of tables. Bruce Momjian 1999-02-09 03:51:42 +00:00
  • be948af2e8 Added LIMIT/OFFSET functionality including new regression test for it. Jan Wieck 1999-02-08 14:14:32 +00:00
  • 54e5d25666 Optimizer cleanup. Bruce Momjian 1999-02-08 04:29:25 +00:00
  • 07c33ba79e pg_dump -d or -D didn't quote special characters in INSERT data correctly. -D had problems with tables with inherited fields, also. Tom Lane 1999-02-08 01:46:28 +00:00
  • 566c712c58 Revert some changes from the INTERSECT/EXPECT patch that broke rule system semantics by having Var nodes referenced across multiple parsetrees when rules split them. Jan Wieck 1999-02-08 01:39:46 +00:00
  • bd422fbce2 Simplify scanstr(), fix broken octal-escape code. Tom Lane 1999-02-07 23:59:59 +00:00
  • f7c6a88c33 Simplify lexer's rules for string constants, eliminate potential buffer overrun. Tom Lane 1999-02-07 23:58:52 +00:00
  • 45ff93c460 Include -lcrypt when needed to link libpgtcl.so and plpgsql.so Tom Lane 1999-02-07 22:10:47 +00:00
  • afd57dbb3a Changed manpages for create_rule/drop_rule to the semantics of the rule system of v6.4 and descendants. Jan Wieck 1999-02-07 22:10:10 +00:00
  • fa0f24165c Add PQresStatus() function to avoid direct access to pgresStatus[] array, making life easier for Windoids... Tom Lane 1999-02-07 22:08:54 +00:00
  • f280266985 Clean up some minor compile warnings. Tom Lane 1999-02-07 22:07:02 +00:00
  • 5212ef8e46 Correct definition of srandom() --- it takes unsigned int not int. Tom Lane 1999-02-07 22:04:57 +00:00
  • a0071f1393 Back-patch freebsd4 and '. ./conftest.sh' fixes into REL6_4. Tom Lane 1999-02-07 19:37:23 +00:00
  • 04075a0c60 New gram.c after modification of gram.y Jan Wieck 1999-02-07 19:04:59 +00:00
  • 28fc5d7b83 Reenabled parentheses for grouping multiple rule actions and added this syntax to rules regression test so it will show up if someone breaks it again. Jan Wieck 1999-02-07 19:02:20 +00:00
  • cff91fedff Changed ExecConstraints() and ExecRelCheck() to cache constraint qualification trees in the execution state to avoid memory exhaustion on INSERT, UPDATE and COPY to tables with check constraints. This also speeds up those operations substantial because the nodeToString() for the constraints ccbin is only performed once per query. Jan Wieck 1999-02-07 16:50:55 +00:00
  • ef590e101e Changed ExecConstraints() and ExecRelCheck() to cache the constraints qualification expression trees in the execution state. Prevents from memory exhaustion on INSERT, UPDATE or COPY to tables that have CHECK constraints. Speedup against the variant using freeObject() is more than factor 2. Jan Wieck 1999-02-07 16:17:14 +00:00
  • ccf330d67e Fixed not free'd heap tuple if BEFORE DELETE trigger procedure returns new created tuple instead of the one given to it. Jan Wieck 1999-02-07 15:13:13 +00:00
  • dd4a357dc9 Missing semicolon in last fix :-} Jan Wieck 1999-02-07 14:20:11 +00:00
  • 6fa3d0a7ab One more fix to QuerySnapshot usage in ExecutorStart(). Maybe current QuerySnapshot could be NULL. Jan Wieck 1999-02-07 13:54:58 +00:00
  • a5f3abacb5 Fixed problem with multiple portals shown up in portals_p2 regression test after new AllocSet code. Jan Wieck 1999-02-07 13:37:56 +00:00
  • 65d320e7e4 Fix bracketing error in CaseExpr code Tom Lane 1999-02-07 03:02:21 +00:00
  • 65decc3402 Allow psql to do \p\g. Ingres does it, why not us? Bruce Momjian 1999-02-07 02:56:53 +00:00
  • 48fd9a2cc2 Add equality checking for T_Query so that we don't get complaints in UNION regress test. Probably still need some more node types to be handled here, but I'm done for the day... Tom Lane 1999-02-07 00:52:12 +00:00
  • 3fd3d028fb Add floating-point support to our emulation of snprintf so that EXPLAIN works again. Tom Lane 1999-02-06 21:51:03 +00:00
  • fd1afb7453 Fix silly typo causing SELECT INTO TABLE to sometimes be treated as SELECT INTO TEMP TABLE. Tom Lane 1999-02-06 20:28:11 +00:00
  • a553760845 Optimizer cleanup. Bruce Momjian 1999-02-06 17:29:30 +00:00
  • ead64f317b New alloc set code using a memory block pool for small allocations. Jan Wieck 1999-02-06 16:50:34 +00:00
  • 7d2b3874aa optimizer cleanup Bruce Momjian 1999-02-05 20:34:11 +00:00
  • 6e2edaf4b8 Optimizer cleanup. Bruce Momjian 1999-02-05 19:59:31 +00:00
  • d5db88142c Fix for returning stack pointer from selectivity, from Bernard Frankpitt. Bruce Momjian 1999-02-05 17:47:29 +00:00
  • f962514403 Reverse out const to libpq interface from D'Arcy. Bruce Momjian 1999-02-05 04:25:55 +00:00
  • d3a85108c2 Fix silly typo in prune_joinrel Tom Lane 1999-02-05 03:43:05 +00:00
  • c45e4925ab Optimizer cleanups. Bruce Momjian 1999-02-04 23:19:53 +00:00
  • ae12e25263 Update optimizer comments. Bruce Momjian 1999-02-04 19:20:12 +00:00
  • 19cc38b28d Large object write-into-middle fix from Tatsuo Ishii. Bruce Momjian 1999-02-04 14:52:00 +00:00
  • fc590b6f1a From: Michael Meskes <Michael.Meskes@usa.net> Marc G. Fournier 1999-02-04 04:58:05 +00:00
  • a03b817373 Const fixes from D'Arcy. Bruce Momjian 1999-02-04 03:20:39 +00:00
  • ce3afccf7f More optimizer cleanups. Bruce Momjian 1999-02-04 03:19:11 +00:00
  • 18fbe4142f More optimizer renaming HInfo -> HashInfo. Bruce Momjian 1999-02-04 01:47:02 +00:00
  • 9322950aa4 Cleanup of source files where 'return' or 'var =' is alone on a line. Bruce Momjian 1999-02-03 21:18:02 +00:00
  • 3982368a4e The libpq function PQfnumber does not handle case-insensitive comparisons correctly. The psql monitor converts all table and field names to lower case. If the PQfnumber function is called with a mixed case name, it will always return -1. Bruce Momjian 1999-02-03 20:19:10 +00:00
  • 8d9237d485 Optimizer rename ClauseInfo -> RestrictInfo. Update optimizer README. Bruce Momjian 1999-02-03 20:15:53 +00:00
  • f3a6b38e32 Sort node for ORDER BY is suppressed if choosen index scan will allways present tuples in the requested order. Jan Wieck 1999-02-03 19:31:24 +00:00
  • 724119a979 Modify int8 to not depend on sscanf(), and fix configure's test for int8 support. configure now checks only snprintf() for int8 support, not sprintf and sscanf as it used to. The reason for doing this is that if we are supplying our own snprintf code (which does handle long long int), we now only need working long long support in the compiler not in the platform's C library. I have verified that int8 now passes regression test on HPUX 9, and I think it should work on SunOS 4.1.* and other older platforms if gcc is used. Tom Lane 1999-02-03 00:18:53 +00:00
  • 4090d17fee SET_ARGS cleanup Bruce Momjian 1999-02-02 23:53:26 +00:00
  • f1b7823471 Make GEQO use dependent on table and index count. Bruce Momjian 1999-02-02 20:30:18 +00:00
  • eb3415538e OK I found it, I search in the planner for the '\xFF' appending. Finally I found in MakeIndexable() in gram.y Bruce Momjian 1999-02-02 19:20:54 +00:00
  • 2163d9e33e Add missing mb files. Bruce Momjian 1999-02-02 19:04:43 +00:00
  • a7ad43cd18 Included patches make some enhancements to the multi-byte support. Bruce Momjian 1999-02-02 18:51:40 +00:00
  • 8358a8f6a0 psql help fix. Bruce Momjian 1999-02-02 18:41:17 +00:00
  • 1b907ab8f5 Fix for psql help create table. Bruce Momjian 1999-02-02 18:39:23 +00:00
  • 8e958b8a38 Fix create_rule is->as. Bruce Momjian 1999-02-02 17:46:17 +00:00
  • 7ab88a16a1 Fixed failed assertion happening in multiple action rules when parsestate in makeRangeTable() already contains an opened p_target_relation. Jan Wieck 1999-02-02 12:57:51 +00:00
  • 92c6b5d7b9 Fixed failed assertion happening in multiple action rules when parsestate in makeRangeTable() already contains an opened p_target_relation. Jan Wieck 1999-02-02 12:56:55 +00:00
  • 4390b0bfbe Add TEMP tables/indexes. Add COPY pfree(). Other cleanups. Bruce Momjian 1999-02-02 03:45:56 +00:00
  • 7fc75517df Fixed growing of backend due to not pfree()'d data on COPY FROM Jan Wieck 1999-02-01 20:25:55 +00:00
  • 072be47202 Initialize es_snapshot. Vadim B. Mikheev 1999-02-01 13:33:27 +00:00
  • 757f403451 Tighten coding in samekeys(). Pretty braindead change, but it saves almost 10% of the runtime in Charles Hornberger's optimizer example, so what the heck ... Tom Lane 1999-02-01 04:20:50 +00:00
  • 6ca2bf6534 freebsd4.0 needed to be added to configure... Marc G. Fournier 1999-02-01 02:52:23 +00:00
  • 91fed81c77 From: Michael Meskes <Michael.Meskes@usa.net> Marc G. Fournier 1999-01-31 19:56:28 +00:00
  • f7c4ec5085 From: D'Arcy J.M. Cain <darcy@druid.net> Marc G. Fournier 1999-01-31 05:04:25 +00:00
  • 36c1895533 Fix postmaster to not try to start more than MaxBackendId children, per patch from Tatsuo Ishii Tom Lane 1999-01-30 20:04:37 +00:00
  • bfa6d510b3 Small fix for READ COMMITTED isolevel. Vadim B. Mikheev 1999-01-29 13:24:36 +00:00
  • aaef7beb79 Hope that execMain.c good merged. Fix for BEFORE ROW UPDATE triggers: result tuple may be different (due to concurrent update) from one initially produced by top level plan. Vadim B. Mikheev 1999-01-29 11:56:01 +00:00
  • 1d41e88568 Trying to fix bad merging... Vadim B. Mikheev 1999-01-29 10:15:09 +00:00
  • e3a1ab764e READ COMMITTED isolevel is implemented and is default now. Vadim B. Mikheev 1999-01-29 09:23:17 +00:00
  • 3e2f87f3f3 Changed qualification of pg_views and pg_tables to directly check if a rewrite rule on SELECT exists/not exists instead of asking pg_get_viewdef() function. Jan Wieck 1999-01-28 15:28:40 +00:00
  • 51e8a1d390 New prebuilt versions of gram.c and scan.c for the mixed case identifier support. Jan Wieck 1999-01-28 11:50:42 +00:00
  • c42b959fb3 Partial support for mixed case in PL/pgSQL. Left are identifiers that contain non-alnum/_ chars. So e.g. whitespaces in identifiers are still not supported. Jan Wieck 1999-01-28 11:48:31 +00:00
  • b946244c1c Quick fix for subplan-related crash. Tom Lane 1999-01-27 16:48:20 +00:00
  • 28d8b42ca5 Speedup of PL/pgSQL by calling ExecEvalExpr() directly instead of SPI_execp() for simple expressions. Jan Wieck 1999-01-27 16:15:22 +00:00
  • d611ccb874 fix for aggregates Bruce Momjian 1999-01-27 16:15:01 +00:00
  • 2ae5d51668 From: Tatsuo Ishii <t-ishii@sra.co.jp> Marc G. Fournier 1999-01-27 01:18:23 +00:00
  • e27f8791f9 Turns out it's easy to cache the fmgr function lookup result, too ... another little bit of speed for SELECT. Tom Lane 1999-01-27 01:11:43 +00:00
  • 422221c90d Another SELECT speedup: extract OIDs of column print functions only once per SELECT, not once per tuple. 10% here, 10% there, pretty soon you're talking about real speedups ... Tom Lane 1999-01-27 00:36:28 +00:00
  • 36693c0525 More agg cleanup. Bruce Momjian 1999-01-26 23:32:04 +00:00
  • 38a5bda208 primary key support cleanups from D'Arcy... Marc G. Fournier 1999-01-26 14:38:52 +00:00
  • 692a65e6ff pgindent file. Bruce Momjian 1999-01-26 05:57:14 +00:00
  • 2ee522954d From: Peter T Mount <peter@retep.org.uk> Marc G. Fournier 1999-01-25 21:22:06 +00:00
  • 1401f63dd1 Agg/Aggreg cleanup and datetime.sql patch. Bruce Momjian 1999-01-25 18:02:28 +00:00
  • 247b3f9054 SELECT FOR UPDATE is implemented... Vadim B. Mikheev 1999-01-25 12:01:19 +00:00
  • 443e24beb7 Tighten coding of fmgr_isbuiltin() ... managed to speed it up by about 10% which seems to be good for half a percent or so of a SELECT. Tom Lane 1999-01-25 00:44:53 +00:00
  • 49b6be244c Tighten coding of inner loops in nocachegetattr ... seems to have improved speed of routine by 5% or so ... Tom Lane 1999-01-24 22:53:25 +00:00
  • 18577547d4 Use heap_attisnull, rather than heap_getattr, for a small but useful speedup. Tom Lane 1999-01-24 22:50:58 +00:00
  • d03e98737c Replace typtoout() and gettypelem() with a single routine, so that fetching an attribute value needs only one SearchSysCacheTuple call instead of two redundant searches. This speeds up a large SELECT by about ten percent, and probably will help GROUP BY and SELECT DISTINCT too. Tom Lane 1999-01-24 05:40:49 +00:00
  • 77f5428244 Fix a couple little problems with signed vs. unsigned characters ... Tom Lane 1999-01-24 02:47:15 +00:00
  • 17467bb7fb Rename Aggreg to Aggref. Bruce Momjian 1999-01-24 00:28:37 +00:00
  • 157349e3af Improper addition of NaN/Infinity recognition to float8in() was causing it not to detect out-of-range float values, as evidenced by failure of float8 regression test. I corrected that logic and also modified expected float8 results to account for new error message generated for out-of-range inputs. Tom Lane 1999-01-24 00:12:59 +00:00
  • 598a4e15dd Remove unused Choose node. Bruce Momjian 1999-01-23 23:28:09 +00:00
  • e6725d1574 Add explicit buffering in backend libpq, to compensate for buffering lost by not going through stdio anymore for client I/O. Tom Lane 1999-01-23 22:27:29 +00:00
  • 13c7c183f7 Fix unportable test syntax in regression script. Tom Lane 1999-01-23 21:36:00 +00:00
  • 598b628b27 Fix for intersect FOR UPDATE check. Bruce Momjian 1999-01-22 19:35:54 +00:00
  • 15871b48c4 Relcache Size fix. Bruce Momjian 1999-01-22 18:47:37 +00:00
  • 753c9cb9dd Fix for Size sizeof in cache code. Bruce Momjian 1999-01-22 16:49:25 +00:00
  • 8135140a3e |From: "D'Arcy" "J.M." Cain <darcy@druid.net> | |The following patch just prevents a warning from being generated because |the data type isn't specified. Marc G. Fournier 1999-01-22 13:28:50 +00:00
  • 03155dc764 It seems that SPI_prepare() doesn't work well in some cases. Bruce Momjian 1999-01-21 22:55:41 +00:00
  • 289a826dab Here is a new version of my patch for allowing pg_dump to DROP schema elements prior to CREATEing new ones. It is under control of the -c command line option (with the default being status quo). Bruce Momjian 1999-01-21 22:53:37 +00:00
  • c91dbcc5c7 The following patch finishes primary key support. Previously, when a field was labelled as a primary key, the system automatically created a unique index on the field. This patch extends it so that the index has the indisprimary field set. You can pull a list of primary keys with the followiing select. Bruce Momjian 1999-01-21 22:48:20 +00:00
  • 7311da9ec4 i have made minor changes to array_iterator to make it work with pgsql-6.3.2. I think array_iterator is a great thing to have!!! Bruce Momjian 1999-01-21 22:40:16 +00:00