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
?
and is it 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
.
--
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
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
Facebook
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
On Tue, Jun 1, 2010 at 4:40 AM, Alan Hodgson ahodg...@simkin.ca wrote:
On Monday 31 May 2010, Devrim Gündüz dev...@gunduz.org 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
the data. But its always
safer to keep a backup.
--
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
2010/6/1 Devrim GÜNDÜZ dev...@gunduz.org:
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 building binary
On Fri, May 28, 2010 at 10:13 PM, Gary Fu g...@sigmaspace.com wrote:
Nilesh Govindarajan wrote:
On Tue, May 25, 2010 at 7:48 PM, Gary Fu gary...@sigmaspace.com wrote:
Hi,
On my mandriva linux, I don't have problem to build pgpool 2.3.3 with
postgresql 8.4.2. But when I upgraded to 8.4.4
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
://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
Website: www.itech7.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
)
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 Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
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 carried out.
VACUUM, etc.
--
Nilesh Govindarajan
EXPLAIN ANALYSE to see how each is executed.
Regards,
Dean
The second method is the best. It takes 3.311 ms to execute. The first
method suggested by you takes 5.7 ms, and the worst is my method which
takes 60ms (boo).
Thanks a lot :) :) :)
--
Nilesh Govindarajan
Site Server Administrator
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.itech7.com
--
Sent via
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 li...@itech7.com
mailto:li...@itech7.com wrote:
On 03/23/2010 11:47 AM, John R Pierce wrote:
How
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
?
--
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
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 subscription:
http
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
length string to null ?
--
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/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 via pgsql
on here may have some alternative suggestions though.
Thom
Eagerly waiting for 9.0
--
Nilesh Govindarajan
Site Server Administrator
www.itech7.com
.
Regards
Thom
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
How to create that ? I'm also interested in this as I need this for backing
up my databases.
--
Nilesh Govindarajan
Site
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 ran this command
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
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 via
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
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 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) ?
In all
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 approval and
also
32 matches
Mail list logo