pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Large text fields in the database 2+ messages / 2 participants [nested] [flat]
* Large text fields in the database @ 2002-01-13 20:07 Aleksandar Radulovic <alex@juventus.is> 0 siblings, 1 reply; 2+ messages in thread From: Aleksandar Radulovic @ 2002-01-13 20:07 UTC (permalink / raw) To: pgsql-docs 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Large text fields in the database @ 2002-01-13 20:43 Tom Lane <tgl@sss.pgh.pa.us> parent: Aleksandar Radulovic <alex@juventus.is> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2002-01-13 20:43 UTC (permalink / raw) To: Aleksandar Radulovic <alex@juventus.is>; +Cc: pgsql-docs "Aleksandar Radulovic" <alex@juventus.is> writes: > 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 It's quite improbable that the latter has anything directly to do with the former. However, the latter does seems to suggest a version mismatch problem --- specifically, a 7.1 plpgsql.so and an older postgres backend. So I will suggest that your real problem is you have not updated all components of your PG installation to 7.1. Try "rpm -qa | grep postgres" and see if anything's out of sync. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-01-13 20:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-01-13 20:07 Large text fields in the database Aleksandar Radulovic <alex@juventus.is> 2002-01-13 20:43 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox