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

    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
    Location
    Sweden
    Posts
    796
    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 mysql.org or postregsql:s official homepage.
    Regards

    Andutt

  3. #3
    Just Joined!
    Join Date
    May 2003
    Posts
    27
    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
    $spacer_close
  5. #4
    Just Joined!
    Join Date
    Oct 2003
    Posts
    1

    PostgreSQL has triggers

    I think this is a relatively recent feature but PostgreSQL does have triggers, no C programming required:
    http://www.postgresql.org/docs/view....tetrigger.html
    ...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
  •