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

From: John Morton <jwm(at)plain(dot)co(dot)nz>
To: Travis Bauer <trbauer(at)indiana(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re[2]: Restricting queries by the presence of a WHERE clause
Date: 2000-06-28 23:22:32
Message-ID: 200006282322.LAA07668@vesta.plain.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Morton 2000-06-29 00:23:53 Re[2]: Restricting queries by the presence of a WHERE clause
Previous Message Ned Lilly 2000-06-28 19:07:53 FW: Error