unable to assign value to composite column in trigger

Поиск
Список
Период
Сортировка
От Ketema Harris
Тема unable to assign value to composite column in trigger
Дата
Msg-id A705429E-D691-4C2E-8197-D55D4A9AF49F@ketema.net
обсуждение исходный текст
Ответы Re: unable to assign value to composite column in trigger  (Ketema Harris <ketema@ketema.net>)
Список pgsql-general
The following is a snippet from a trigger i am using:

_mycompositeType.user_id = (OLD).mycompositeType.user_id;
...do some stuff...  --notice that assigning from the trigger record
works

but later on...

(new).mycompositeType.transaction_id := _transaction_id;

Fails with syntax error at or near "("

I have tried removing the () and it fails with "syntax error at or
near "new""

non composite column can be assigned to in the trigger just fine:

new.other_columm := 5;  --gives no issues

How can a composite column be assigned to inside a trigger?

Thanks

Ketema J. Harris
www.ketema.net
ketema@ketema.net
ketemaj on iChat



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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Mirroring existing mysql setup
Следующее
От: Ketema Harris
Дата:
Сообщение: Re: unable to assign value to composite column in trigger