On 08/05/2011 07:32 PM, jeffrey wrote:
I have a table that looks like this:
homeidcity date measurement pre/post
123 san francisco 1/2/2003 1458 pre
123 san francisco NULL 1932 post
124 los angeles2/4/2005 938
Hello Fernando,
I was sorry to read the harsh responses your request got
here. The thing that has always appealed to me about the
free software movement is the spirit of cooperation and
mutual help that many involved exhibit.
You quite rightly point out the hypocrisy of those who
call
On Sun, Aug 7, 2011 at 1:40 AM, David Johnston pol...@yahoo.com wrote:
On Aug 6, 2011, at 18:03, Stuart McGraw smcg2...@frii.com wrote:
My point, while coming across a little harsh apparently, is that emphasis
on requiring a free service projects a certain personality.
If a good service is
John, Craig,
how do you explain the services of file hosting? By those services millions
of persons free-load pictures, videos, text, GBs of data, etc.. I think that
what I asked is quite similar, that is the use of a piece of remote hardware
where to have free software installed. The difference
On 08/07/11 1:46 AM, Fernando Pianegiani wrote:
how do you explain the services of file hosting? By those services
millions of persons free-load pictures, videos, text, GBs of data,
etc.. I think that what I asked is quite similar, that is the use of a
piece of remote hardware where to have
On Sun, Aug 7, 2011 at 11:22 AM, John R Pierce pie...@hogranch.com wrote:
On 08/07/11 1:46 AM, Fernando Pianegiani wrote:
how do you explain the services of file hosting? By those services
millions of persons free-load pictures, videos, text, GBs of data, etc.. I
think that what I asked is
On 6/08/2011 4:02 PM, Fernando Pianegiani wrote:
Hello,
do you know any FREE hosting platforms where PostgreSQL, Java SDK,
Tomcat (or other web servers) can be already found installed or where
they can be installed from scratch?
About the only hope I know of is hub.org .
On Sun, Aug 7, 2011 at 2:41 PM, Craig Ringer ring...@ringerc.id.au wrote:
On 6/08/2011 4:02 PM, Fernando Pianegiani wrote:
Hello,
do you know any FREE hosting platforms where PostgreSQL, Java SDK,
Tomcat (or other web servers) can be already found installed or where
they can be installed
this is very difficult, but it is exactly what I am doing in environments
different from this one. Even if this risks to be considered (not so
positively) as a request of charity... :-)
At that point, unless you have confidentiality requirements, why not just tell
everyone what it is you
On Sun, Aug 7, 2011 at 4:22 PM, David Johnston pol...@yahoo.com wrote:
this is very difficult, but it is exactly what I am doing in environments
different from this one. Even if this risks to be considered (not so
positively) as a request of charity... :-)
At that point, unless you have
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringer ring...@ringerc.id.au wrote:
By the way, one of the reasons you're not finding much free
hosting for PostgreSQL is that it takes a fair bit of work to run
Pg multi-tenanted. Your additional requirement for Java and Tomcat
Why should pg be harder
On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringerring...@ringerc.id.au wrote:
By the way, one of the reasons you're not finding much free
hosting for PostgreSQL is that it takes a fair bit of work to run
Pg multi-tenanted. Your additional
On Mon, 08 Aug 2011 05:38:02 +0800
Craig Ringer ring...@ringerc.id.au wrote:
On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringerring...@ringerc.id.au wrote:
By the way, one of the reasons you're not finding much free
hosting for
Fernando,
You just posted your question to multiple innappropriate mailing lists. Please
do not do that again.
--Josh Berkus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Josh,
sorry for multiple posting.
This is the description of this mailing list:
General discussion area for users. Apart from compile, acceptance test, and
bug problems, most new users will probably only be interested in this
mailing list (unless they want to contribute to development or
Hi all,
A few days ago one of our postgres (8.3.12) servers was a bit unhappy, and
someone decided to try a kill -9 on a backend process after a kill (TERM) was
ineffective. I've read many times in the past that a kill -9 can be pretty
hazardous to a postgres' health, and now it seems I get
For a table where column col has an index, the query:
SELECT ... FROM ... WHERE col = MD5('')
doesn't seem to use an index but
SELECT ... FROM ... WHERE col = 'd41d8cd98f00b204e9800998ecf8427e'
does.
Is this a gotcha?
I'm using PostgreSQL 8.4.8 on i686-pc-linux-gnu, compiled by GCC
The only time kill -9 should be a data corruption issue is if you kill the
postMASTER (not just a backend) then remove the postmaster.pid file from the
datadir and relaunch the postmaster without first making sure the worker
backends are all shut down.
You need to load the shotgun, aim it
Hi,
It is possible to pass query result (or cursor?) as function
parameter? I need a function which emits zero or more rows per input
row (map function from mapreduce paradigm). Function returns record
(or array): (value1, value2, value3)
I've tried the following:
1) create or replace function
On Aug 7, 2011, at 23:24, Ondrej Ivanič ondrej.iva...@gmail.com wrote:
Hi,
It is possible to pass query result (or cursor?) as function
parameter? I need a function which emits zero or more rows per input
row (map function from mapreduce paradigm). Function returns record
(or array):
Hello
use a functional index
http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
Regards
Pavel Stehule
2011/8/8 - - loh@hotmail.com:
For a table where column col has an index, the query:
SELECT ... FROM ... WHERE col = MD5('')
doesn't seem to use an index but
Dear all,
Today I researched on giving privileges in Postgres databases. I have 4
databases and near about 150 tables, 50-60 sequences and also some views
in it.
I want to give privileges to a new user in all these objects. I created
a function for that but don't know how to give privileges
On 08/07/11 9:58 PM, Adarsh Sharma wrote:
Dear all,
Today I researched on giving privileges in Postgres databases. I have
4 databases and near about 150 tables, 50-60 sequences and also some
views in it.
I want to give privileges to a new user in all these objects. I
created a function for
But why? The expression is not on the left side of the WHERE clause.
Hello
use a functional index
http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
Regards
Pavel Stehule
2011/8/8 - - loh@hotmail.com:
For a table where column col has an index, the
Can someone please cancel the taxation/legal spam? None of the
Russian-language posts I've read here recently have anything whatsoever
to do with Postgresql.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Here may be other problem.
Show us the result of EXPLAIN Analyze.
2011/8/8, Pavel Stehule pavel.steh...@gmail.com:
Hello
use a functional index
http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
Regards
Pavel Stehule
2011/8/8 - - loh@hotmail.com:
For a table
26 matches
Mail list logo