Re[2]: Restricting queries by the presence of a WHERE clause

Поиск
Список
Период
Сортировка
От John Morton
Тема Re[2]: Restricting queries by the presence of a WHERE clause
Дата
Msg-id 200006282322.LAA07668@vesta.plain.co.nz
обсуждение исходный текст
Ответ на Re: Restricting queries by the presence of a WHERE clause  (Travis Bauer <trbauer@indiana.edu>)
Список pgsql-general
On Wed, 28 Jun 2000 07:32:11 -0500 (EST) you wrote:

 > Wouldn't it be possible to create a trigger and check for the where clause
 > there?

First of all, I've got no idea how to check a where clause inside a
trigger, which was the main reason I asked :-) I've only every built
trigger functions in PL/tcl. Guess I should have a look at the C API.

Secondly, there is no way to make a trigger for a select query (in 6.5,
anyway), and blocking selects is the most important thing I need to do.

John

В списке pgsql-general по дате отправления:

Предыдущее
От: Ned Lilly
Дата:
Сообщение: FW: Error
Следующее
От: John Morton
Дата:
Сообщение: Re[2]: Restricting queries by the presence of a WHERE clause