Re: BUG #5910: Function pg_get_expr throwing error for non superuser - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #5910: Function pg_get_expr throwing error for non superuser
Date
Msg-id 4D6F799F.7050909@enterprisedb.com
Whole thread Raw
In response to BUG #5910: Function pg_get_expr throwing error for non superuser  ("tushar" <tushar.qa@gmail.com>)
List pgsql-bugs
On 03.03.2011 10:59, tushar wrote:
> Pls refer this below scenario
>
> PG 8.4.4:-
> =========
> connect to non superuser :-
>
> postgres=# \c - t
> psql (8.4.4)
> You are now connected to database "postgres" as user "t".
> postgres=>   select pg_get_expr('a',null);
>   pg_get_expr
> -------------
>
> (1 row)

It was an oversight that we allowed that previously, because the user
can easily crash the backend by passing bogus values. Try 8.4.5 or
later, and you will get the same error that you do on 9.0.2.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: "tushar"
Date:
Subject: BUG #5910: Function pg_get_expr throwing error for non superuser
Next
From: Itagaki Takahiro
Date:
Subject: Re: BUG #5906: assertion failure in AtCleanup_Portals