triggers

From: Kevin HaleBoyes <kcboyes(at)yahoo(dot)com>
To: kevinh(at)computersandcontrols(dot)com
Subject: triggers
Date: 2001-10-09 14:47:53
Message-ID: 3BC30E19.1030203@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message news.optonline.net 2001-10-09 14:54:27 Re: How to make a REALLY FAST db server?
Previous Message Tom Lane 2001-10-09 14:34:05 Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE