Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA15036; Thu, 16 Jul 92 11:22:19 -0700
Date: Thu, 16 Jul 92 11:22:19 -0700
Message-Id: <9207161822.AA15036@postgres.Berkeley.EDU>
From: postgres@jdsds1.ir.miami.edu (Raymond D. Frost)
Subject: Tuple is too big
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu

The following rule works under version 3.1 but gives the 
"Tuple is too big" error under version 4.0.  Is there a
way to work around this?  Have the query plans become
larger under version 4.0?  Thanks in advance.

Raymond Frost
University of Miami

-------------------------------------------------

create root
	(client = int4,
	amtreq = 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, amtauth = float4) inherits (root) \g
	
define rule bankrupt is
on append to root
where new.bankrupt = "t"::bool
do [
	append final (new.all, grantloan = "f"::bool)
]
\g