Postgres Pro
Downloads
Home   >   mailing lists

Re: What is wrong here? - Mailing list pgsql-general

From Tom Lane
Subject Re: What is wrong here?
Date
Msg-id 25254.1082638496@sss.pgh.pa.us
Whole thread Raw
In response to What is wrong here?  ("Tumurbaatar S." <tumurbaatar@datacom.mn>)
List pgsql-general
Tree view 
"Tumurbaatar S." <tumurbaatar@datacom.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

pgsql-general by date:

Previous
From: Harald Fuchs
Date:
Subject: Re: Unicode problem ???
Next
From: Oleg Bartunov
Date:
Subject: Re: [ADMIN] Restoring a Databases that features tserach2