Postgresql trigger example ?

[JackZHANG]

Greetings,
Could somebody please show me an example of Trigger in Postgresql ArcSDE where if user edited feature attribute A it automatically update attribute B of the same feature?  Many thanks!

[VinceAngelo · Accepted solution]

There's nothing Esri-specific about PostgreSQL trigger syntax.  Wouldn't you be better off asking
in a PostgreSQL forum?  The only part that's relevant here is that the trigger would be on the adds
table if the layer was versioned.

From a quick review of the PostgreSQL documentation, it appears you'll need to choose a language
in which to implement the trigger function (from those available in your install), so there's four options
besides writing a 'C' function, and you'll want to specify which one, along with the version of PG when
you post.

- V