From ae93e5fd6e8a7e2321e87d23165d9d7660cde598 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 5 Jun 2004 01:55:05 +0000 Subject: Make the world very nearly safe for composite-type columns in tables. 1. Solve the problem of not having TOAST references hiding inside composite values by establishing the rule that toasting only goes one level deep: a tuple can contain toasted fields, but a composite-type datum that is to be inserted into a tuple cannot. Enforcing this in heap_formtuple is relatively cheap and it avoids a large increase in the cost of running the tuptoaster during final storage of a row. 2. Fix some interesting problems in expansion of inherited queries that reference whole-row variables. We never really did this correctly before, but it's now relatively painless to solve by expanding the parent's whole-row Var into a RowExpr() selecting the proper columns from the child. If you dike out the preventive check in CheckAttributeType(), composite-type columns now seem to actually work. However, we surely cannot ship them like this --- without I/O for composite types, you can't get pg_dump to dump tables containing them. So a little more work still to do. --- src/backend/optimizer/path/costsize.c | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (limited to 'src/backend/optimizer/path/costsize.c') diff --git a/src/backend/optimizer/path/costsize.c b/src/backend/optimizer/path/costsize.c index 46a323fade..53bd8bdf5c 100644 --- a/src/backend/optimizer/path/costsize.c +++ b/src/backend/optimizer/path/costsize.c @@ -49,7 +49,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/optimizer/path/costsize.c,v 1.129 2004/06/01 03:02:52 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/optimizer/path/costsize.c,v 1.130 2004/06/05 01:55:04 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1704,11 +1704,18 @@ set_rel_width(Query *root, RelOptInfo *rel) foreach(tllist, rel->reltargetlist) { Var *var = (Var *) lfirst(tllist); - int ndx = var->varattno - rel->min_attr; + int ndx; Oid relid; int32 item_width; - Assert(IsA(var, Var)); + /* For now, punt on whole-row child Vars */ + if (!IsA(var, Var)) + { + tuple_width += 32; /* arbitrary */ + continue; + } + + ndx = var->varattno - rel->min_attr; /* * The width probably hasn't been cached yet, but may as well -- cgit v1.2.1