[GENERAL] row is too big

2011-08-31 Thread Sim Zacks
select version() PostgreSQL 8.2.19 on i686-pc-linux-gnu, compiled by GCC gcc (Debian 4.3.2-1.1) 4.3.2 Before you jump down my throat about bad design, this is a reporting table that is generated based on what the users want to see in their rows and columns. (I'm basically generating a

Re: [GENERAL] row is too big

2011-08-31 Thread Tom Lane
Sim Zacks s...@compulab.co.il writes: The manual doesn't say exactly how much storage a numeric type uses, but it seems to me that it is taking up about 12 bytes per field. Does this make any sense? Yeah, that would be the minimum size of a nonzero numeric value in 8.2. (More recent versions