Re: cash_out bug - Mailing list pgsql-hackers

From Tom Lane
Subject Re: cash_out bug
Date
Msg-id 27732.1029130238@sss.pgh.pa.us
Whole thread Raw
In response to Re: cash_out bug  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: cash_out bug
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Is this a problem in that the functions are definined to return opaque (eg.
> PG_RETURN_VOID) but are then still usable in SELECT statements?

The issue here is (once again) that we're overloading type oid 0
("opaque") to mean too many different, incompatible things.  I've
ranted about this before and will not repeat my previous remarks.
The bottom line is that we need to eliminate "opaque" in favor of
a set of pseudo-datatypes with different, crisply-defined semantics.
We've had some discussions about it but no complete proposal has been
made.  Since eliminating "opaque" is going to break just about every
extant user-defined datatype, I'm not in a hurry to do it until we
can get it right the first time...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SECURITY] DoS attack on backend possible (was: Re:
Next
From: Don Baccus
Date:
Subject: Re: OOP real life example (was Re: Why is MySQL more chosen