Re: Does Postgresql 7.1.x Still Have 8K Maximum Field Size?

Hi Philip,

The version 7.1 series of PostgreSQL doesn't have the 8k limitation,
it's now limited to a maximum of 1GB per field. Version 7.1.3 is the
latest release (the recommended and most stable version), and we'll soon
be beginning beta testing of the 7.2 series (don't use this for
production projects until it's finalised).

You can download the latest RPM's of PostgreSQL for RedHat 7.1 from the
PostgreSQL ftp sites (www.postgresql.org lists the mirrors).

A direct URL is :

ftp://postgresql.wavefire.com/pub/binary/v7.1.3/RPMS/redhat-7.1/

Regards and best wishes,

Justin Clift

Philip wrote:
>
> Hello all.
>
> I will be creating one of my first web applications and would like to use Postgresql as the database on a Red Hat 6.2 or 7.1 system with Apache and either ColdFusion or PHP.
>
> Anyway, the application will have a text field where employees can update their progress on assigned tasks. By the time a task is completed, the field may exceed 8k. I am not a person who likes to compile from tarball's because training non-Linux experienced fellow system administrators to use RPMs is enough. Updates are easier as well.
>
> The question: Is it possible to have a text field greater than 8k but only using RPMs -- not compiling and/or chaining via a separate table (breaking something into 8k chunks)? If so, how?
>
> Any assistance you can provide is appreciated. Thanks.
>
> __________________________________________________________________
> Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop(at)Netscape! http://shopnow.netscape.com/
>
> Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi