[GENERAL] column limit

2007-01-26 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-26 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/26/07 13:37, Isaac Ben wrote: > 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: [snip] > > I plan on accessing the data with postgres via python and R. The

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 truly > independent. But to

Re: [GENERAL] column limit

2007-01-26 Thread Bruno Wolff III
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 truly > independent. But to start with I need to have > all of the data available in

Re: [GENERAL] column limit

2007-01-25 Thread Martijn van Oosterhout
On Thu, Jan 25, 2007 at 10:47:50AM -0700, Isaac Ben 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 truly > independent. But to start with I need to have > all of the data available in a master table to do a

Re: [GENERAL] column limit

2007-01-25 Thread Bruno Wolff III
On Thu, Jan 25, 2007 at 08:34:08 -0700, Isaac Ben <[EMAIL PROTECTED]> wrote: > 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/msg001

Re: [GENERAL] column limit

2007-01-25 Thread Isaac Ben
Hi, Sorry, I forgot to post back to the list instead of just replying individual responders. The data is gene expression data with 20,000 dimensions. Part of the project I'm working on is to discover what dimensions are truly independent. But to start with I need to have all of the data availab

Re: [GENERAL] column limit

2007-01-25 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/25/07 09:34, Isaac Ben wrote: > 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/

[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