Re: What is wrong here?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tumurbaatar S(dot)" <tumurbaatar(at)datacom(dot)mn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is wrong here?
Date: 2004-04-22 12:54:56
Message-ID: 25254.1082638496@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tumurbaatar S." <tumurbaatar(at)datacom(dot)mn> writes:
> The following function returns this error:
> pg_query(): Query failed: ERROR: permission denied for relation customers
> CONTEXT: PL/pgSQL function "newprofile" line 8 at SQL statement
> What is wrong here?

By default functions execute with the permissions of the calling user.
If that's not what you want, see the SECURITY DEFINER option of CREATE
FUNCTION.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-04-22 13:07:39 Missing OID rant
Previous Message Harald Fuchs 2004-04-22 12:25:49 Re: Unicode problem ???