Okay, I finally convinced my partner that making a table named 'circle'
and dropping the type 'circle' to compensate is just a bad idea. We're
going to rename the table 'circles' and restore the 'circle' type. Could
you give me the psql command line to restore the circle type?

Thanks.
-Tony



Tue, 31 Aug 1999 15:26:05 -0700
"G. Anthony Reina" <reina@nsi.edu>
OID 718 and Circle
"G. Anthony Reina" <reina@nsi.edu> writes:
> Okay, I finally convinced my partner that making a table named 'circle'
> and dropping the type 'circle' to compensate is just a bad idea. We're
> going to rename the table 'circles' and restore the 'circle' type. Could
> you give me the psql command line to restore the circle type?

I think you gotta rebuild the database --- if you just do a new CREATE
TYPE for circle, it won't have the right OID...

You might be able to do a COPY WITH OIDS out of template1's pg_type,
edit it down to just the line for OID 718, and then COPY WITH OIDS
to your own database's pg_type.  Not sure if that will work though.

			regards, tom lane

Wed, 01 Sep 1999 09:26:28 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] OID 718 and Circle 