Thread: [GENERAL] Trigger/Procedure creation problem...

I just copied my db build sql scripts to another directory under
another user, and I'm now having a problem creating triggers and
procedures.  For a host of triggers and procedures, I get a message
like the following:

20000111.16:42:26.706  [2752] query: CREATE TRIGGER
person_insert_trigger AFTER INSERT ON person FOR EACH ROW EXECUTE
PROCEDURE create_supporting_person_records ();
20000111.16:42:26.706  [2752] ProcessUtility: CREATE TRIGGER
person_insert_trigger
        AFTER INSERT ON person
        FOR EACH ROW EXECUTE PROCEDURE
create_supporting_person_records ();
20000111.16:42:26.707  [2752] ERROR:  CreateTrigger: trigger
person_insert_trigger already defined on relation person

I have verified I'm calling destroydb on this database before
executing my scripts, and that I don't have duplicate creation
commands in any of the files.

Any clues?

Cheers,
Ed Loehr

> I just copied my db build sql scripts to another directory under
> another user, and I'm now having a problem creating triggers and
> procedures.

Found the problem.  Lobotomy stitches were loose.

Cheers,
Ed Loehr