From: Bruce Momjian <pgman@candle.pha.pa.us>
To: mikeo <mikeo@spectrumtelecorp.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: remove line type?
Date: Wed, 17 May 2000 15:04:52 -0400 (EDT)
Message-ID: <200005171904.PAA02741@candle.pha.pa.us> (raw)
In-Reply-To: <3.0.1.32.20000517150907.009318c0@pop.spectrumtelecorp.com>
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@candle.pha.pa.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@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, mikeo@spectrumtelecorp.com
Subject: Re: remove line type?
In-Reply-To: <200005171904.PAA02741@candle.pha.pa.us>
References: <3.0.1.32.20000517150907.009318c0@pop.spectrumtelecorp.com> <200005171904.PAA02741@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox