Skip site navigation (1) Skip section navigation (2)

psql's is_select_command is naive

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: psql's is_select_command is naive
Date: 2010-05-27 02:09:22
Message-ID: AANLkTimMSbRbkpVNcv3DInY9i1DpsxznIgE6bz5CU2Xk@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
It knows that queries beginning with "select" or "values" are select
commands, but it seems not to be clued in about "table" and "with".

For now, we can probably get by with just adding those to the list of
things it checks for.  But I wonder what we'll do about this if we
ever get CTEs for insert/update/delete statements...  you'd have to
parse the whole darn thing to figure out whether it was WITH...SELECT
or WITH...INSERT or WITH...INSERT...RETURNING.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

Responses

pgsql-hackers by date

Next:From: Stephen FrostDate: 2010-05-27 02:15:12
Subject: Re: ExecutorCheckPerms() hook
Previous:From: Mark KirkwoodDate: 2010-05-27 02:08:30
Subject: Re: [spf:guess] Re: ROLLBACK TO SAVEPOINT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group