Re: DETOAST Datum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Nick Raj <nickrajjain(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: DETOAST Datum
Date: 2011-05-16 14:22:06
Message-ID: 15275.1305555726@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Mon, May 16, 2011 at 3:41 AM, Nick Raj <nickrajjain(at)gmail(dot)com> wrote:
>> "How to get arguments toastable??" and even my table pg_class.reltoastrelid
>> entry is zero.

> It's pretty hard to guess what's going wrong here from the information
> you've provided. But reltoastid should not be 0 if you're using a
> variable-length data type.

It could be if the type is not marked toastable (ie, has storage class
PLAIN, which I think is the default even for varlena types).

But in any case I suspect that 90% of the problem here is an incorrect
declaration of the *function* not the type. We haven't seen the C
function declaration, nor the SQL CREATE FUNCTION command, but if it's
going through fmgr_oldstyle then there isn't a PG_FUNCTION_INFO_V1
marker, which maybe is the problem.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-16 14:26:05 Re: Extensions in schemas
Previous Message Robert Haas 2011-05-16 13:51:30 Re: DETOAST Datum