Re: [SQL-Ledger-users] PostgreSQL triggers?

[<li...@li...>]

On Fri, May 04, 2001 at 09:27:37AM -0700, Damon Torgerson was heard to rema=
rk:
> a) letting the database manage business logic with triggers and constrain=
ts is=20
> a good thing for design and performance reasons
> b) unfortunately, most rdbms have proprietary formats for triggers so wri=
ting a=20
> trigger for Postgres would either eliminate other rdbms or necessitate=20
> different database code for different rdbms.

My impression was (may be very wrong) that postgress triggers and e.g.
oracle triggers are pretty similar/same.   Its stored proceedures where
all hell breaks loose.  (in postgres, you can link in arbitrary .so's.=20
Basically if you can link it into a shared library, you can turn it into
a postgress stored proceedure. SO its very very general).

--linas
--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/