Question about accessing current row data inside trigger

Поиск
Список
Период
Сортировка
От pw
Тема Question about accessing current row data inside trigger
Дата
Msg-id 422E2DD4.1070509@telus.net
обсуждение исходный текст
Ответы Re: Question about accessing current row data inside trigger  ("Jim Buttafuoco" <jim@contactbda.com>)
Список pgsql-interfaces
*previously posted this to pgsql-general*

-Hello,
-
-I have a trigger function written in C.
-The trigger function is called via:
-
-CREATE TRIGGER after_update AFTER UPDATE ON some_table
-   FOR EACH ROW EXECUTE PROCEDURE  my_trigger_function();
-
-   Since the trigger is called after each row update the actual
-row data
-should be available in some way to the trigger.
-
-    What functionality (SPI ?) do I use to use the column values -from the
-current row in the actual trigger?
-
-    Does SPI_cursor_fetch automatically give me the current trigger -row or
-do I need to query again for the proper row?
-
-thanks for any insight,
-
-Peter


I am now using :


TupleTableSlot  *t = (TupleTableSlot *) PG_GETARG_POINTER(0);
bool isnull;

char *buffer=(char *)DatumGetPointer(GetAttributeByName(t, 
"some_column_name", &isnull));



The pointer always comes back NULL though there is data
in the column.

I'm still not sure this is the correct way to access
the data from the updated row.

Is this the correct way to get a string back from
the data in the column named 'some_column_name'?

Do I have the correct TupleTableSlot pointer?

Thanks for any insight,

Peter



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Moncef Mezghani
Дата:
Сообщение: undefined reference to `SSL_new' when linking with lib-pq.a version 7.4.7-2
Следующее
От: "Jim Buttafuoco"
Дата:
Сообщение: Re: Question about accessing current row data inside trigger