Re: BUG #5910: Function pg_get_expr throwing error for non superuser

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: tushar <tushar(dot)qa(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5910: Function pg_get_expr throwing error for non superuser
Date: 2011-03-03 11:21:03
Message-ID: 4D6F799F.7050909@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Itagaki Takahiro 2011-03-03 13:02:46 Re: BUG #5906: assertion failure in AtCleanup_Portals
Previous Message tushar 2011-03-03 08:59:23 BUG #5910: Function pg_get_expr throwing error for non superuser