Hi Miguel, maybe you can split table to two tables with one-to-one connection. The another way is to create dynamic-attribute-tables which means to store data in columns, not in rows.
On Tue, Jul 12, 2011 at 7:48 PM, Miguel Angel Conte <diaf...@gmail.com>wrote: > Hi, > > I'm using postgresql 9 and I'd like to know if there is a way to "ask" if > when I'm going to add a column, I'm exceeding the max number of columns. > I've found that the max number of columns is 1600 and It's depends of the > data types. > I've made a test adding 1600 columns using different data types and I > didn't have any problem. The problem was when I tried to insert data. > > ERROR: row is too big: size 8168, maximum size 8160 > > I know that the row limit size is 8k by default, but I need a way to > prevent this exception. > > For example, my table have 600 columns and I insert a row with values for > each column and the row size is 8000. So, in this case If I want to prevent > errors, I can't add more columns, but to do that I need to know about this > limit situation. > Something like: > "If I'm not going to exceed the size limit, then I can add a new column" > > Thanks in advance, > Miguel. > -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me
