Skip site navigation (1) Skip section navigation (2)

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

From: "Caleb Welton" <Caleb(dot)Welton(at)emc(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6212: PREPARE(pseudotype) should be blocked off
Date: 2011-09-16 17:10:56
Message-ID: 201109161710.p8GHAuLK071824@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6212
Logged by:          Caleb Welton
Email address:      Caleb(dot)Welton(at)emc(dot)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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-16 18:11:11
Subject: Re: BUG #6212: PREPARE(pseudotype) should be blocked off
Previous:From: Euler Taveira de OliveiraDate: 2011-09-16 15:01:12
Subject: Re: Timezone issues with Postrres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group