Find the answer to your Linux question:
Results 1 to 4 of 4
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2003
    Lima - Peru

    Triggers in Postgresql

    Hi everyone,
    Does anybody know how to create triggers in postgresql???. I think a have to create a function in "C" first and then call it from the trigger. Is this the only way to do it? cuz it seems to be difficult. Can i use plsql?

  2. #2
    Linux Engineer
    Join Date
    Apr 2003
    I have never heard of anyone creating triggers in mysql or postregsql but i know that it workes on Oracle and Sybase databases. The best way to find out is to search on google or read on or postregsql:s official homepage.


  3. #3
    To my knowledge postgresql or mysql do not support triggers. As andutt says only oracle supports them. Plsql is definately only supported by oracle, as this is their procedural language. How you would create triggers in "c" I don't know, as triggers are usually held within the database itself. I guess reading the docs that come with mysql may point you in the right direction.

  4. $spacer_open
  5. #4
    Just Joined!
    Join Date
    Oct 2003

    PostgreSQL has triggers

    I think this is a relatively recent feature but PostgreSQL does have triggers, no C programming required:
    ...although only row-level, not statement level triggers appear to be supported.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts