Function create_del_cascade_trg

src/gpre/cmd.cpp:696–744

//

static void create_del_cascade_trg( gpre_req* request, const act* action,
								   cnstrt* constraint)
{
	const gpre_rel* relation = (gpre_rel*) action->act_object;

	// stuff a trigger_name of size 0. So the dyn-parser will make one up.
	put_string(request, isc_dyn_def_trigger, "", (USHORT) 0);

	put_numeric(request, isc_dyn_trg_type, (SSHORT) POST_ERASE_TRIGGER);

	request->add_byte(isc_dyn_sql_object);
	put_numeric(request, isc_dyn_trg_sequence, (SSHORT) 1);
	put_numeric(request, isc_dyn_trg_inactive, (SSHORT) 0);
	put_cstring(request, isc_dyn_rel_name, constraint->cnstrt_referred_rel->str_string);

	// the trigger blr
	request->add_byte(isc_dyn_trg_blr);
	const USHORT offset = request->req_blr - request->req_base;

	request->add_word(0);
	if (request->req_flags & REQ_blr_version4)
		request->add_byte(blr_version4);
	else
		request->add_byte(blr_version5);

	request->add_byte(blr_for);
	request->add_byte(blr_rse);

	// the context for the prim. key relation
	request->add_byte(1);

	request->add_byte(blr_relation);
	put_cstring(request, 0, relation->rel_symbol->sym_string);
	// the context for the foreign key relation
	request->add_byte(2);

	create_matching_blr(request, constraint);

	request->add_byte(blr_erase);
	request->add_byte((SSHORT) 2);
	request->add_byte(blr_eoc);
	const USHORT length = request->req_blr - request->req_base - offset - 2;
	request->req_base[offset] = (UCHAR) length;
	request->req_base[offset + 1] = (UCHAR) (length >> 8);
	// end of the blr

	// no trg_source and no trg_description
	request->add_byte(isc_dyn_end);
}


//____________________________________________________________