Re: BUG #6212: PREPARE(pseudotype) should be blocked off - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6212: PREPARE(pseudotype) should be blocked off
Date
Msg-id 5490.1316196671@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6212: PREPARE(pseudotype) should be blocked off  ("Caleb Welton" <Caleb.Welton@emc.com>)
Responses Re: BUG #6212: PREPARE(pseudotype) should be blocked off
List pgsql-bugs
"Caleb Welton" <Caleb.Welton@emc.com> writes:
> statements such as:
>   PREPARE p1(anyelement) AS SELECT quote_literal($1);
>   PREPARE p2(internal) AS SELECT int2recv($1);
> Should not be allowed.

Hmm.  It would require an extra catalog lookup per parameter to enforce
that.  Not sure that it's worth it just to prevent "peculiar" errors.
Can you point to any worse consequences?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Caleb Welton"
Date:
Subject: BUG #6212: PREPARE(pseudotype) should be blocked off
Next
From:
Date:
Subject: Re: BUG #6212: PREPARE(pseudotype) should be blocked off