rogress
I believe this is a symptom of an old version of the jdbc driver. Perhaps
upgrading that would make this go away.
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
...
>
> I would rather not have to do that, but I do not see another way.
If you are creating a database from scratch why not create a brand new
database and drop the old one at some later point in time when no one is
connected. This has the additional benefit of the old db being availab
. Restarting tomcat
closes and reopens the connection to the database, so the query in the
procedure gets replanned to use the new index and things run smoothly.
Kris Jurka
---(end of broadcast)---
TIP 2: you can get off all lists at once with the u
ic from public";
Kris Jurka
---(end of broadcast)---
TIP 8: explain analyze is your friend
bout this is the prototype for a function is
String exec(String []). So it's type checking certainly won't be
great. It says (and means) version 0.1 and doesn't (yet) deserve all the
noise it has caused.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
all returned ERROR:
> invalid large-object descriptor: 0
This is usually a symptom of not being in a transaction. Large objects
need to be done inside a transaction. Try adding
connection.setAutoCommit(false) somewhere in your code.
Kris Jurka
---
gt; that it will be solved in native release, so UTF-8 should work as well ??
>
You may be confusing locale with encoding here. UTF-8 is an encoding not
a locale.
Kris Jurka
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
e JDBC driver does support Statement.cancel(), but the tricky part is
that you need to have access to the Statement object that issued the
original query. You can't just open a new connection and cancel another
query.
Kris Jurka
---(end of broadcast)--
h id 31.
If you had a table with an id column and 200 rows 1-200 you could do
SELECT MIN(idtab.id) FROM idtab LEFT JOIN realtab ON (idtab.id =
realtab.id AND realtab.id IS NULL)
A useful generic function would be one something like range(min,max) that
would return a set of rows so you wouldn
On Sat, 15 Nov 2003, bpalmer wrote:
> I'm trying to figure out what version of a source code I have. I know
> it's a 7.2 release, but how can I find out of it's 7.2, 7.2.3, 7.2.4,
> etc. FROM THE SOURCE CODE, not from compiling (it doesn't compile, it's
> testing code).
grep VERSION conf
implementation (which is used for the group by)
has problems dealing with large numbers of similar values.
I think in later versions of pg our own qsort is used.
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
know, I've written to the maintainer but until now I never
> received any answer from him. Is there a CVS somewhere with that project
Not that I know of.
Kris Jurka
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
C driver developers as the postgresql
JDBC driver is a Type IV (pure java) driver.
Is this factor of 3 difference in time the difference from running psql
over unix sockets vs tcp, or is it the difference between a Java client
and psql? If it's the latter you'r
o grab
some data off disk and shovel it out over HTTP, consider how much more
work a database must do.
http://www.kegel.com/c10k.html
Kris Jurka
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
101 - 114 of 114 matches
Mail list logo