Received: from priv-edtnes09-hme0.telusplanet.net (mtaout.telus.net [199.185.220.235]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0HMS5V16245 for ; Thu, 17 Jan 2002 17:28:05 -0500 (EST) (envelope-from braum@telus.net) Received: from computer.telus.net ([207.194.21.1]) by priv-edtnes09-hme0.telusplanet.net (InterMail vM.5.01.04.01 201-253-122-122-101-20011014) with ESMTP id <20020117222802.BMOG16355.priv-edtnes09-hme0.telusplanet.net@computer.telus.net> for ; Thu, 17 Jan 2002 15:28:02 -0700 Message-Id: <5.1.0.14.0.20020117141918.00a49e80@pop.telus.net> X-Sender: a3a48144@pop.telus.net X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 17 Jan 2002 14:27:39 -0800 To: pgsql-sql@postgresql.org From: Braum Meakes Subject: User Permissions Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200201/203 X-Sequence-Number: 6289 Hello, I have a function that I've written in plpgsql. In it I lock a table before selecting a value and, depending on the value, either update the record selected or insert a new one. It works perfectly when I run it as a super-user or as the owner of the table. However, as a standard user I am unable to lock the table. How do I either run the function at the owners level, or change the permissions on the table to allow the user to lock it? I am unable to lock the table as a standard user at any time, not just when running the function. Thanks in advance, Braum Meakes