Re: [BUGS] Server crash while trying to read expression using pg_get_expr()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Rushabh Lathia <rushabh(dot)lathia(at)enterprisedb(dot)com>
Subject: Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Date: 2010-06-09 17:34:13
Message-ID: 27906.1276104853@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Kris Jurka <books(at)ejurka(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-06-09 17:40:35 Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Previous Message Robert Haas 2010-06-09 17:31:51 Re: [BUGS] Invalid YAML output from EXPLAIN

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-06-09 17:40:35 Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Previous Message Robert Haas 2010-06-09 17:33:10 Re: hstore ==> and deprecate =>