Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 61665 invoked from network); 1 Mar 2007 12:10:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Mar 2007 12:10:12 -0000 Received: (qmail 50314 invoked by uid 500); 1 Mar 2007 12:10:20 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 50298 invoked by uid 500); 1 Mar 2007 12:10:20 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 50282 invoked by uid 99); 1 Mar 2007 12:10:20 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2007 04:10:20 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Mar 2007 04:10:11 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id DDD78714207 for ; Thu, 1 Mar 2007 04:09:50 -0800 (PST) Message-ID: <7572862.1172750990905.JavaMail.jira@brutus> Date: Thu, 1 Mar 2007 04:09:50 -0800 (PST) From: "Richard Bounds (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Created: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org PostgreSQL Blob type mapping should be OID in v8 ------------------------------------------------ Key: DDLUTILS-161 URL: https://issues.apache.org/jira/browse/DDLUTILS-161 Project: DdlUtils Issue Type: Bug Components: Core - PostgreSql Environment: PostgreSQL 8.1.8 on Fedora core 6 (i386). Reporter: Richard Bounds Assigned To: Thomas Dudziak For PostgreSQL v8 JDBC drivers the blob type maps to OID, not BYTEA: from here: http://doc.postgresintl.com/jdbc/ch08.html "....To use the Large Object functionality you can use either the LargeObj= ect class provided by the PostgreSQL=E2=84=A2 JDBC driver, or by using the = getBLOB() and setBLOB() methods...."=20 When using PostgreSQL (v7 or v8) with the v7 JDBC drivers BYTEA works fine,= but with the v8 drivers you get an error message: ERROR: column "binvalue" is of type bytea but expression is of type oid --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.