Received: from orion.SAPserv.Hamburg.dsh.de (Tpolaris2.sapham.debis.de [53.2.131.8]) by hub.org (8.9.3/8.9.3) with SMTP id QAA27733 for ; Sat, 22 Apr 2000 16:50:55 -0400 (EDT) (envelope-from wieck@debis.com) Received: by orion.SAPserv.Hamburg.dsh.de for pgsql-sql@postgresql.org id m12j6lo-0003knC; Sat, 22 Apr 100 22:44 MET DST Message-Id: From: wieck@debis.com (Jan Wieck) Subject: Re: TOAST (was: BLOB) In-Reply-To: <26925.956423556@sss.pgh.pa.us> from Tom Lane at "Apr 22, 2000 01:12:36 pm" To: Tom Lane Date: Sat, 22 Apr 2000 22:44:52 +0200 (CEST) CC: Jan Wieck , Peter Eisentraut , pgsql-sql@postgresql.org Reply-To: Jan Wieck X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/256 > wieck@debis.com (Jan Wieck) writes: > >> Net result for user-defined-datatype authors will be "if you revise > >> your routines, they will be easier to read, more portable, and will > >> support TOASTed values. If you don't, they'll still work about as > >> well (or poorly) as they did before." > > > Sorry, but that ain't true. Making an existing type toastable > > means that all functions, receiving that type need to be > > revised. > > What I meant was that they'd still work, with a limit on field size, > just like before. ie, no TOAST support. Yes, but at the first time, a toasted value is handed to them the result (up to backend crash) is unpredictable. So any user defined function taking "text" as argument is potentially in danger! Better tell them they have to revise. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #========================================= wieck@debis.com (Jan Wieck) #