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: (view raw, whole thread or download thread mbox)
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

Robert Haas
The Enterprise Postgres Company


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-2017 The PostgreSQL Global Development Group