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: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: 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 14:34:57
Message-ID: 24476.1276094097@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> We have two options:

> 1. Make pg_get_expr() handle arbitrary (possibly even malicious) input
> gracefully.

> 2. Restrict pg_get_expr() to superusers only.

I think #1 is a fool's errand. There is far too much structure to a
node tree that is outside the scope of what readfuncs.c is capable of
understanding.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2010-06-09 14:38:42 Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Previous Message Tom Lane 2010-06-09 14:32:05 Re: BUG #5495: RI/FK on self and inherited table

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2010-06-09 14:38:42 Re: [BUGS] Server crash while trying to read expression using pg_get_expr()
Previous Message Robert Haas 2010-06-09 13:37:11 Re: Adding XMLEXISTS to the grammar