Re: problems updating table

On Thu, 12 Dec 2002, Johnson, Shaunn wrote:

> test=> update sys_users set "username"='MARISSA' where "username"='marissa';
> ERROR: hmp_mbrhlth: Permission denied.
>
> test=> \dt hmp_mbrhlth
> List of relations
> Name | Type | Owner
> -------------+-------+-------
> hmp_mbrhlth | table | hmp
>
> [/snip error]
>
>
> I've done this before and I believe I'm using the correct
> syntax. I've even tried to get brave and do it as 'postgres'
> and I still have errors.
>
> What am I missing?

How are sys_users and hmp_mbrhlth defined? Specifically, are there
any triggers, rules or foreign keys potentially involved?