[GENERAL] column limit

2007-01-25 Thread Isaac Ben
Hi, I'm trying to create a table with 20,000 columns of type int2, but I keep getting the error message that the limit is 1600. According to this message http://archives.postgresql.org/pgsql-admin/2001-01/msg00199.php it can be increased, but only up to about 6400. Can anyone tell me how to get

Re: [GENERAL] column limit

2007-01-25 Thread Isaac Ben
data available in a master table to do analysis on. After the analysis I hope to derive subsets of much lower dimensionality. IB Isaac Ben Jeppsen On 1/25/07, David Brain <[EMAIL PROTECTED]> wrote: Hi, Seeing as how no one has asked this question yet - I have to ask, why do you need 20,000 c

Re: [GENERAL] column limit

2007-01-26 Thread Isaac Ben
On 1/26/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote: On Thu, Jan 25, 2007 at 10:47:50 -0700, Isaac Ben <[EMAIL PROTECTED]> wrote: > > The data is gene expression data with 20,000 dimensions. Part of the > project I'm working on is to discover what dimensions are tru

[GENERAL] column limit

2007-01-26 Thread Isaac Ben
o get 20,000 columns? Thanks, IB Isaac Ben Jeppsen ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq