Postgres Pro
Downloads
Home   >   mailing lists

Re: owner of data type "areas" appears to be invalid ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: owner of data type "areas" appears to be invalid ?
Date
Msg-id 10480.1129305853@sss.pgh.pa.us
Whole thread Raw
In response to owner of data type "areas" appears to be invalid ?  (george young <gry@ll.mit.edu>)
Responses Re: owner of data type "areas" appears to be invalid ?  (george young <gry@ll.mit.edu>)
List pgsql-sql
Tree view 
george young <gry@ll.mit.edu> writes:
> How can I fix this?

Re-create the owning user (which you evidently dropped), assigning it
sysid 101.

PG 8.1 will make it impossible to drop users who still own objects or
have permissions ... although that will bring its own set of gotchas ...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Russell Simpkins"
Date:
Subject: Re: Design problem : using the same primary keys for inherited objects.
Next
From: george young
Date:
Subject: Re: owner of data type "areas" appears to be invalid ?