Re: [ADMIN] row size limitation

2001-01-18 Thread Lamar Owen
Jim Hines wrote: > > We too just got bit by the row size limit, having installed from the > rpms, 7.03. > > A news story wouldn't fit, and had to be drastically trimmed before it > was > accepted. > > Is there a way to reset this to say 32k, after the install, or is this > a compile > time opt

[ADMIN] row size limitation

2001-01-18 Thread Jim Hines
We too just got bit by the row size limit, having installed from the rpms, 7.03. A news story wouldn't fit, and had to be drastically trimmed before it was accepted. Is there a way to reset this to say 32k, after the install, or is this a compile time option? We've now spent lots of time rtfm

Re: [ADMIN] Row size limitation

2001-01-14 Thread R D
Hi, yes it's true, but it's not so serious. Me and many other people are working with postgreSQL and never felt this limit. So if you want to insert some large data in a row, for example picture, you should use Large Objects (See the manuals). And now the good news: the upcomming PostgreSQL 7.1

[ADMIN] Row size limitation

2001-01-14 Thread Christian Pomar
Hi, I have read that PostgreSQL has a row size limitaton to 8 or 32 Kb. Is this true? Doesn't exist any way of surpassing this limitation? Isn't that a serious limitation for a datababase?