Re: owner of data type "areas" appears to be invalid ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gry(at)ll(dot)mit(dot)edu
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: owner of data type "areas" appears to be invalid ?
Date: 2005-10-14 16:04:13
Message-ID: 10480.1129305853@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

george young <gry(at)ll(dot)mit(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message george young 2005-10-14 16:19:21 Re: owner of data type "areas" appears to be invalid ?
Previous Message Russell Simpkins 2005-10-14 15:53:54 Re: Design problem : using the same primary keys for inherited objects.