Re: cannot delete some records [9.3] - Mailing list pgsql-general

From Andy Colson
Subject Re: cannot delete some records [9.3]
Date
Msg-id 52A0FEA2.7070500@squeakycode.net
Whole thread Raw
In response to cannot delete some records [9.3]  (Frank Miles <fpm@u.washington.edu>)
Responses Re: cannot delete some records [9.3]
List pgsql-general
On 12/5/2013 4:05 PM, Frank Miles wrote:

>   The table schema is {\d
> credmisc}:
> And this is all owned by: {\dp credmisc}
>

You have a table credmisc, in schema credmisc, owned by credmisc?
It could be a path problem.  Maybe trigger should be:

trig_credmisc_updt BEFORE UPDATE ON credmisc.credmisc FOR EACH ROW
EXECUTE PROCEDURE credmisc.trigonupdtcredmisc()



>      trig_credmisc_ins BEFORE INSERT ON credmisc FOR EACH ROW EXECUTE
> PROCEDURE trigoninscredmisc()
>      trig_credmisc_updt BEFORE UPDATE ON credmisc FOR EACH ROW EXECUTE
> PROCEDURE trigonupdtcredmisc()
>

>
>                              Access privileges
>   Schema |   Name   | Type  | Access privileges | Column access
> privileges
> --------+----------+-------+-------------------+--------------------------
>   public | credmisc | table | fpm=ardxt/fpm    +|
>          |          |       | bioeng=r/fpm      |
>


Could we see the permissions on the functions too?

-Andy




pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: cannot delete some records [9.3]
Next
From: Frank Miles
Date:
Subject: Re: cannot delete some records [9.3]