Guillaume Lelarge wrote:
On Mon, 2011-08-08 at 10:28 +0530, 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 al
On Mon, 2011-08-08 at 10:28 +0530, 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
Hi ,
I have version of PostgreSQL as given below:---
version
-
PostgreSQL 8.1.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.3 (SuSE Linux)
And it does't have
On 08/07/11 4:06 PM, Noel Cosgrave wrote:
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.
I haven't seen any russian here?
--
john r pierceN 37, W 122
sant
Here may be other problem.
Show us the result of EXPLAIN Analyze.
2011/8/8, Pavel Stehule :
> Hello
>
> use a functional index
>
> http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
>
> Regards
>
> Pavel Stehule
>
> 2011/8/8 - - :
>> For a table where column col has an index,
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:
http://www.postgresql.org/mailp
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 - - :
> > For a table where column col has an index, the query:
> >
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
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
Hello
use a functional index
http://www.postgresql.org/docs/8.4/interactive/indexes-expressional.html
Regards
Pavel Stehule
2011/8/8 - - :
> 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 ...
On Aug 7, 2011, at 23:24, Ondrej Ivanič 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 map&reduce paradigm). Function returns record
> (or array): (value1, value2, value
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 map&reduce paradigm). Function returns record
(or array): (value1, value2, value3)
I've tried the following:
1) create or replace function t
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 carefu
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 gc
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 to
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
documen
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
On Mon, 08 Aug 2011 05:38:02 +0800
Craig Ringer wrote:
> On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
> > On Sun, 07 Aug 2011 20:41:27 +0800
> > Craig Ringer wrote:
> >
> >> By the way, one of the reasons you're not finding much free
> >> hosting for PostgreSQL is that it takes a fair bit
On 7/08/2011 11:43 PM, Ivan Sergio Borgonovo wrote:
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringer 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 T
On Sun, 07 Aug 2011 20:41:27 +0800
Craig Ringer 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 than anything else
On Sun, Aug 7, 2011 at 4:22 PM, David Johnston 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 confidential
> 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 2:41 PM, Craig Ringer 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 from scratc
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 .
http://archives.postg
On Sun, Aug 7, 2011 at 11:22 AM, John R Pierce 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 quite similar
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 fre
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 i
On Sun, Aug 7, 2011 at 1:40 AM, David Johnston wrote:
> On Aug 6, 2011, at 18:03, Stuart McGraw 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 free, like PostgreSQL is, the
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 someo
29 matches
Mail list logo
