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

On 6/2/06, lein gutierrez <leing2002(at)gmail(dot)com> wrote:
> 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 ?
>

y porque supones que por añadir 2 campos en CreateStmt se van a añadir
en la tabla? no deberias estar modificando la funcion que crea la
tabla?

src/backend/commands/tablecmds.c

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook