Received: from postur.juventus.is (postur.juventus.is [194.144.223.195]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0DKAoB49718 for ; Sun, 13 Jan 2002 15:10:51 -0500 (EST) (envelope-from alex@juventus.is) Received: (from root@localhost) by postur.juventus.is (8.11.0/8.11.0) id g0DK48K04213 for pgsql-docs@postgresql.org; Sun, 13 Jan 2002 20:04:08 GMT Received: from alexlaptop (adsl74-117.heimsnet.is [213.220.74.117]) by postur.juventus.is (8.11.0/8.11.0) with SMTP id g0DK45l04204 for ; Sun, 13 Jan 2002 20:04:05 GMT Message-ID: <001901c19c6d$f0823d00$6401a8c0@alexlaptop> From: "Aleksandar Radulovic" To: Subject: Large text fields in the database Date: Sun, 13 Jan 2002 20:07:22 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200201/14 X-Sequence-Number: 1213 I am using the RPM packaged postgreSQL server 7.1.3 which is shipped with RH 7.2. The problem I have is the size of text fields. Although in Documentation it clearly says that the DB supports text fields larger than 8Kb, I am unable to insert or update fields (and tables for that matter) with data larger than 8Kb. Whenever I try to do that, I get unresolved symbol SPI_lastoid in plpgsql.so Can anyone help me with this - several friends suggested that I should recompile the DB from source, and enable the large tuples, but I looked in the source and it clearly says it's supported in this version. Best regards, alex.