Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA9GgOs60949 for ; Thu, 9 Nov 2000 11:42:24 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [206.169.43.130] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1117209 for pgsql-sql@postgresql.org; Thu, 09 Nov 2000 08:41:44 -0800 Message-ID: <3A0AD389.647EE03A@agliodbs.com> Date: Thu, 09 Nov 2000 08:40:41 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: Requests for Development Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/77 X-Sequence-Number: 108 Tom, Bruce, Jan, etc.: As a PGSQL developer and business customer, I wanted to make some public requests as to the development path of PGSQL. While, obviously, you will develop the functionality *you* are interested in, I thought it might be valuable to you to know what things would be most appreciated (and please, list folks, speak up). 1. Please finish 7.1, stabilize it, and release it. I am probably not the only developer with an application that is waiting for the many wonderful improvements Tom has added to 7.1, but I can't build a commercial app off the CVS source tree. The rest of these requests apply to 7.2: 2. Stored Procedure functionality, i.e. outputting a full recordset from a function (or new structure, if functions are hard to adapt) based on the last SELECT statement passed to the function. An alternative would be to develop parameterized views, which might be the easiest path. 3. Slightly more informative syntax error messages - frankly, just grabbing a little more text around the word or punctuation that triggered the error would be enormously helpful (I can't tell you the number of times I've gotten "Error at or near ')'" in a huge DDL statement. 4. Use of named in addition to ordinal variables in PL/PGSQL functions (e.g. $account_type, $period instead of $1, $2). Thanks so much for your ongoing hard work! -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small businesses fax 436-0137 and non-profit organizations. pager 338-4078 San Francisco