Re: [GENERAL] 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@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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Great Bridge ceases operations
> Does that leave Red Hat the main (only?) commercial supporter of PostgreSQL? Heh, Hardly, there is PGSQL, Inc. and Command Prompt, Inc. (my company). We have been around for almost four years and have provided custom development and support for PostgreSQL (starting with Postgres95) since that time. There are also several other companies listed on the .org site that provide support. You should check out our up-coming book, Practical PostgreSQL: http://stage.linuxports.com/projects/postgres/book1.htm J > > Not that it really needs expensive support. I'm finding that it just works. > Maybe THAT was the problem... :-) > > Best to all, > Micah ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] Encoding
For anyone who was watching me flail with JDBC and UNICODE... I finally gave up on unicode-- I switched the database encoding to MULE_INTERNAL and JDBC is handling everything I can throw at it (we'll just have to wait and see if my users manage to enter some unsupported characters). Thanks all for your help! Culley _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Does Postgresql 7.1.x Still Have 8K Maximum Field Size?
The 8k (well, BLCKSZ limit) has been eliminated for quite some time now.. -Mitch - Original Message - From: "Philip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] Does Postgresql 7.1.x Still Have 8K Maximum Field
> 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? Native in 7.1.x ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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
Re: [GENERAL] error while generating and EXECUTEing a query dynamically
Hi all, Sorry for following up to my own mail. I went over the function again and realized I was exceeding the size I had allocated for the query string. Never realised I was exceeding the varchar(1000) that I had declared as the string. Apologies for my last follow-up to my query, I sent it from the wrong id and it seems as if the text of my message got stripped out and only quoted part got through.(In fact I remember having snipped most of my original mail while sending too :( -Gaurav On Wed, Sep 12, 2001 at 11:45:16PM +0530, Gaurav Priyolkar wrote: > Hi all, > > The machine I am sending this mail from does not have postgres, but I > did this just this morning so am typing from memory: > -- Sleep: A completely inadequate substitute for caffeine. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster