Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA07329 for ; Mon, 7 Dec 1998 14:23:43 -0500 (EST) (envelope-from daveh@insightdist.com) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA21073 for pgsql-interfaces@postgreSQL.org; Mon, 7 Dec 1998 14:03:39 -0500 (EST) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA37292; Mon, 7 Dec 1998 13:50:23 -0500 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA66778; Mon, 7 Dec 1998 13:47:52 -0500 Message-Id: <366C23FF.BD3C333E@insightdist.com> Date: Mon, 07 Dec 1998 13:52:48 -0500 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en Mime-Version: 1.0 To: PostgreSQL-development Cc: pgsql-interfaces Subject: Bytea(precision) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Recently, while testing the application compatibility of the ODBC driver in , we have come across a problem. Some applications, specifically MS Project, want to create tables using a bounded binary data type. (i.e. SQL_BINARY) Up to now, we have mapped ODBC's SQL_BINARY to PostgreSQL's BYTEA. The problem is that when the application tries to create the table. Example: CREATE TABLE foo (bar BYTEA(100)); PostgreSQL errors, complaining about the "(". I have created a patch, which I am now testing, to allow this syntax for BYTEA. It also, truncates to the specified precision in the same fashion as does VARCHAR while preserving its original behavior when a precision is not specified. 1. Are there any objections? 2. It is very light weight and I would like to get the patch into 6.4.1. Is this possible? (I do not know the plans for this 6.4.1)