| Commit message (Collapse) | Author | Age |
... | |
|
|
|
| |
for Irix.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
after ExecEndNode. It must be done! Or we'll be out of free
tuple slots very soon, though slots are freed by ExecEndNode
and ready for reusing.
We didn't see this problem before because of
int nSlots = ExecCountSlotsNode(plan);
TupleTable tupleTable = ExecCreateTupleTable(nSlots + 10);
/* why add ten? - jolly */
code in InitPlan - i.e. extra 10 slots. Simple select uses
3 slots and so it was possible to re-use evaluation plan
3 additional times and didn't get
elog(NOTICE, "Plan requires more slots than are available");
elog(ERROR, "send mail to your local executor guru to fix this");
Changes are obvious and shouldn't be problems with them.
Though, I added Assert(epqstate->es_tupleTable->next == 0)
before EvalPlanQual():ExecInitNode and we'll notice if
something is still wrong. Is it better to change Assert
to elog(ERROR) ?
|
|
|
|
|
| |
EvalPlanQualNext() when implemented it... -:)
Uncommented...
|
| |
|
| |
|
|
|
|
| |
real affect now.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
| |
change functionality, but makes the code more ANSI C'ish.
My AIX xlc compiler barfs on all of these. Can someone please
review and apply to current.
<<port.patch>>
Thanks
Andreas
|
| |
|
|
|
|
|
|
| |
Ok. I made patches replacing all of "#if FALSE" or "#if 0" to "#ifdef
NOT_USED" for current. I have tested these patches in that the
postgres binaries are identical.
|
| |
|
|
|
|
|
|
|
| |
Removed CURRENT keyword for rule queries and changed rules regression
accordingly. CURRENT has beed announced to disappear in v6.5.
Jan
|
|
|
|
|
|
|
|
|
| |
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
|
|
|
|
| |
Jan
|
|
|
|
|
|
| |
current QuerySnapshot could be NULL.
Jan
|
|
|
|
|
|
|
|
| |
test after new AllocSet code.
Activated optimal AllocSet blocksize and chunk limit.
Jan
|
|
|
|
| |
Jan
|
| |
|
| |
|
|
|
|
|
| |
Fix for BEFORE ROW UPDATE triggers: result tuple may be different
(due to concurrent update) from one initially produced by top level plan.
|
| |
|
| |
|
| |
|
|
|
|
|
| |
only once per SELECT, not once per tuple. 10% here, 10% there,
pretty soon you're talking about real speedups ...
|
| |
|
|
|
|
|
| |
LOCK TABLE IN ... MODE
...implemented
|
| |
|
|
|
|
| |
New code for locking buffer' context.
|
| |
|
| |
|
|
|
|
|
|
| |
planner/optimizer/executor. It isn't.
Besides, most of the removed code consists of comments about how
it's not right.
|
|
|
|
| |
Modify comment blocks to insulate from pgindent.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
no longer returns buffer pointer, can be gotten from scan;
descriptor; bootstrap can create multi-key indexes;
pg_procname index now is multi-key index; oidint2, oidint4, oidname
are gone (must be removed from regression tests); use System Cache
rather than sequential scan in many places; heap_modifytuple no
longer takes buffer parameter; remove unused buffer parameter in
a few other functions; oid8 is not index-able; remove some use of
single-character variable names; cleanup Buffer variables usage
and scan descriptor looping; cleaned up allocation and freeing of
tuples; 18k lines of diff;
|
|
|
|
| |
files. Fix sequence creation hack for relkind type.
|
| |
|
| |
|
|
|
|
| |
not in target list.
|
| |
|
| |
|
|
|
|
|
| |
Here is a patch to remove the requirement that ORDER/GROUP BY clause
identifiers be included in the target list.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
below is the patch to have views to override the permission
checks for the accessed tables. Now we can do the following:
CREATE VIEW db_user AS SELECT
usename,
usesysid,
usecreatedb,
usetrace,
usecatupd,
'**********'::text as passwd,
valuntil
FROM pg_user;
REVOKE ALL ON pg_user FROM public;
REVOKE ALL ON db_user FROM public;
GRANT SELECT ON db_user TO public;
|
|
|
|
|
|
|
| |
ExecReScan for nodeAgg, nodeHash, nodeHashjoin, nodeNestloop and nodeResult.
Fixed ExecReScan for nodeMaterial.
Get rid of #ifdef INDEXSCAN_PATCH.
Get rid of ExecMarkPos and ExecRestrPos in nodeNestloop.
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
| |
varchar length.
Cleans up code so attlen is always length.
Removed varchar() hack added earlier.
Will fix bug in selecting varchar() fields, and varchar() can be
variable length.
|