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

From Caleb Welton
Subject BUG #6212: PREPARE(pseudotype) should be blocked off
Date
Msg-id 201109161710.p8GHAuLK071824@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6212: PREPARE(pseudotype) should be blocked off  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      6212
Logged by:          Caleb Welton
Email address:      Caleb.Welton@emc.com
PostgreSQL version: 9.0
Operating system:   OSX
Description:        PREPARE(pseudotype) should be blocked off
Details:

statements such as:
  PREPARE p1(anyelement) AS SELECT quote_literal($1);
  PREPARE p2(internal) AS SELECT int2recv($1);

Should not be allowed.

They can result in peculiar behavior such as the following:

execute p1('hello')
ERROR:  cannot display a value of type anyelement

pgsql-bugs by date:

Previous
From: "Norman Palardy"
Date:
Subject: BUG #6210: Description of PQconnectdbParams in documentation
Next
From: Tom Lane
Date:
Subject: Re: BUG #6212: PREPARE(pseudotype) should be blocked off