Re: BUG #6212: PREPARE(pseudotype) should be blocked off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Caleb Welton" <Caleb(dot)Welton(at)emc(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6212: PREPARE(pseudotype) should be blocked off
Date: 2011-09-16 18:11:11
Message-ID: 5490.1316196671@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Caleb Welton" <Caleb(dot)Welton(at)emc(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Caleb.Welton 2011-09-16 19:35:05 Re: BUG #6212: PREPARE(pseudotype) should be blocked off
Previous Message Caleb Welton 2011-09-16 17:10:56 BUG #6212: PREPARE(pseudotype) should be blocked off