On 10 January 2012 06:57, Radosław Smogura wrote:
> In real world BLOBs are transfered as references, and those references are
> managed in way as the trigger does. Nacked PG doesn't support deletion, Oid is
> universal type so it can't be used by GC approach, unles collector will know
> which Oi
On 10 January 2012 00:29, Oliver Jowett wrote:
> So I'm still confused about what you'd like to see changed in the JDBC
> driver. Can you explain?
Perhaps what you're looking for here is "it all just works out of the
box". In that case, the missing piece seems to
On 10 January 2012 00:06, Stefan Keller wrote:
> 2012/1/9 Oliver Jowett :
>> Otherwise, what should JDBC do differently here? Be specific. It would
>
> First, I pretty sure that Hibernate nor the Tomcat/Java GC are
> misconfigured - since it works now after having installed the
On 9 January 2012 14:29, Stefan Keller wrote:
> 2012/1/9 Oliver Jowett :
>> As a LO is independent storage that might have multiple references to> it
>> (the OID might be stored in many places), without explicit deletion> you
>> need a GC mechanism to collect
On 9 January 2012 12:40, Stefan Keller wrote:
> There's an important principle that the code which "allocates"
> resources is also responsible to release it.
That's one resource allocation model, yes. The other common model is
that resources are freed when there are no remaining references to
th
Albretch Mueller wrote:
On Tue, Jun 3, 2008 at 11:03 PM, Oliver Jowett <[EMAIL PROTECTED]> wrote:
That's essentially the same as the COPY you quoted in your original email,
isn't it? So.. what exactly is it you want to do that COPY doesn't do?
~
well, actually, not exact
surabhi.ahuja wrote:
hi,
dont such messages get logged to postgreslog.
You might see something in the backend logs -- "unexpected client EOF"
perhaps? Or just idle backend processes. It depends on exactly what is
going wrong, and the timing of it.
Also, is it possible to check wht firewall
surabhi.ahuja wrote:
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
Caused by: java.net.SocketException: Broken pipe
This is a network error that the driver can't do anything about. If you
have a stateful firewall between the client and the server, pe
Bernard wrote:
Certainly supporting COPY via STDIN within the java code seems preferable.
Why do you say that? That option does not exist because the Postgresql
JDBC driver does not support it.
If you raise this on pgsql-jdbc (so far, I haven't seen anything on that
list from you at all..)
Greg Stark wrote:
Oliver Jowett <[EMAIL PROTECTED]> writes:
Bernard was also objecting to the overhead of pushing the data down a
TCP pipe when it's already available locally, I think.. I didn't find
any real difference there when I compared the two methods, though.
What
Tom Lane wrote:
> Oliver Jowett <[EMAIL PROTECTED]> writes:
>
>>It sounds like what you really want is the ability to grant something
>>like FILE access without granting all superuser rights? Sounds like a
>>feature request, not a bug, to me :-)
>
>
> AFA
Tom Lane wrote:
> What is the story on JDBC COPY support, anyway? I'm aware that there's
> an unofficial patch for that, but I'm not clear about why it's not made
> it into the accepted version.
I didn't like the whole "here is an undifferentiated stream of data"
approach -- there were some JDBC
Bernard wrote:
> 2) Split up security risk calculations between the two directions "TO"
> and "FROM" and relax security. Look at MySQL for clues. The
> application developer can manage security on file system permission
> level.
I looked at MySQL's docs briefly and its behaviour seems almost the
Bernard wrote:
> Oliver and interested list members:
[...]
And please fix your anti-spam system so it doesn't send me a "you must
jump through these hoops to send me email" message every time please!
(usual cc: to poster removed for that reason)
-O
---(end of broadcast)
Bernard wrote:
> This difference of performance is the main reason for the COPY
> command, and this is also the reason why bulk loading through the JDBC
> interface will never match the performance of the COPY fith files
> command.
In some admittedly unscientific tests I see less than 10% differe
Bernard wrote:
> The majority of JDBC users trying to bulk load tables would not want
> to send the data through their connection. This connection is designed
> to send commands and to transfer only as much data as necessary and as
> little as possible.
I don't understand why this is true at all
Bernard wrote:
> I want to follow what is suggested here. How are STDIN and STDOUT
> addressed when using the JDBC driver?
The current JDBC driver doesn't support this mode of COPY.
There was some work done in the past to support this but it never got to
the point of making it into the official
Joseph Shraibman wrote:
The column's type is 'xid' which the driver doesn't currently handle,
so it gets put into the "wrap it in PGobject" bucket.
Is xid a type of number?
It's an internal backend type; I'm not familiar with the details.
Perhaps your server should convert instances of PGob
Joseph Shraibman wrote:
Is it a jdbc bug that
is returning the answer as org.postgresql.util.PGobject instead of some
kind of Number?
The column's type is 'xid' which the driver doesn't currently handle, so
it gets put into the "wrap it in PGobject" bucket.
I'm not sure what's changed betwe
Csaba Nagy wrote:
> However, some of the queries still take the sequential scan route. The
> most puzzling in all this is that I've tried to "prepare" the same query
> in psql, and then "explain execute" the prepared query, and it gave me
> an index scan plan... so now I'm clueless, and have no id
Madison Kelly wrote:
Is there a way to store the name in raw binary?
Yes: bytea.
-O
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
J. Michael Crawford wrote:
Encoding translations that didn't work:
a) Getting encoded bytes from the result set. We tried the following
block five times, once for each different encoding we were trying to
test with the database:
b) Getting a string, turning it bytes, and then translating. Sam
22 matches
Mail list logo
