Help, I dropped a system datatype, and now I'm ....

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Help, I dropped a system datatype, and now I'm ....
Дата
Msg-id 005d01c0cf32$a48c5ab0$230470d1@INSPIRON
обсуждение исходный текст
Ответ на Re: Re: Report Writer for PostgreSQL  (larry a price <laprice@efn.org>)
Ответы Re: Help, I dropped a system datatype, and now I'm ....  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

I inadvertantly dropped a system data type (box) and now I am getting errors

cannot find datatype oid 603 when I do some selects

I have two possible solutions; 1 of which doesn't work yet

insert back into the pg_type table the box row copied from another machine
with oid 603, which postgres doesn't allow me to do.

recreate the type and find all the references to it. Can someone tell me
where to look for all the references to it?

Thanks in advance,

Dave Cramer


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter T Mount
Дата:
Сообщение: Re: JDBC and Accents
Следующее
От: "mike"
Дата:
Сообщение: Pgsql radius authntication