Postgres Pro
Downloads
Home   >   mailing lists

Thread: lztext

lztext

From
t.ngockhoi@bpf.vnu.com
Date:


Il like lztext because it make a fast database with some big text fields. I
d'ont know why it removed in lastest release ?.
Any body can help me tu get and use it ?

Ngoc-Khoi TO.

Re: lztext

From
Tom Lane
Date:
t.ngockhoi@bpf.vnu.com writes:
> Il like lztext because it make a fast database with some big text fields. I
> d'ont know why it removed in lastest release ?.

Because you don't need it anymore.  The plain text datatype has the
same functionality now.

            regards, tom lane

Re: lztext

From
Peter Eisentraut
Date:
t.ngockhoi@bpf.vnu.com writes:

> Il like lztext because it make a fast database with some big text fields. I
> d'ont know why it removed in lastest release ?.
> Any body can help me tu get and use it ?

lztext never officially existed.  In 7.1 and later, ordinary fields can
store plenty of data.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: lztext

From
Bruce Momjian
Date:
>
>
>
> Il like lztext because it make a fast database with some big text fields. I
> d'ont know why it removed in lastest release ?.
> Any body can help me tu get and use it ?

No need to use it anymore.  TOAST is now the default and allows
unlimited length, with automatic compression.  Just use normal TEXT now.


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  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