[GENERAL] Trigger/Procedure creation problem...

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: pg-gen <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Trigger/Procedure creation problem...
Date: 2000-01-11 22:47:50
Message-ID: 387BB316.C590E6CB@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 'Alfred Perlstein' 2000-01-11 23:05:49 (forw) RE: [GENERAL] Memory leak in FreeBSD?
Previous Message Dale Anderson 2000-01-11 22:47:30 PSQL Function() help....