Thanks Ray and Edson, I was able to finally connect. And the ODBCAD32.exe for
32 as well as 64 bit compatible was present in SYSWOW64 folder. This
ODBCAD32.exe contained the PostgreSQL driver in DNS window. Thanks for all the
inputs which helped me to figure out the driver and connection
Hello,
we are using PostgreSQL in our projects and would like to integrate PostGIS as
well.
Now PostGIS is licensed under the GPL and I wonder if we can use it in a
commercial (customer specific) project then.
The source code will not be made open source, but of course the customer will
get
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of J.V.
Sent: Friday, October 21, 2011 1:11 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to disable all pkey/fkey constraints globally
Is there a
On 20/10/2011 23:16, Henry Drexler wrote:
On Thu, Oct 20, 2011 at 5:41 PM, Raymond O'Donnell r...@iol.ie
mailto:r...@iol.ie wrote:
Are you sure about this? Try using RAISE NOTICE statements in the
function to output the value of nnlength each time it's executed.
Ray.
Hello,
I'm using a GIN index for a text column on a big table. I use it to rank
the rows, but I also need to get the term positions for each document of
a subset of documents. I assume these positions are stored in the index,
because doc says positions can be used for cover density ranking and
When I was doing the mockups in excel using mid as a substitute for postgres
substitute, I had to do -1 but that was actually not necessary as it was
shorting the values, so the corrected plpgsql has the line
nnlength := length(newnode);
instead of nnlength := length(newnode)-1;
On Fri, Oct 21,
I'm not a lawyer, cockroach, or hobbyist license enthusiast. Here's my
impression.
First, I'm sure this must come IP a lot. Have you looked for a PostGIS
licensing faq? Checked their mailing lists?
The issues with bundling MySQL were mostly around the GPL-licensed client
library, something that
So, according to your advice, I've looked at the IndexScan implementation
and here is what I came up with.
At execution time, if I find an operation expression involving a Param, the
param expression is evaluated with ExecEvalExpr (after being initted on
the fly), and then considered exactly the
Can you be more specific as to what you are looking for ? I presume
there is something between you and the connection so when you turn
autocommit on it doesn't work ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Oct 20, 2011 at 4:34 PM, S. Balch sba...@gmail.com
Hi guys,
on a test maschine from my university i'm running into a weird problem.
the issue (i attached detail info):
The running query eats more and more memory.(seen in htop) It'll start
using virtual memory and after eating up that one, too, postgres will
crash with:
Craig Ringer ring...@ringerc.id.au wrote:
On 10/21/2011 03:56 AM, Gauthier, Dave wrote:
The software system they are being forced to use gives them the ability to
send queries to a MySQL which has already been connected to. However, they
do have the authority to add things to that DB,
Good morning,
Is there a way to temporally disabled foreign key constraints something
like:
SET FOREIGN_KEY_CHECKS=0
When population is done, will set FOREIGN_KEY_CHECKS=1
Thanks a lot!
Emi
--
Emi Lu, ENCS, Concordia University, Montreal H3G 1M8
em...@encs.concordia.ca+1 514
On Fri, Oct 21, 2011 at 8:33 PM, Emi Lu em...@encs.concordia.ca wrote:
Good morning,
Is there a way to temporally disabled foreign key constraints something
like:
SET FOREIGN_KEY_CHECKS=0
When population is done, will set FOREIGN_KEY_CHECKS=1
You can disable *triggers* on a table
raghu ram raghuchenn...@gmail.com hat am 21. Oktober 2011 um 17:12
geschrieben:
On Fri, Oct 21, 2011 at 8:33 PM, Emi Luem...@encs.concordia.cawrote:
Good morning,
Is there a way to temporally disabled foreign key constraints something
like:
SET FOREIGN_KEY_CHECKS=0
Thank you first.
I believe that upate pg_class can only be done by superuser, right?
Besides, if I need the whole schema's foreign keys to be disabled and
then enabled later.
Is there a simple command could do it? Similar to mysql's set
FOREIGN_KEY_CHECKS = false/true?
Emi
On 10/21/2011
Dave,
We're just running the JVM out of memory with a large query result. By
turning off autocommit and setting a reasonable fetch size this problem goes
away. The application using this driver does have a way to set these, but
it seems to be broken.
Thanks,
Sean
On Fri, Oct 21, 2011 at 9:51
On Fri, Oct 21, 2011 at 6:10 AM, Raymond O'Donnell r...@iol.ie wrote:
Glad you got sorted. What was the problem in the end?
Ray.
apart from the solution I sent earlier I have now noticed an abberation -
and in testing I have not isolated but have a simple example.
for instance, using the
On Fri, Oct 21, 2011 at 1:02 PM, Henry Drexler alonup...@gmail.com wrote:
On Fri, Oct 21, 2011 at 6:10 AM, Raymond O'Donnell r...@iol.ie wrote:
Glad you got sorted. What was the problem in the end?
Ray.
apart from the solution I sent earlier I have now noticed an abberation -
and in
At 09:26 21/10/2011, Thomas Kellerer wrote:
Hello,
we are using PostgreSQL in our projects and would like to integrate
PostGIS as well.
Now PostGIS is licensed under the GPL and I wonder if we can use it
in a commercial (customer specific) project then.
The source code will not be made open
I realize I have sent a lot of messages on this thread so this will be the
last one unless I come up with a solution, then I will post that.
The idea behind this is to take a string and remove one character from it
successively and try to match that against any of the nodes in the query.
So for
On Fri, Oct 21, 2011 at 2:57 PM, Henry Drexler alonup...@gmail.com wrote:
I realize I have sent a lot of messages on this thread so this will be the
last one unless I come up with a solution, then I will post that.
Resolved.
Ray - thanks again for your help.
The pattern was it was only
Hi,
I'm trying to run the precomplied binaries form postgresql.org for
solaris 11 intel. The Read-me says it has been compiled on opensolaris
2010.11 which is (to the best of my knowledge snv_134). My machine is
also snv_134.
When I do ldd /usr/postgres/9.1-pgdg/bin/postgres it tells me
Hi,
I'm trying to run the precomplied binaries form postgresql.org for
solaris 11 intel. The Readme says it has been compiled on opensolaris
2010.11 which is (to the best of my knowledge snv_134). My machine is
also snv_134.
When I do ldd /usr/postgres/9.1-pgdg/bin/postgres it tells me
Hi,
Sorry for the late response on this.
On Wed, Aug 31, 2011 at 09:40, Tomas Vondra t...@fuzzy.cz wrote:
On 31 Srpen 2011, 1:07, Dan Scott wrote:
On Tue, Aug 30, 2011 at 13:52, Daniel Verite dan...@manitou-mail.org
wrote:
Dan Scott wrote:
the insert process is unable to insert new
All,
I'm adding a column in postgres 8.3 with the syntax: alter table images add
column saveState varchar(1) default '0'; It takes a good solid 20 minutes to
add this column to a table with ~ 14,000 entries. Why so long? Is there a way
to speed that up? The table has ~ 50 columns.
On 10/21/2011 09:05 PM, Martin Guether wrote:
Hi guys,
on a test maschine from my university i'm running into a weird problem.
the issue (i attached detail info):
The running query eats more and more memory.(seen in htop) It'll start
using virtual memory and after eating up that one, too,
On 10/21/2011 10:38 PM, S. Balch wrote:
Dave,
We're just running the JVM out of memory with a large query result. By
turning off autocommit and setting a reasonable fetch size this problem
goes away. The application using this driver does have a way to set
these, but it seems to be broken.
On 10/22/2011 06:45 AM, Eric Smith wrote:
All,
I'm adding a column in postgres 8.3 with the syntax: alter table images add column
saveState varchar(1) default '0'; It takes a good solid 20 minutes to add
this column to a table with ~ 14,000 entries. Why so long? Is there a way to speed
Eric Smith eric_h_sm...@mac.com writes:
I'm adding a column in postgres 8.3 with the syntax: alter table images add
column saveState varchar(1) default '0'; It takes a good solid 20 minutes
to add this column to a table with ~ 14,000 entries. Why so long? Is there
a way to speed that
29 matches
Mail list logo