Re: [BUGS] Server crash while trying to read expression using pg_get_expr() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Date
Msg-id 27906.1276104853@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] Server crash while trying to read expression using pg_get_expr()  (Kris Jurka <books@ejurka.com>)
Responses Re: [BUGS] Server crash while trying to read expression using pg_get_expr()  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Kris Jurka <books@ejurka.com> writes:
> On Wed, 9 Jun 2010, Heikki Linnakangas wrote:
>> Are you thinking we should retrict pg_get_expr() to superusers then?

> That seems like it will cause problems for both pg_dump and drivers which 
> want to return metadata as pg_get_expr has been the recommended way of 
> fetching this information.

Yes, it's not a trivial fix either.  We'll have to provide functions or
views that replace the current usages without letting the user insert
untrusted strings.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: hstore ==> and deprecate =>
Next
From: Robert Haas
Date:
Subject: Re: [BUGS] Server crash while trying to read expression using pg_get_expr()