On 12/05/2011 04:55 PM, Jayashankar K B wrote:
Hi John,
Thanks for your swift reply.!
>" the only caveat is if you've linked in any GPL code, such as
readline, that can taint your whole project and require you to
distribute source code according to the GPL terms."
Does that mean, we have to dis
On 12/5/2011 12:31 PM, C. Mundi wrote:
Hello. This is my first post. As such, feedback on style and choice of
venue are especially welcome.
If I might add a personal request. Way down the road, after you get
things working, would you mind dropping by and letting us know what
happened? D
Agreed on the importance of understanding the transaction modes.
I was specifically pointing to the potential latency of blocked reads
during splitting nodes on inserting when rebalancing. But as Paul points
out, postgres does Ang/Tan splits. While less optimal than R* splits,
Ang/Tan is faster
On 12/5/2011 3:41 PM, John R Pierce wrote:
On 12/05/11 1:34 PM, C. Mundi wrote:
So that's my concern. I'm doing 80% reads which are all non-blocking
with 20% writes mixed in, and I need to avoid the effect of writes
blocking queries which do not need to traverse branches affected by
the write.
On 12/05/11 1:34 PM, C. Mundi wrote:
Thanks, Andy. You're quite right of course. I'm thinking of
concurrent clients. Lots of them. I envision thousands of actors
(which could be threads within a process or separate processes)
behaving as clients, each with its own connection to a single-thr
On 12/05/11 1:34 PM, C. Mundi wrote:
So that's my concern. I'm doing 80% reads which are all non-blocking
with 20% writes mixed in, and I need to avoid the effect of writes
blocking queries which do not need to traverse branches affected by
the write.
postgres does no blocking on inserts/up
On Mon, Dec 5, 2011 at 12:26 PM, Andy Colson wrote:
> On 12/5/2011 12:31 PM, C. Mundi wrote:
>
>>
>> Hello. This is my first post. As such, feedback on style and choice of
>> venue are especially welcome.
>>
>> I am a regular but not especially expert user of a variety of databases,
>> includin
Bruce Momjian writes:
> Andreas Kretschmer wrote:
>> is it possible to disallow "set work_mem to ..." for regular
>> (non-superuser) users?
> We have discussed it and might offer that ability some day, but
> currently there is no way to do that. There are so many ways to mess
> things up with a
On 12/5/2011 12:31 PM, C. Mundi wrote:
Hello. This is my first post. As such, feedback on style and choice of
venue are especially welcome.
I am a regular but not especially expert user of a variety of databases,
including postgreSQL.
I have only modest experience with spatial databases.
I h
Andreas Kretschmer wrote:
> Hi @list,
>
> is it possible to disallow "set work_mem to ..." for regular
> (non-superuser) users?
>
> Background: a shared database server with multiple users.
We have discussed it and might offer that ability some day, but
currently there is no way to do that. The
Hi list
I'm in the course of creating PostgreSQL packages for Solaris. One of the
requirement is to install different PostgreSQL versions in parallel, the other
is to have all the libraries stuffed in one place.
Now, if I install, let's say, pgsql 8.3 and 8.4 in parallel and all libraries
go to /
Hi @list,
is it possible to disallow "set work_mem to ..." for regular
(non-superuser) users?
Background: a shared database server with multiple users.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (
Hello. This is my first post. As such, feedback on style and choice of
venue are especially welcome.
I am a regular but not especially expert user of a variety of databases,
including postgreSQL.
I have only modest experience with spatial databases.
I have a new project[1] in which GiST could b
2011/12/5 Tom Lane :
> Pavel Stehule writes:
>> return next in function that returns composite type needs a composite
>> variable. Other cases are not supported there.
>
> Plain "return" has the same limitation, but this really ought to be
> fixed sometime. Composite types have been getting close
Currently, Npgsql doesn't support hstore datatype.
It will be sent and received as text from Npgsql.
I hope it helps.
On Mon, Dec 5, 2011 at 09:25, Craig Ringer wrote:
>
> On 12/05/2011 03:31 PM, Mike Christensen wrote:
>
> That'll get slow. It'll work and is IMO better than all the other opt
Pavel Stehule writes:
> return next in function that returns composite type needs a composite
> variable. Other cases are not supported there.
Plain "return" has the same limitation, but this really ought to be
fixed sometime. Composite types have been getting closer and closer
to first-class st
Le 5 décembre 2011 12:16, Frank Lanitz a écrit :
> Hi list,
>
> We had in past from time to time the issue, that the standby server is
> stopping recovering, creating a new timeline and become up and running.
> In parallel to check for the reasons of this behavior we are looking for
> a clean way
On Mon, Dec 05, 2011 at 12:16:29PM +0100, Frank Lanitz wrote:
> Hi list,
>
> We had in past from time to time the issue, that the standby server is
> stopping recovering, creating a new timeline and become up and running.
> In parallel to check for the reasons of this behavior we are looking for
>
On Monday, December 05, 2011 6:59:32 am Gauthier, Dave wrote:
> v8.3.4 on linux
>
> Is there a way to set the query used in a "for rec in (query) loop -> end
> loop" be a variable? Example
>
> if (foo = 'whatever')
> then
> sqlstmt := "select x,y,z ...";
> else
> sqlstmt := "select a,b,c ...
v8.3.4 on linux
Is there a way to set the query used in a "for rec in (query) loop -> end loop"
be a variable? Example
if (foo = 'whatever')
then
sqlstmt := "select x,y,z ...";
else
sqlstmt := "select a,b,c ...";
end if ;
for therec in
sqlstmt
loop
...
end loop;
Thanks in Advance f
Get a lawyer that knows this stuff.
Whilst asking around is good, if you want serious answer - you can't
count on bunch of people on the list.
Within GPL there are also variants, like LGPL, AGPL, etc. There are
some lawyers that specialize in opensource, ask them.
Most people here should have add
On Mon, Dec 05, 2011 at 08:55:08AM +, Jayashankar K B wrote:
> Does that mean, we have to distribute whole source code including our
> proprietary software source?
>
I think this was already covered, but I'll restate:
- The source code you get from the PostgreSQL site is under the
Hi John,
Thanks for your swift reply.!
>" the only caveat is if you've linked in any GPL code, such as readline, that
>can taint your whole project and require you to distribute source code
>according to the GPL terms."
Does that mean, we have to distribute whole source code including our
propr
Hi again!
I'm stuck again, now with the extension itself. I've tried like
everything I could think of filling the fields in
the example on [1]. My database is named "testdb", my table "testtable"
and the (default) schema is
(I believe) "dbo". Does anybody know the values I need to enter in the
Answering my own question
hot_standby = off by default..
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 5, 2011 at 6:43 AM, Dave Cramer wrote:
> This is the second hot_standby server that I have setup for this
> particular master server. The logs look good
This is the second hot_standby server that I have setup for this
particular master server. The logs look good
2011-12-05 06:27:36 EST user=,db= [2065] LOG: database system was
interrupted; last known up at 2011-12-05 06:16:22 EST
2011-12-05 06:27:36 EST user=,db= [2065] LOG: entering standby mod
On 12/05/11 12:55 AM, Jayashankar K B wrote:
Does that mean, we have to distribute whole source code including our
proprietary software source?
Nope. PostgreSQL is released under a BSD-like license that imposes very
few requirements. It's short and easy to read, so the best thing to do
is go r
On 12/05/2011 03:31 PM, Mike Christensen wrote:
That'll get slow. It'll work and is IMO better than all the other options
you suggested, but I'd probably favour hstore over it.
The hstore module sounds fantastic!
I'm curious as to how these columns are serialized back through the
driver, such
Hi list,
We had in past from time to time the issue, that the standby server is
stopping recovering, creating a new timeline and become up and running.
In parallel to check for the reasons of this behavior we are looking for
a clean way to check whether warm standby database is still in
recovering
Le 5 décembre 2011 10:04, Albe Laurenz a écrit :
> Mike Christensen wrote:
>> I have a database full of recipes, one recipe per row. I need to
>> store a bunch of arbitrary "flags" for each recipe to mark various
>> properties such as Gluton-Free, No meat, No Red Meat, No Pork, No
>> Animals, Qui
Do not fall too easilly into hstore :-)
while it sometimes good and extremely easy to setup, it has some drawbacks
- querying and searching has some limitations (keys/values not easily
indexable, horrible syntax)
- storage not optimised (one hstore field = several dozens of boolean
columns)
- only
Mike Christensen wrote:
> I have a database full of recipes, one recipe per row. I need to
> store a bunch of arbitrary "flags" for each recipe to mark various
> properties such as Gluton-Free, No meat, No Red Meat, No Pork, No
> Animals, Quick, Easy, Low Fat, Low Sugar, Low Calorie, Low Sodium an
On 12/05/11 12:55 AM, Jayashankar K B wrote:
Does that mean, we have to distribute whole source code including our
proprietary software source?
you're using Linux, which is GPL. you need to *CAREFULLY* read the GPL
and go over this with your lawyers. have fun. I'm not a lawyer, nor do
I pl
Florian Schwendener wrote:
> I'm stuck again, now with the extension itself. I've tried like
> everything I could think of filling the fields in
> the example on [1]. My database is named "testdb", my table
"testtable"
> and the (default) schema is
> (I believe) "dbo". Does anybody know the values
On 12/05/11 12:23 AM, Jayashankar K B wrote:
Now we have a doubt about licensing.
What is the licensing process if we want to use postgresql with our
proprietary software?
Could anyone please throw some light on this ?
very simple.
PostgreSQL Database Management System
(formerly kn
Hi,
We are planning to use Postgres 9.1 in our commercial product having a coldfire
m68k architecture based controller on Linux platform.
Since ready installer was not present for this architecture, we cross compiled
the source code and it is working fine now, though we are yet to do
Full-fledge
36 matches
Mail list logo
