pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedBYTEA and ODBC driver
4+ messages / 2 participants
[nested] [flat]
* BYTEA and ODBC driver
@ 2001-07-23 18:39 Ashley Clark <aclark@ghoti.org>
2001-07-24 04:11 ` Re: BYTEA and ODBC driver Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 4+ messages in thread
From: Ashley Clark @ 2001-07-23 18:39 UTC (permalink / raw)
To: pgsql-interfaces
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).
--
creaky halls
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BYTEA and ODBC driver
2001-07-23 18:39 BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
@ 2001-07-24 04:11 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-24 08:10 ` Re: BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
0 siblings, 1 reply; 4+ messages in thread
From: Hiroshi Inoue @ 2001-07-24 04:11 UTC (permalink / raw)
To: Ashley Clark <aclark@ghoti.org>; +Cc: pgsql-interfaces
Ashley Clark wrote:
>
> 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).
>
BYTEA type seems unavailable for your purpose.
You seem to have to use large objects.
See http://odbc.postgresql.org/ (FAQ).
regards,
Hiroshi Inoue
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BYTEA and ODBC driver
2001-07-23 18:39 BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
2001-07-24 04:11 ` Re: BYTEA and ODBC driver Hiroshi Inoue <Inoue@tpf.co.jp>
@ 2001-07-24 08:10 ` Ashley Clark <aclark@ghoti.org>
2001-07-25 00:54 ` Re: BYTEA and ODBC driver Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 1 reply; 4+ messages in thread
From: Ashley Clark @ 2001-07-24 08:10 UTC (permalink / raw)
To: pgsql-interfaces
* Hiroshi Inoue in "Re: [INTERFACES] BYTEA and ODBC driver" dated
* 2001/07/24 13:11 wrote:
> Ashley Clark wrote:
> >
> > 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).
>
> 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)?
--
hacker sally
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BYTEA and ODBC driver
2001-07-23 18:39 BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
2001-07-24 04:11 ` Re: BYTEA and ODBC driver Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-24 08:10 ` Re: BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
@ 2001-07-25 00:54 ` Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 0 replies; 4+ messages in thread
From: Hiroshi Inoue @ 2001-07-25 00:54 UTC (permalink / raw)
To: Ashley Clark <aclark@ghoti.org>; +Cc: pgsql-interfaces
Ashley Clark wrote:
>
> * Hiroshi Inoue in "Re: [INTERFACES] BYTEA and ODBC driver" dated
> * 2001/07/24 13:11 wrote:
>
> > Ashley Clark wrote:
> > >
> > > 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).
> >
> > 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?
BYTEA seems to be considered as a candidate for BLOB but
I don't see the conclusion yet. If BYTEA would be BLOB
ODBC driver should support it IMHO.
However BYTEA is inconvenient to handle now. For example
its input/output method is very ineffective.
regards,
Hiroshi Inoue
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-07-25 00:54 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-23 18:39 BYTEA and ODBC driver Ashley Clark <aclark@ghoti.org>
2001-07-24 04:11 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-07-24 08:10 ` Ashley Clark <aclark@ghoti.org>
2001-07-25 00:54 ` Hiroshi Inoue <Inoue@tpf.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox