Re: cannot delete some records [9.3]

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