Re: problems updating table - Mailing list pgsql-general

From Stephan Szabo
Subject Re: problems updating table
Date
Msg-id 20021212133403.E11714-100000@megazone23.bigpanda.com
Whole thread Raw
In response to problems updating table  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: CLUSTER command
Next
From: Jean-Luc Lachance
Date:
Subject: Re: [PERFORM] CLUSTER command