Tom Lane wrote: > Nothing. The problem apparently is that you've got deferred AFTER > triggers on that table, so the UPDATE commands have left unprocessed > trigger events behind, and the system can't be sure that those events > would still be sensible to fire after doing further ALTERs on the table. > > *Why* you've got such triggers is not apparent from what you've told us. I've not explicitely created any triggers. The table has constraints, and if that results in triggers created by the system, then that would be why. All I know is that it worked in 7.4 without issue. Here is the table in question, most of the code initially generated by the Django framework... tugdb=# \d instances Table "public.instances" Column | Type | Modifier s ------------------------------+------------------------+------------------------------- ------------------------- id | integer | not null default nextval('inst ances_id_seq'::regclass) tugid | character varying(128) | not null status | integer | not null lan_ip | inet | not null wan_ip | inet | transcoding | boolean | not null local_streaming | boolean | not null nlogs2keep | integer | not null log_verbosity | integer | not null detailed_jitter_log | boolean | not null srtp_starting_port | integer | not null srtp_ending_port | integer | not null rtp_framesize | character varying(2) | not null tftp_blocksize | character varying(4) | not null default_minet_icp | integer | default_sip_icp | integer | node_id | integer | not null daisy_ip | inet | restrict_minet | boolean | not null relax_icp_rtp_checks | boolean | not null udp_icpside_address | inet | udp_setside_address | inet | disable_srtp | boolean | not null default false udp_icpside_address_override | inet | udp_setside_address_override | inet | time_format | integer | not null default 12 setside_codec | character varying(16) | not null default 'g.729'::char acter varying Indexes: "dashboard_tuginstance_pkey" PRIMARY KEY, btree (id) "dashboard_tuginstance_tugid_key" UNIQUE, btree (tugid) "dashboard_tuginstance_node_id" btree (node_id) Check constraints: "dashboard_tuginstance_default_minet_icp_check" CHECK (default_minet_icp >= 0) "dashboard_tuginstance_default_sip_icp_check" CHECK (default_sip_icp >= 0) "dashboard_tuginstance_nlogs2keep_check" CHECK (nlogs2keep >= 0) "dashboard_tuginstance_srtp_ending_port_check" CHECK (srtp_ending_port >= 0) "dashboard_tuginstance_srtp_starting_port_check" CHECK (srtp_starting_port >= 0) "dashboard_tuginstance_status_check" CHECK (status >= 0) Foreign-key constraints: "dashboard_tuginstance_node_id_fkey" FOREIGN KEY (node_id) REFERENCES nodes(id) DEFERRABLE INITIALLY DEFERRED Mike -- Michael P. Soulier <michael_soulier@xxxxxxxxx>, 613-592-2122 x2522 "Any intelligent fool can make things bigger and more complex... It takes a touch of genius - and a lot of courage to move in the opposite direction." --Albert Einstein
Attachment:
signature.asc
Description: OpenPGP digital signature