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

2000-06-28 Thread John Morton
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

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

2000-06-28 Thread John Morton
On Wed, 28 Jun 2000 11:50:25 -0400 you wrote: John Morton [EMAIL PROTECTED] writes: What I'd like to be able to do is have the database drop any SELECT, UPDATE or DELETE queries unless they have something fairly specific in their WHERE clause. What about COPY? Er.. what about

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

2000-06-28 Thread Tom Lane
John Morton [EMAIL PROTECTED] writes: webclient --- proxy --- Postgres Minuses: - Another machine to buy - Root on the proxy is as bad as root was on the secure server, so.. - The simple hack will need thorough security auditing - It's yet another machine to secure. - It's yet