Thread: Does Postgresql 7.1.x Still Have 8K Maximum Field Size?
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 or7.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 timea task is completed, the field may exceed 8k. I am not a person who likes to compile from tarball's because trainingnon-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 viaa 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@Netscape!http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
> The question: Is it possible to have a text field greater than 8k but only using RPMs -- not compiling and/or chainingvia a separate table (breaking something into 8k chunks)? If so, how? Native in 7.1.x
The 8k (well, BLCKSZ limit) has been eliminated for quite some time now.. -Mitch ----- Original Message ----- From: "Philip" <philj80@netscape.net> To: <pgsql-general@postgresql.org> Sent: Saturday, September 15, 2001 6:57 AM Subject: [GENERAL] Does Postgresql 7.1.x Still Have 8K Maximum Field Size? > 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@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 >
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 or7.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 timea task is completed, the field may exceed 8k. I am not a person who likes to compile from tarball's because trainingnon-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 chainingvia 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@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