Thank you all for your explaination.
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
Cheap and Reliable VPS Hosting: http://j.mp/arHk5e
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
possible that they have different execution times ?
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
Cheap and Reliable VPS Hosting: http://j.mp/arHk5e
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
2010/6/1 Devrim GÜNDÜZ :
> Hi,
>
> On Tue, 2010-06-01 at 06:59 +0530, Nilesh Govindarajan wrote:
>> Self compilation has the advantage of custom gcc flags like -O3 -march
>> -msse, etc. which can improve performance.
>
> I started to think that you have zero idea about
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Nope; you're wrong. Even RPM doesn't remove the data. But its always
safer to keep a backup.
--
Nil
On Tue, Jun 1, 2010 at 4:40 AM, Alan Hodgson wrote:
> On Monday 31 May 2010, Devrim Gündüz wrote:
>> On Mon, 2010-05-31 at 21:14 +0530, Nilesh Govindarajan wrote:
>> > if you install some libraries like python clients or some
>> > software depending on PgSql from t
some settings, run makepkg
and your package is created with the default clean configuration. No
/usr/local stuff.
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ories in RPM/DPKG based
OS, you will have a tough time with the dependency stuff.
ArchLinux provides a PKGBUILD already from ABS (Arch Build System)
which contains all the dependency satisfiers. It serves two purposes-
depedency satisfaction and self compilation.
--
Nilesh Govindarajan
Fac
possible, for Debian sometimes we had to wait many weeks for
> official packages.
>
> Regards
> Michal Szymanski
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-g
hdb=>
>
> Thanks,
> Jignesh
>
I don't know much about the error, but an alternative solution I see
is using Triggers. WIth triggers you can manipulate the value during
INSERT or UPDATE.
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
On Fri, May 28, 2010 at 10:13 PM, Gary Fu wrote:
> Nilesh Govindarajan wrote:
>>
>> On Tue, May 25, 2010 at 7:48 PM, Gary Fu wrote:
>>
>>>
>>> Hi,
>>>
>>> On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
>&
t (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Increase autovacuum workers. More the workers, the job will be done
parallely. Anybody with more knowledge is requested to correct me if
I'm wrong.
--
Nilesh Go
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Could you please explain a little more what you want to do actually ?
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
We
tgres seem stuck with its bad
statistics and unwilling to change them. There are many other strings
that also matches tens of thousands of rows in the table which
postgres only thinks matches 766.
Is this a bug in postgres?
--
mvh Björn
It seems like regular maintainance tasks haven't been ca
On 03/24/2010 01:14 PM, Dean Rasheed wrote:
On 24 March 2010 05:17, Nilesh Govindarajan wrote:
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajanwrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going
On 03/24/2010 12:45 AM, Dean Rasheed wrote:
On 23 March 2010 11:07, Nilesh Govindarajan wrote:
Hi,
I want to find out the userid, nodecount and comment count of the userid.
I'm going wrong somewhere.
Check my SQL Code-
select u.uid, count(n.nid) nc , count(c.cid) cc from users u left
g.
I want nc and cc in just one query. How to ?
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/23/2010 12:17 PM, Sreelatha G wrote:
Hi,
select case when name='' then null end from table;
Thanks
Sreelatha
On Tue, Mar 23, 2010 at 12:03 PM, Nilesh Govindarajan mailto:li...@itech7.com>> wrote:
On 03/23/2010 11:47 AM, John R Pierce wrote:
How to con
On 03/23/2010 11:47 AM, John R Pierce wrote:
How to convert zero length string to null ?
UPDATE yourtable SET name=NULL WHERE name='';
No I don't want to replace it in the table. Just in the query result.
--
Nilesh Govindarajan
Site & Server Administrator
www.itec
On 03/23/2010 09:47 AM, Osvaldo Kussama wrote:
2010/3/23 Nilesh Govindarajan:
Hi,
In my query, some rows have null values (length 0).
NULL or a zero lenght string?
I wish to replace them with some constant.
I think I am wrong somewhere in this query using coalesce():
select coalesce
On 03/23/2010 10:07 AM, John R Pierce wrote:
Nilesh Govindarajan wrote:
Hi,
In my query, some rows have null values (length 0).
a NULL value is not length 0, NULL is not the empty string, rather, NULL
is no value at all.
if you want to change a 0 length string to something, use a CASE or
p by n.uid order by n.uid
) t1 where u.uid = t1.userid order by nodecount;
The output is same as that of without coalesce.
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On 03/21/2010 12:23 PM, AI Rumman wrote:
Does any one use Wordpress-Mu with Postgresql?
If yes, please tell me the way.
Wordpress doesn't support Postgresql as far as I know. Drupal supports
Postgresql.
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
--
Sent
On Tue, Mar 2, 2010 at 8:26 PM, Thom Brown wrote:
> On 2 March 2010 14:49, Antonio Goméz Soto
> wrote:
> > Op 02-03-10 13:00, Thom Brown schreef:
> >>
> >> On 2 March 2010 11:46, Nilesh Govindarajan wrote:
> >>>
> >>> On Tue, Mar 2, 20
d create a role which has SELECT-only access, apply that role
> to all your tables, and assign users (other roles) as members of that
> role.
>
> Regards
>
> Thom
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your su
rent STDOUT, one of which is in another
> dimension.
>
> Please tell me what I am doing wrong.
>
> Thanks very much,
>
> John
>
>
You need to type \o without any parameters again after your job of getting
the output in the file is over and you desire output on the screen.
--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
On 02/23/2010 12:54 PM, Nilesh Govindarajan wrote:
On 02/23/2010 12:49 PM, Wang, Mary Y wrote:
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the process of restoring the databases in Postgres 8.3.8. There were
lots errors showed on the screen when I r
regularly.
--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 02/20/2010 07:12 PM, Raymond O'Donnell wrote:
On 20/02/2010 13:28, Nilesh Govindarajan wrote:
Okay here's my query -
select c.cid, c.subject, n.title from comments c, node n where c.nid =
n.nid and c.status != 0;
This is the query to check list of comments requiring admin approva
On 02/20/2010 06:54 PM, Raymond O'Donnell wrote:
On 20/02/2010 13:08, Nilesh Govindarajan wrote:
On 02/20/2010 02:32 PM, John R Pierce wrote:
Nilesh Govindarajan wrote:
How do I create a procedure using plpgsql cursors to print the output
of the query in the cursor (using for loop) ?
I
On 02/20/2010 06:51 PM, Thomas Kellerer wrote:
Nilesh Govindarajan wrote on 20.02.2010 14:08:
On 02/20/2010 02:32 PM, John R Pierce wrote:
Nilesh Govindarajan wrote:
How do I create a procedure using plpgsql cursors to print the output
of the query in the cursor (using for loop) ?
In all
On 02/20/2010 02:32 PM, John R Pierce wrote:
Nilesh Govindarajan wrote:
How do I create a procedure using plpgsql cursors to print the output
of the query in the cursor (using for loop) ?
In all docs I found, it seems to be a must to return data to the call
which is not what I want.
what is
How do I create a procedure using plpgsql cursors to print the output of
the query in the cursor (using for loop) ?
In all docs I found, it seems to be a must to return data to the call
which is not what I want.
--
Nilesh Govindarajan
Site & Server Adminstrator
www.itech7.com
--
Sent
32 matches
Mail list logo
