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
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
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 I need to
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
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 and
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)
-
Le 5 décembre 2011 10:04, Albe Laurenz laurenz.a...@wien.gv.at 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
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
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
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
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
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 p...@fastcrypt.com wrote:
This is the second hot_standby server that I have setup for this
particular master server.
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
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
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
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
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 for any
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 ...;
end if ;
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
a
Le 5 décembre 2011 12:16, Frank Lanitz fr...@frank.uvena.de 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
Pavel Stehule pavel.steh...@gmail.com 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
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 ring...@ringerc.id.au wrote:
On 12/05/2011 03:31 PM, Mike Christensen wrote:
That'll get slow. It'll work and is IMO better than
2011/12/5 Tom Lane t...@sss.pgh.pa.us:
Pavel Stehule pavel.steh...@gmail.com 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.
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
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.
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
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. There are
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
Bruce Momjian br...@momjian.us 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
On Mon, Dec 5, 2011 at 12:26 PM, Andy Colson a...@squeakycode.net 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,
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
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
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.
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 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?
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
36 matches
Mail list logo