Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9F767B5F327 for ; Tue, 12 Jul 2011 15:17:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 09746-01-8 for ; Tue, 12 Jul 2011 18:17:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mh5.mail.rice.edu (mh5.mail.rice.edu [128.42.199.32]) by mail.postgresql.org (Postfix) with ESMTP id 66FD2B5DD1D for ; Tue, 12 Jul 2011 15:11:22 -0300 (ADT) Received: from mh5.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh5.mail.rice.edu (Postfix) with ESMTP id BE43329018F; Tue, 12 Jul 2011 13:11:21 -0500 (CDT) X-Virus-Scanned: by amavis-2.6.4 at mh5.mail.rice.edu Received: from mh5.mail.rice.edu ([127.0.0.1]) by mh5.mail.rice.edu (mh5.mail.rice.edu [127.0.0.1]) (amavis, port 10024) with ESMTP id 09O5eWTQoriG; Tue, 12 Jul 2011 13:11:21 -0500 (CDT) X-SMTP-Auth: no X-SMTP-Auth: no Received: from staff-mud-56-27.rice.edu (staff-mud-56-27.rice.edu [168.7.56.27]) by mh5.mail.rice.edu (Postfix) with ESMTP id 91F3B290186; Tue, 12 Jul 2011 13:11:21 -0500 (CDT) Received: by staff-mud-56-27.rice.edu (Postfix, from userid 18612) id 7D1F3740C87; Tue, 12 Jul 2011 13:11:21 -0500 (CDT) Date: Tue, 12 Jul 2011 13:11:21 -0500 From: "ktm@rice.edu" To: Miguel Angel Conte Cc: pgsql-sql@postgresql.org Subject: Re: Max column number. Message-ID: <20110712181121.GN14305@staff-mud-56-27.rice.edu> References: <20110712175238.GJ1984@spoetnik.xs4all.nl> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-12-10) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201107/43 X-Sequence-Number: 35613 On Tue, Jul 12, 2011 at 03:08:36PM -0300, Miguel Angel Conte wrote: > Unfortunately It's an inherited data model and I can't make any change for > now... > Thanks for your answer! > > On Tue, Jul 12, 2011 at 2:52 PM, Reinoud van Leeuwen < > reinoud.v@n.leeuwen.net> wrote: > > > On Tue, Jul 12, 2011 at 02:48:26PM -0300, Miguel Angel Conte wrote: > > > > > Something like: > > > "If I'm not going to exceed the size limit, then I can add a new column" > > > > You want to add columns in your application? Are you sure you have the > > right datamodel? > > > > Reinoud > > -- Hi Reinoud, I think you will need to write a function to grovel around in the database to determine what the size of the row would be given a definition. Tedious but straight-forward. Regards, Ken