Thanks for the precious tips, but unfortunately the syntax: EXECUTE 'INSERT INTO '|| TG_TABLE_NAME ||' SELECT '|| NEW.*;is parsed correctly, but when the trigger is fired the following error is returned
ERROR: column "*" not found in data type mytable CONTEXT: SQL statement "SELECT 'INSERT INTO '|| $1 ||' SELECT '|| $2 .*" Using EXECUTE 'INSERT INTO '|| TG_TABLE_NAME ||' SELECT NEW.*'; instead, returns: ERROR: NEW used in query that is not in a rule CONTEXT: SQL statement "INSERT INTO anag_referenti SELECT NEW.*" Hope someone can show me another way to do that, if exists ;) Have a nice day! T. _________________________________________________________________ Ti piace giocare con le lettere? Prova ABCLive! http://messengergiochi.it.msn.com/