Received: from ghoti.org (c8.cb.401f.cidr.airmail.net [64.31.203.200]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6O8Adf68870 for ; Tue, 24 Jul 2001 04:10:39 -0400 (EDT) (envelope-from aclark@ghoti.org) Received: from aclark by ghoti.org with local (Exim 3.31 #1 (Debian)) id 15OxH2-0002oj-00 for ; Tue, 24 Jul 2001 03:10:36 -0500 Date: Tue, 24 Jul 2001 03:10:36 -0500 To: Postgres Interface List Subject: Re: BYTEA and ODBC driver Message-ID: <20010724031036.A9846@ghoti.org> Mail-Followup-To: Postgres Interface List References: <20010723133931.A2422@ghoti.org> <3B5CF554.26270142@tpf.co.jp> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="HlL+5n6rz5pIUxbD" Content-Disposition: inline In-Reply-To: <3B5CF554.26270142@tpf.co.jp> User-Agent: Mutt/1.3.18i X-URL: http://ghoti.org/~aclark X-GPG-Fingerprint: 1DAB 24C1 B2C1 1A34 AAAD CD2B FC62 B304 4AE0 F2EE X-GPG-Keyid: 0x4AE0F2EE X-Operating-System: Linux ghoti 2.2.19 1 Mon Apr 30 19:26:46 CDT 2001 i586 unknown X-Operating-System-Uptime: 20:49:47 up 15 days, 1:55, 2 users, load average: 1.08, 1.02, 1.01 X-GeekCode: GCS/M d- s:-- a-- C++$ UL++++$ P+>+++ L+++ E W++ N+ o K++ w O M V-- PS+(++) PE(++) Y+ PGP++(+++) t* 5+ X+ R* tv b+ DI++ D G e* h* r++ y+ From: Ashley Clark X-Archive-Number: 200107/97 X-Sequence-Number: 1851 --HlL+5n6rz5pIUxbD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Hiroshi Inoue in "Re: [INTERFACES] BYTEA and ODBC driver" dated * 2001/07/24 13:11 wrote: > Ashley Clark wrote: > >=20 > > Shouldn't I be able to store images in a field of BYTEA type? I > > keep getting errors saying that I can't store that kind of > > information in a field of that type. I'm using the latest ODBC > > driver (7.01.0006). >=20 > BYTEA type seems unavailable for your purpose. > You seem to have to use large objects. > See http://odbc.postgresql.org/ (FAQ). Yes, I understand that using the lo type would work but what plans are there to support BYTEA in the ODBC driver? Am I wrong in thinking that TOAST was supposed to allow this kind of thing without the hacks that were recently required (lo type)? --=20 hacker sally --HlL+5n6rz5pIUxbD Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Finger aclark@ghoti.org for public key iD8DBQE7XS17/GKzBErg8u4RApkpAJ9M7KCZS3g0Sct4sFP2bDU5J3ASXwCgr66t q+zSPDQfLPNOgNrjw5zdJ6w= =S249 -----END PGP SIGNATURE----- --HlL+5n6rz5pIUxbD--