NULL,2,key);

if (HeapTupleIsValid(tuple=systable_getnext(tgscan)))

{

Form_pg_triggertrigform= (Form_pg_trigger)GETSTRUCT(tuple);

tgoid=trigform->oid;

Form_pg_triggertrigform;

tuple=heap_copytuple(tuple);/* need a modifiable copy */

trigform= (Form_pg_trigger)GETSTRUCT(tuple);

tgoid=trigform->oid;

namestrcpy(&trigform->tgname,

stmt->newname);

CREATE TRIGGER modified_any BEFORE UPDATE OF a ON main_table FOR EACH ROW WHEN (old.* IS DISTINCT FROM new.*) EXECUTE PROCEDURE trigger_func('modified_any')

(1 row)

DROP TRIGGER modified_a ON main_table;

-- Test RENAME TRIGGER

ALTER TRIGGER modified_a ON main_table RENAME TO modified_modified_a;

SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_a';

count

-------

0

(1 row)

SELECT count(*) FROM pg_trigger WHERE tgrelid = 'main_table'::regclass AND tgname = 'modified_modified_a';

count

-------

1

(1 row)

DROP TRIGGER modified_modified_a ON main_table;

DROP TRIGGER modified_any ON main_table;

DROP TRIGGER insert_a ON main_table;

DROP TRIGGER delete_a ON main_table;

SELECT pg_get_triggerdef(oid, true)FROM pg_triggerWHERE tgrelid='main_table'::regclassAND tgname='modified_a';

SELECT pg_get_triggerdef(oid, false)FROM pg_triggerWHERE tgrelid='main_table'::regclassAND tgname='modified_a';

SELECT pg_get_triggerdef(oid, true)FROM pg_triggerWHERE tgrelid='main_table'::regclassAND tgname='modified_any';

DROPTRIGGER modified_aON main_table;

ALTERTRIGGER modified_aON main_table RENAME TO modified_modified_a;

SELECTcount(*)FROM pg_triggerWHERE tgrelid='main_table'::regclassAND tgname='modified_a';

SELECTcount(*)FROM pg_triggerWHERE tgrelid='main_table'::regclassAND tgname='modified_modified_a';

DROPTRIGGER modified_modified_aON main_table;

DROPTRIGGER modified_anyON main_table;

DROPTRIGGER insert_aON main_table;

DROPTRIGGER delete_aON main_table;