tuple maximum size; plpgsql to sendmail? - Mailing list pgsql-novice

From ERIC Lawson - x52010
Subject tuple maximum size; plpgsql to sendmail?
Date
Msg-id Pine.GSO.4.10.10007130821590.3704-100000@gandalf.bioeng.washington.edu
Whole thread Raw
Responses Re: tuple maximum size; plpgsql to sendmail?
List pgsql-novice
Hi, and TIA,

Can anybody here answer these questions:

1) I've seen references to the maximum size of a tuple as being
configurable within the range of 8 to 32K, yet the incorporation of blobs
seems to contradict any maximum size constraint.  Is there a maximum tuple
size, and if so, what is it?  (To be sure, the server environment limits
the size of a tuple, attribute and class, but does postgreSQL imposes
limits itself?)

2) I'd like to use a plpgsql procedure to send mail when a trigger event
or condition pertains (e.g., when the interval between the system date and
a date stored in an attribute reaches 14 days).  Is this possible with
plpgsql, and how would it be achieved?

regards,
Eric

James Eric Lawson
Research Publications Editor III
National Simulation Resource

eric@bioeng.washington.edu



pgsql-novice by date:

Previous
From: Jacques Williams
Date:
Subject: Re: pgsql setup
Next
From: Lilly Sarkis
Date:
Subject: RE: pgsql setup