Re: how do you get there from here? - Mailing list pgsql-general

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@mitel.com>, 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