← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to contrib/spi/insert_username.c

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/spi/insert_username.c
 
1
/*
 
2
 * insert_username.c
 
3
 * $Modified: Thu Oct 16 08:13:42 1997 by brook $
 
4
 * contrib/spi/insert_username.c
 
5
 *
 
6
 * insert user name in response to a trigger
 
7
 * usage:  insert_username (column_name)
 
8
 */
 
9
#include "postgres.h"
 
10
 
 
11
#include "catalog/pg_type.h"
 
12
#include "commands/trigger.h"
 
13
#include "executor/spi.h"
 
14
#include "miscadmin.h"
 
15
#include "utils/builtins.h"
 
16
 
 
17
PG_MODULE_MAGIC;
 
18
 
 
19
extern Datum insert_username(PG_FUNCTION_ARGS);
 
20
 
 
21
PG_FUNCTION_INFO_V1(insert_username);
 
22
 
 
23
Datum
 
24
insert_username(PG_FUNCTION_ARGS)
 
25
{
 
26
        TriggerData *trigdata = (TriggerData *) fcinfo->context;
 
27
        Trigger    *trigger;            /* to get trigger name */
 
28
        int                     nargs;                  /* # of arguments */
 
29
        Datum           newval;                 /* new value of column */
 
30
        char      **args;                       /* arguments */
 
31
        char       *relname;            /* triggered relation name */
 
32
        Relation        rel;                    /* triggered relation */
 
33
        HeapTuple       rettuple = NULL;
 
34
        TupleDesc       tupdesc;                /* tuple description */
 
35
        int                     attnum;
 
36
 
 
37
        /* sanity checks from autoinc.c */
 
38
        if (!CALLED_AS_TRIGGER(fcinfo))
 
39
                /* internal error */
 
40
                elog(ERROR, "insert_username: not fired by trigger manager");
 
41
        if (!TRIGGER_FIRED_FOR_ROW(trigdata->tg_event))
 
42
                /* internal error */
 
43
                elog(ERROR, "insert_username: must be fired for row");
 
44
        if (!TRIGGER_FIRED_BEFORE(trigdata->tg_event))
 
45
                /* internal error */
 
46
                elog(ERROR, "insert_username: must be fired before event");
 
47
 
 
48
        if (TRIGGER_FIRED_BY_INSERT(trigdata->tg_event))
 
49
                rettuple = trigdata->tg_trigtuple;
 
50
        else if (TRIGGER_FIRED_BY_UPDATE(trigdata->tg_event))
 
51
                rettuple = trigdata->tg_newtuple;
 
52
        else
 
53
                /* internal error */
 
54
                elog(ERROR, "insert_username: cannot process DELETE events");
 
55
 
 
56
        rel = trigdata->tg_relation;
 
57
        relname = SPI_getrelname(rel);
 
58
 
 
59
        trigger = trigdata->tg_trigger;
 
60
 
 
61
        nargs = trigger->tgnargs;
 
62
        if (nargs != 1)
 
63
                /* internal error */
 
64
                elog(ERROR, "insert_username (%s): one argument was expected", relname);
 
65
 
 
66
        args = trigger->tgargs;
 
67
        tupdesc = rel->rd_att;
 
68
 
 
69
        attnum = SPI_fnumber(tupdesc, args[0]);
 
70
 
 
71
        if (attnum < 0)
 
72
                ereport(ERROR,
 
73
                                (errcode(ERRCODE_TRIGGERED_ACTION_EXCEPTION),
 
74
                                 errmsg("\"%s\" has no attribute \"%s\"", relname, args[0])));
 
75
 
 
76
        if (SPI_gettypeid(tupdesc, attnum) != TEXTOID)
 
77
                ereport(ERROR,
 
78
                                (errcode(ERRCODE_TRIGGERED_ACTION_EXCEPTION),
 
79
                                 errmsg("attribute \"%s\" of \"%s\" must be type TEXT",
 
80
                                                args[0], relname)));
 
81
 
 
82
        /* create fields containing name */
 
83
        newval = CStringGetTextDatum(GetUserNameFromId(GetUserId()));
 
84
 
 
85
        /* construct new tuple */
 
86
        rettuple = SPI_modifytuple(rel, rettuple, 1, &attnum, &newval, NULL);
 
87
        if (rettuple == NULL)
 
88
                /* internal error */
 
89
                elog(ERROR, "insert_username (\"%s\"): %d returned by SPI_modifytuple",
 
90
                         relname, SPI_result);
 
91
 
 
92
        pfree(relname);
 
93
 
 
94
        return PointerGetDatum(rettuple);
 
95
}