Re: [ADMIN] Postgresql takes more time to update

2007-10-05 Thread Scott Marlowe
On 10/4/07, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: > > Hi Team, > > > > We are using "psql 7.4.2" version of Postgresql, these days all the > transactions on the database are taking long time to execute. We are > planning to do "ANALYZE" command on the database. Could you please advice > us, h

[ADMIN] Installing a Chained SSL Certificate

2007-10-05 Thread Craig McElroy
Is it possible to use a chained commercial SSL certificate, such as from GoDaddy, with 8.2? It works, but needs to be added to the keystore of the JVM when connecting from a JDBC based client. --- Craig A. McElroy Contegix Beyond Managed Hosting(r) for Your Enterprise

[ADMIN] Postgresql takes more time to update

2007-10-05 Thread Suresh Gupta VG
Hi Team, We are using "psql 7.4.2" version of Postgresql, these days all the transactions on the database are taking long time to execute. We are planning to do "ANALYZE" command on the database. Could you please advice us, how much time it takes and what are the conditions we need to keep on a

Re: [ADMIN] Executing external program from stored procedure

2007-10-05 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > PL/Perl runs in tainted mode, so it will prevent you from > accessing any files (which means you can relatively safely > give an access to it for ordinary users and not worry too much > about them doing system("rm -rf ."); Two minor nits: it'

Re: [ADMIN] Executing external program from stored procedure

2007-10-05 Thread Simon Riggs
On Thu, 2007-10-04 at 20:02 -0600, Benjamin Krajmalnik wrote: > Is there a way to execute an external program from within a stored > procedure? Write a Function in C -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---(end of broadcast)

Re: [ADMIN] Postgres Array Traversing Problem

2007-10-05 Thread Dawid Kuroczko
On 10/4/07, yogesh <[EMAIL PROTECTED]> wrote: > Hello Friends, > > I have a Problem in Accessing Arrays in the Postgres. > The Description of my problem is given > here:--- > I have two array of numeric types. One That stores the IDs and Other > Store their va

Re: [ADMIN] Executing external program from stored procedure

2007-10-05 Thread Dawid Kuroczko
On 10/5/07, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote: > > > Is there a way to execute an external program from within a stored > procedure? > In pl/pgsql it does not appear to be supported. > Will pl/perl allow me to do so? PL/PerlU ^ -- 'U' is for unsafe. PL/Perl runs in tainted