Help, I dropped a system datatype, and now I'm .... - Mailing list 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