Hi everyone,
I've been trying to reduce both memory usage and runtime for a query. An
issue I have encountered is that I can drastically reduce both runtime and
memory usage by splitting up the query into two pieces and gluing them
together outside PostgreSQL. However, I'm unable to get simil
Paul,
do you know, if Postgis 1.3.6 will survive, if I install Geos 3.2 over
it? Currently, there's Geos 3.1.1 installed.
I remember, I had to downgrade Postgis/Geos to be compatible with
Postgres 8.3.9. As I "herited" the database from a 8.3.9 dump, I
needed to fit my installation before restori
Paul,
I kindly received the information about the table data (quoting here):
>It changes as it goes down the table, it's a right mixture.
ST_LineString |2 | 5398548
ST_LineString |3 | 2877681
ST_LineString |4 | 2160809
ST_LineString |
On Sat, Mar 27, 2010 at 08:17:26AM -0300, Grillo Grillo wrote:
> Hi,
>
> I need to use sscanf in a plperl function.
> How can I import the module String::Scanf into my function ?
use pl/perlu
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: dep.
Hi,
I need to use sscanf in a plperl function.
How can I import the module String::Scanf into my function ?
Thanks !
Claudio Grillo
cjgri...@gmail.com
Brazil.
Okay..then could you please suggest me what could be the correct way? So far
I have done following to meet my requirements:
*
I want users to use only stored procedures to create, alter, delete tables
in mydb schema*. ==> For this I have *revoked all permissions from mydb *schema
and stored procedu
Allan Kamau wrote:
You may also have a look at Commons DBCP from Apache software
foundation, "http://commons.apache.org/dbcp/";. I have used it for a
few projects and have had no problems.
for that matter, JDBC has its own connection pooling in java.
--
Sent via pgsql-general mailing list