Getting Constrint information..??

From: Steffen Nielsen <styf(at)cs(dot)auc(dot)dk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Getting Constrint information..??
Date: 2002-04-19 02:15:49
Message-ID: 1019182549.3cbf7dd5d431e@www.cs.auc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Help!

Can anyone tell me what wrong with the following codesnippet. I nuke the
server when called (stored procedure)

... some VALID spi_exec call :-) has been done ...

TupleDesc tupdesc = SPI_tuptable->tupdesc;
TupleConstr *tupconstr = SPI_tuptable->tupdesc->constr;
ConstrCheck *check = tupconstr->check;
SPITupleTable *tuptable = SPI_tuptable;
char *ccbin;

char buf[8192];
int i;

for (i = 1, buf[0] = 0; i <= tupdesc->natts; i++) {
ccbin = check[i].ccbin;
sprintf(buf + strlen (buf), "%s, %s",
SPI_fname(tupdesc,i),
ccbin);
elog (NOTICE, "%s", buf);
}

I have not had any luck :-( I'm a C beginner thou, so maybe i screw up when
accessing the structures

Any help is appreciated

/Steffen Nielsen

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-04-19 02:22:19 Re: Schema (namespace) privilege details
Previous Message Tom Lane 2002-04-19 02:08:00 Re: Schema (namespace) privilege details