Re: cuando creo una tabla quiero añadir un campo int4 nombrado cflavia "al vuelo"

Te entendi la idea introduje en el parsenodes.h esto:

typedef struct CreateStmt
{
NodeTag type;
RangeVar *relation; /* relation to create */
List *tableElts; /* column definitions (list of ColumnDef)
*/
List *inhRelations; /* relations to inherit from (list of
* inhRelation) */
List *constraints; /* constraints (list of Constraint nodes) */
ContainsOids hasoids; /* should it have OIDs? */
OnCommitAction oncommit; /* what do we do at COMMIT? */
char *tablespacename; /* table space to use, or NULL */

/* nuevo lein */
char *colname; /* name of column */
TypeName *typename; /* type of column */
} CreateStmt;

En el gram.y:

CREATE OptTemp TABLE qualified_name '(' OptTableElementList ')' AS VALID
EVENT
OptInherit OptWithOids OnCommitOption OptTableSpace
{
CreateStmt *n = makeNode(CreateStmt);
$4->istemp = $2;
n->relation = $4;
n->tableElts = $6;
n->inhRelations = $11;
n->constraints = NIL;
n->hasoids = $12;
n->oncommit = $13;
n->tablespacename = $14;
n->colname = "cflavia";
n->typename = "int4";
$$ = (Node *)n;
}

estA bien me crea la tabla asi
postgres=# CREATE TABLE mitabla4 (mientero int) AS VALID EVENT ;
CREATE TABLE

Al consultarla espero dos campos, pero sale:

postgres=# SELECT * FROM mitabla4 ;
mientero
----------
(0 rows)

Alguna sugerencia ?

Saludos, Lein

El día 2/06/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> escribió:
>
> lein gutierrez escribió:
>
> > Me da el siguiente error
> > gram.y:1734: error: 'CreateStmt' has no member named 'colname'
> > gram.y:1735: error: 'CreateStmt' has no member named 'typename'
>
> parsenodes.h
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>