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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: owner of data type "areas" appears to be invalid ?
Дата
Msg-id 10480.1129305853@sss.pgh.pa.us
обсуждение исходный текст
Ответ на owner of data type "areas" appears to be invalid ?  (george young <gry@ll.mit.edu>)
Ответы Re: owner of data type "areas" appears to be invalid ?  (george young <gry@ll.mit.edu>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: "Russell Simpkins"
Дата:
Сообщение: Re: Design problem : using the same primary keys for inherited objects.
Следующее
От: george young
Дата:
Сообщение: Re: owner of data type "areas" appears to be invalid ?