Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06275; Mon, 13 Jul 92 11:34:38 -0700
Date: Mon, 13 Jul 92 11:34:38 -0700
From: "Raymond Frost (305) 284-3969" <RFROST@umiami.IR.Miami.EDU>
Subject: Tuple is too big
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Message-Id: <01GMC0RHF78Y9FMABQ@umiami.IR.Miami.EDU>
X-Envelope-To: postgres@postgres.berkeley.edu
X-Vms-To: IN%"postgres@postgres.berkeley.edu"
Mime-Version: 1.0
Content-Transfer-Encoding: 7BIT

Any help in determining why the following series of commands results
in an error message would be greatly appreciated.

create root
	(client = int2,
	amtreq = float4,
	amtauth = float4,
	netmonth = float4,
	housemonth = float4,
	othermonth = float4,
	appr = float4,
	apprver = float4,
	dpmnt = float4,
	rate = float4,
	bankrupt = bool,
	points = float4,
	miscclose = float4,
	reqliq = float4,
	citizen = bool,
	resalien = bool) \g
	

create final (grantloan = bool) inherits (root) \g

create trace (client = int2,
		node = char16) \g
	
define rule pledge6 is
on append to root
where new.reqliq > ("8.0"::float4 * new.housemonth)
do [
	append trace (node = "pledge6"::char16, client = new.client)
	append final 
	   (new.all, grantloan = "t"::bool,
	   amtauth = ("0.70"::float4 * new.appr))
	delete root
]
\g

Query sent to backend is "define rule pledge6 is on append to root where new.reqliq > ("8.0"::float4 * new.housemonth) do [     append trace (node = "pledge6"::char16, client = new.client)    append final       (new.all, grantloan = "t"::bool,        amta
WARN:Jul 13 14:31:11:Tuple is too big: size 9748
 

Thanks,

Raymond Frost
University of Miami