triggers
От | Kevin HaleBoyes |
---|---|
Тема | triggers |
Дата | |
Msg-id | 3BC30E19.1030203@yahoo.com обсуждение исходный текст |
Ответы |
Re: triggers
|
Список | pgsql-general |
I'm currently running a database on Oracle and would like to make my application portable to the PostgreSQL database. Converting the tables (specifically the attribute types) is fairly easy but I've run into a problem with database triggers. My application is designed so that insertions/updates to certain tables only provide a limited number of attributes and an Oracle trigger fills in the other attributes. For example, one table may have id and name attributes but when the application inserts new records it only provides the name value and a trigger fills in the id value (from a sequence number). I started looking at the trigger support in PostgreSQL and found what I needed except I'm not sure how to write the "body" of the trigger. In Oracle I write PL/SQL but it seems I may have to write C code on the PostgreSQL side. Is this true? Is there a PostgreSQL procedural language that I can write the body in? Thanks, Kevin.
В списке pgsql-general по дате отправления: