Re: [HACKERS] current CVS snapshot of pgsql crash ... - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] current CVS snapshot of pgsql crash ...
Date
Msg-id 199907072352.TAA16153@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] current CVS snapshot of pgsql crash ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Added to TODO:
* Fix typein/out functions to not be user-callable


> David Sauer <davids@orfinet.cz> writes:
> > david=> select textout(byteaout(odata)) from xinv18986;
> > pqReadData() -- backend closed the channel unexpectedly.
> 
> I think this is not related to large objects per se --- it's a
> typechecking failure.  textout is expecting a text datum, and it's
> not getting one because that's not what comes out of byteaout.
> (The proximate cause of the crash is that textout tries to interpret
> the first four bytes of byteaout's output as a varlena length...)
> 
> The parser's typechecking machinery is unable to catch this
> error because textout is declared to take any parameter type
> whatever (its proargtype is 0).
> 
> Why don't the type output functions have the correct input types
> declared for them in pg_proc???
> 
> For that matter, why do we allow user expressions to call the type
> input/output functions at all?  They're not really usable as SQL
> functions AFAICS...
> 
>             regards, tom lane
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Delaying insertion of default values
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Open 6.5 items