pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHelp me please !
3+ messages / 3 participants
[nested] [flat]
* Help me please !
@ 2005-02-19 11:05 Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
0 siblings, 2 replies; 3+ messages in thread
From: Asatryan, Anahit @ 2005-02-19 11:05 UTC (permalink / raw)
To: pgsql-performance
I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY
FROM STDIN function from Java application, but it doesn't work, it
throws:
"org.postgresql.util.PSQLException: Unknown Response Type G" error.
Please help me!
Note: COPY FROM filename works properly.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Help me please !
@ 2005-02-23 08:29 Richard Huxton <dev@archonet.com>
parent: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2005-02-23 08:29 UTC (permalink / raw)
To: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>; +Cc: pgsql-performance
Asatryan, Anahit wrote:
> I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY
> FROM STDIN function from Java application, but it doesn't work, it
> throws:
>
> "org.postgresql.util.PSQLException: Unknown Response Type G" error.
I don't think that there is a "STDIN" if you are executing via JDBC. The
only workaround I know of is to create a file and copy from that, which
you already have working.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Help me please !
@ 2005-02-23 14:42 Markus Schaber <schabios@logi-track.com>
parent: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
1 sibling, 0 replies; 3+ messages in thread
From: Markus Schaber @ 2005-02-23 14:42 UTC (permalink / raw)
To: Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>; +Cc: pgsql-performance
Hi, Asatryan,
Asatryan, Anahit schrieb:
> I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY
> FROM STDIN function from Java application, but it doesn’t work, it throws:
>
> “org.postgresql.util.PSQLException: Unknown Response Type G” error.
Currently, there is no COPY support in the postgresql jdbc driver. There
were some patches enabling COPY support floating around on the
pgsql-jdbc@postgresql.org mailing list. You can search the archive and
try whether one of them fits your needs.
AFAIR, COPY support is on the TODO list, but they wait for some other
driver reworking to be finished.
You can discuss this issue on psql-jdbc list or search the archives if
you need more info.
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com
Attachments:
signature.asc (application/pgp-signature, 255B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-23 14:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-19 11:05 Help me please ! Asatryan, Anahit <Anahit.Asatryan@lycos-europe.com>
2005-02-23 08:29 ` Richard Huxton <dev@archonet.com>
2005-02-23 14:42 ` Markus Schaber <schabios@logi-track.com>
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