Re: Anyone care about type "filename" ? - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: Anyone care about type "filename" ?
Date
Msg-id Pine.BSF.4.21.0007312308230.570-100000@thelab.hub.org
Whole thread Raw
In response to Re: Anyone care about type "filename" ?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Anyone care about type "filename" ?
List pgsql-hackers
On Mon, 31 Jul 2000, Bruce Momjian wrote:

> > I'm thinking of removing the datatype "filename", which is a fixed-size
> > array of 256 characters with no support functions other than input and
> > output converters.  Apparently it was once used in the system tables,
> > but it is so no longer AFAICT.  Since it's fixed-length, it cannot be
> > made TOASTable, which makes it substantially inferior to type "text"
> > for any purpose that I can think of.
> > 
> > Anyone using this type?
> 
> I vote for removal.

works for me too ...

curious though, but why would such a type even be used in the system
tables?  what difference does it have to a varchar(256)?



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: pg_dump + function/table hierarchy
Next
From: Philip Warner
Date:
Subject: Re: pg_dump & performance degradation