If you do it in template1 database after initdb, all new databases will
not have that type either.
> that worked!!! thanks!
>
> mikeo
>
>
> At 02:51 PM 5/17/00 -0400, Bruce Momjian wrote:
> >I guess you could remove the line type from the pg_type table and see if
> >that helps.
> >
> >> hi,
> >> we're looking at migrating from ORACLE to postgres in the
> >> very near future and we've run into a small problem. there's
> >> a data type defined "LINE". we have named one of our tables
> >> as "LINE" also and it would require a great deal of code
> >> changes to rename that table. is it possible to simply
> >> "turn off" the line type? any help is appreciated.
> >>
> >> thanks,
> >> mikeo
> >>
> >>
> >
> >
> >--
> > Bruce Momjian | http://www.op.net/~candle
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> >
>
--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026