[GENERAL] problem with set autocommit to off

2005-03-28 Thread Rajarshi Mukherjee
Hello all, i am not being able to set the default autocommit feature of PG to off. i am using PG 8.0 Windows version and the following command : SET AUTOCOMMIT TO OFF throwing an error: ERROR: SET AUTOCOMMIT TO OFF is no longer supported Please suggest an alternative. ---

Re: [GENERAL] grant problem

2005-03-22 Thread Rajarshi Mukherjee
PLEASE GIVE ME AN EXAMPLE.. On Tue, 22 Mar 2005 06:24:58 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Tue, Mar 22, 2005 at 17:27:25 +0530, > Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote: > > Hello all, > > > > i have a function that updates a

[GENERAL] grant problem

2005-03-22 Thread Rajarshi Mukherjee
Hello all, i have a function that updates a table. I gave execute grant on it to a particular user but no grant on the table in question. when logging in as that user and executing the function, i get an error ERROR: permission denied for relation How can i ensure that any update on th