Re: should I worry? - Mailing list pgsql-hackers

Hi Tom et all!
Thanks for your mails.
On Fri, 2 Nov 2007, Tom Lane wrote:

> Date: Fri, 02 Nov 2007 16:08:24 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: ohp@pyrenet.fr
> Cc: Heikki Linnakangas <heikki@enterprisedb.com>,
>      pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] should I worry?
>
> ohp@pyrenet.fr writes:
> > All triggers in the schema are named. So I assume they are triggers for
> > foreign keys.
>
> No, foreign-key triggers always have names too, and they don't look like
> that (they look like RI_ConstraintTrigger_nnn).  I cannot find anyplace
> in PG that supplies "<unnamed>" as a default name for a trigger, either.
> So there's something weird about your schema, and we really need to
> see a test case ...
>
I'm confused, until I have clearence to send the schema, here are pg logs:

Nov  3 14:44:20 sun postgres[17963]: [189-1] ERROR:  trigger "<unnamed>" for relation "objets" already exists
Nov  3 14:44:20 sun postgres[17963]: [189-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [189-3]         AFTER UPDATE ON objets
Nov  3 14:44:20 sun postgres[17963]: [189-4]         FROM objet_position
Nov  3 14:44:20 sun postgres[17963]: [189-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [189-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [189-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'objet_position','objets', 'UNSPECIFIED', 'pobj_obj_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [189-8]  'obj_cod');
Nov  3 14:44:20 sun postgres[17963]: [190-1] ERROR:  trigger "<unnamed>" for relation "perso_objets" already exists
Nov  3 14:44:20 sun postgres[17963]: [190-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [190-3]         AFTER INSERT OR UPDATE ON perso_objets
Nov  3 14:44:20 sun postgres[17963]: [190-4]         FROM objets
Nov  3 14:44:20 sun postgres[17963]: [190-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [190-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [190-7]         EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'perso_objets',
'objets','UNSPECIFIED', 'perobj_obj_cod', 'obj_cod');
 
Nov  3 14:44:20 sun postgres[17963]: [191-1] ERROR:  trigger "<unnamed>" for relation "objets" already exists
Nov  3 14:44:20 sun postgres[17963]: [191-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [191-3]         AFTER DELETE ON objets
Nov  3 14:44:20 sun postgres[17963]: [191-4]         FROM perso_objets
Nov  3 14:44:20 sun postgres[17963]: [191-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [191-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [191-7]         EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>',
'perso_objets','objets', 'UNSPECIFIED', 'perobj_obj_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [191-8]  'obj_cod');
Nov  3 14:44:20 sun postgres[17963]: [192-1] ERROR:  trigger "<unnamed>" for relation "objets" already exists
Nov  3 14:44:20 sun postgres[17963]: [192-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [192-3]         AFTER UPDATE ON objets
Nov  3 14:44:20 sun postgres[17963]: [192-4]         FROM perso_objets
Nov  3 14:44:20 sun postgres[17963]: [192-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [192-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [192-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'perso_objets','objets', 'UNSPECIFIED', 'perobj_obj_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [192-8]  'obj_cod');
Nov  3 14:44:20 sun postgres[17963]: [193-1] ERROR:  trigger "<unnamed>" for relation "messages" already exists
Nov  3 14:44:20 sun postgres[17963]: [193-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [193-3]         AFTER UPDATE ON messages
Nov  3 14:44:20 sun postgres[17963]: [193-4]         FROM messages_dest
Nov  3 14:44:20 sun postgres[17963]: [193-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [193-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [193-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'messages_dest','messages', 'UNSPECIFIED', 'dmsg_msg_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [193-8]  'msg_cod');
Nov  3 14:44:20 sun postgres[17963]: [194-1] ERROR:  trigger "<unnamed>" for relation "messages_dest" already exists
Nov  3 14:44:20 sun postgres[17963]: [194-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [194-3]         AFTER INSERT OR UPDATE ON messages_dest
Nov  3 14:44:20 sun postgres[17963]: [194-4]         FROM perso
Nov  3 14:44:20 sun postgres[17963]: [194-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [194-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [194-7]         EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>',
'messages_dest','perso', 'UNSPECIFIED', 'dmsg_perso_cod', 'perso_cod');
 
Nov  3 14:44:20 sun postgres[17963]: [195-1] ERROR:  trigger "<unnamed>" for relation "messages" already exists
Nov  3 14:44:20 sun postgres[17963]: [195-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [195-3]         AFTER DELETE ON messages
Nov  3 14:44:20 sun postgres[17963]: [195-4]         FROM messages_exp
Nov  3 14:44:20 sun postgres[17963]: [195-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [195-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [195-7]         EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>',
'messages_exp','messages', 'UNSPECIFIED', 'emsg_msg_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [199-3]         AFTER DELETE ON positions
Nov  3 14:44:20 sun postgres[17963]: [199-4]         FROM objet_position
Nov  3 14:44:20 sun postgres[17963]: [199-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [199-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [199-7]         EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>',
'objet_position','positions', 'UNSPECIFIED', 'pobj_pos_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [199-8]  'pos_cod');
Nov  3 14:44:20 sun postgres[17963]: [200-1] ERROR:  trigger "<unnamed>" for relation "positions" already exists
Nov  3 14:44:20 sun postgres[17963]: [200-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [200-3]         AFTER UPDATE ON positions
Nov  3 14:44:20 sun postgres[17963]: [200-4]         FROM objet_position
Nov  3 14:44:20 sun postgres[17963]: [200-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [200-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [200-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'objet_position','positions', 'UNSPECIFIED', 'pobj_pos_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [200-8]  'pos_cod');
Nov  3 14:44:20 sun postgres[17963]: [201-1] ERROR:  trigger "<unnamed>" for relation "positions" already exists
Nov  3 14:44:20 sun postgres[17963]: [201-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [201-3]         AFTER DELETE ON positions
Nov  3 14:44:20 sun postgres[17963]: [201-4]         FROM or_position
Nov  3 14:44:20 sun postgres[17963]: [201-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [201-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [201-7]         EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>',
'or_position','positions', 'UNSPECIFIED', 'por_pos_cod', 'pos_cod');
 
Nov  3 14:44:20 sun postgres[17963]: [202-1] ERROR:  trigger "<unnamed>" for relation "positions" already exists
Nov  3 14:44:20 sun postgres[17963]: [202-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [202-3]         AFTER UPDATE ON positions
Nov  3 14:44:20 sun postgres[17963]: [202-4]         FROM or_position
Nov  3 14:44:20 sun postgres[17963]: [202-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [202-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [202-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'or_position','positions', 'UNSPECIFIED', 'por_pos_cod', 'pos_cod');
 
Nov  3 14:44:20 sun postgres[17963]: [203-1] ERROR:  trigger "<unnamed>" for relation "type_evt" already exists
Nov  3 14:44:20 sun postgres[17963]: [203-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [203-3]         AFTER UPDATE ON type_evt
Nov  3 14:44:20 sun postgres[17963]: [203-4]         FROM ligne_evt
Nov  3 14:44:20 sun postgres[17963]: [203-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [203-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [203-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'ligne_evt',
'type_evt','UNSPECIFIED', 'levt_tevt_cod', 'tevt_cod');
 
Nov  3 14:44:20 sun postgres[17963]: [204-1] ERROR:  trigger "<unnamed>" for relation "objet_generique" already exists
Nov  3 14:44:20 sun postgres[17963]: [204-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [204-3]         AFTER DELETE ON objet_generique
Nov  3 14:44:20 sun postgres[17963]: [204-4]         FROM objets
Nov  3 14:44:20 sun postgres[17963]: [204-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [204-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [204-7]         EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'objets',
'objet_generique','UNSPECIFIED', 'obj_gobj_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [204-8]  'gobj_cod');
Nov  3 14:44:20 sun postgres[17963]: [205-1] ERROR:  trigger "<unnamed>" for relation "objet_generique" already exists
Nov  3 14:44:20 sun postgres[17963]: [205-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [205-3]         AFTER UPDATE ON objet_generique
Nov  3 14:44:20 sun postgres[17963]: [205-4]         FROM objets
Nov  3 14:44:20 sun postgres[17963]: [205-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [205-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [205-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'objets',
'objet_generique','UNSPECIFIED', 'obj_gobj_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [205-8]  'gobj_cod');
Nov  3 14:44:20 sun postgres[17963]: [206-1] ERROR:  trigger "<unnamed>" for relation "objets_caracs" already exists
Nov  3 14:44:20 sun postgres[17963]: [206-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [206-3]         AFTER UPDATE ON objets_caracs
Nov  3 14:44:20 sun postgres[17963]: [206-4]         FROM objet_generique
Nov  3 14:44:20 sun postgres[17963]: [206-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [206-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [206-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'objet_generique','objets_caracs', 'UNSPECIFIED', 'gobj_obcar_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [206-8]  'obcar_cod');
Nov  3 14:44:20 sun postgres[17963]: [207-1] ERROR:  trigger "<unnamed>" for relation "competences" already exists
Nov  3 14:44:20 sun postgres[17963]: [207-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [207-3]         AFTER UPDATE ON competences
Nov  3 14:44:20 sun postgres[17963]: [207-4]         FROM objet_generique
Nov  3 14:44:20 sun postgres[17963]: [207-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [207-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [207-7]         EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>',
'objet_generique','competences', 'UNSPECIFIED', 'gobj_comp_cod',
 
Nov  3 14:44:20 sun postgres[17963]: [207-8]  'comp_cod');
Nov  3 14:44:20 sun postgres[17963]: [208-1] ERROR:  trigger "<unnamed>" for relation "race_comp" already exists
Nov  3 14:44:20 sun postgres[17963]: [208-2] STATEMENT:  CREATE CONSTRAINT TRIGGER "<unnamed>"
Nov  3 14:44:20 sun postgres[17963]: [208-3]         AFTER INSERT OR UPDATE ON race_comp
Nov  3 14:44:20 sun postgres[17963]: [208-4]         FROM race
Nov  3 14:44:20 sun postgres[17963]: [208-5]         NOT DEFERRABLE INITIALLY IMMEDIATE
Nov  3 14:44:20 sun postgres[17963]: [208-6]         FOR EACH ROW
Nov  3 14:44:20 sun postgres[17963]: [208-7]         EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'race_comp',
'race','UNSPECIFIED', 'racecomp_race_cod', 'race_cod');
 

Maybe this would ring a bell that refuses to ring here :)
>             regards, tom lane
>
Best regards
-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
15, Chemin des Monges                +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)