Skip site navigation (1) Skip section navigation (2)

Re: invalid types and tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
Cc: "Sandy Spence" <axs(at)aber(dot)ac(dot)uk>, pgsql-admin(at)postgresql(dot)org
Subject: Re: invalid types and tables
Date: 2006-12-15 15:49:48
Message-ID: 9165.1166197788@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Shoaib Mir" <shoaibmir(at)gmail(dot)com> writes:
> Well I will not recommend deleting rows like this from the meta data, but if
> I will rather try using ALTER TABLE and ALTER TYPE to assign an owner for
> the missing user referenced type or table

No, just create a new user with the same usesysid as is shown as the
owner in pg_class etc.  See the SYSID option to CREATE USER.

(FWIW, more recent PG versions prevent you from dropping users that still
own objects.)

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Shoaib MirDate: 2006-12-15 16:21:57
Subject: Re: invalid types and tables
Previous:From: Tom LaneDate: 2006-12-15 15:44:34
Subject: Re: out of memory in backup and restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group