Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    2

    Question Unanswered: Trigger in PostgreSQL 7.+

    Have a problem, where i was create trigger, it's not showed in list triggers of db. Its relate with numbers indexes on table? (becouse where i did 4th trigger i saw it). Can somebody give me links or advise?
    wbr Arnx

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Create trigger

    be more specific

    You want to create a trigger but the statement has no affect.

    after 4 tries you got the trigger in the database.

    can you show me the trigger code?

    You said the trigger is related to indexes in table?
    what do you mean exactly with that?
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    May 2002
    Posts
    2
    table - very simple
    idfirm INT2 NOT NULL PRIMARY KEY,
    mainfirm INT2 NOT NULL,
    namefirm VARCHAR(80) NOT NULL UNIQUE,
    shortname VARCHAR(20) NOT NULL UNIQUE,
    inn VARCHAR(16) NOT NULL,
    address VARCHAR(100),
    phone VARCHAR(30),
    fax VARCHAR(30),
    email VARCHAR(60),
    prup NUMERIC(6,3)
    --
    function already exist
    trigger simple too
    CREATE TRIGGER tf5ownf_OnI
    BEFORE INSERT ON f5ownfirms FOR EACH ROW
    EXECUTE PROCEDURE f5ownfOnI();
    --
    when it's go that's ok? succesful--
    Your SQL-query has been executed successfully

    Affected Rows: 0
    SQL-query:
    CREATE TRIGGER t8f5ownf_OnI
    BEFORE INSERT ON f5ownfirms FOR EACH ROW
    EXECUTE PROCEDURE f5ownfOnI()

    but "No Triggers found" when i try see triggers(((
    wbr Arnx

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    trigger error

    This is a very strange error.

    As far I can see there is no error.

    The only thing that I can say is try a rule instead of this trigger.

    Maybe there is a problem with the OID of this trigger

    Try also CREATE OR REPLACE TRIGGER

    But at the moment I don't know if this is implemented for triggers but I think so.
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

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