| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
| Cc: | "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] OID 718 and Circle |
| Date: | 1999-09-01 13:26:28 |
| Message-ID: | 17540.936192388@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"G. Anthony Reina" <reina(at)nsi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-09-01 13:30:38 | Re: [HACKERS] SELECT BUG |
| Previous Message | Tom Lane | 1999-09-01 13:23:32 | Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog |