[GENERAL] Experiencing problems with stored procedures

2005-06-17 Thread sathish
orrect this problem. We appreciate your early reply. Thanking You in advance Sathish Kumar.S -- Open WebMail Project (http://openwebmail.org) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] doubt in trigger

2004-06-20 Thread sathish
dear groups, how to view the trigger definition (i.e create trigger ) which has already been created in the postgres. (iam working in linux terminal). yours sincerely, SathishKumar.S ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [GENERAL] Need help returning record set from a dynamic sql query

2008-08-12 Thread Sathish Duraiswamy
, you can CREATE TABLE (ORDERSID INTEGER,ORDERDATE TIMESTAMP,COMPANYNAME TEXT,EVENTNAME CHARACTER VARYING); You can have result returning a set of records Feel free to comment on it Regrds sathish On Tue, Aug 12, 2008 at 3:08 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, >

Re: [GENERAL] Need help returning record set from a dynamic sql query

2008-08-12 Thread Sathish Duraiswamy
sathish On Tue, Aug 12, 2008 at 7:26 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > > > I have changed my procedure like below, > > > > CREATE OR REPLACE FUNCTION fun_orderreport(pmorderid integer, pmcompanyid > integer, pmeventid integer) > >

Re: [GENERAL] epqa; postgres performance optimizer support tool; opensource.

2008-11-04 Thread Sathish Duraiswamy
Sure , i 'll try with our database log Regards sathish On Tue, Nov 4, 2008 at 5:55 PM, sathiya psql <[EMAIL PROTECTED]> wrote: > Dear All, > > > Recently i have released the next version of the epqa. which is a very > useful tool for, gives input for optimizing psq

Re: [GENERAL] converting older databases

2009-03-05 Thread Sathish Duraiswamy
directory 6.restored the database with datadump It was like complete re-installation process. Can anyone explain a alternative method to upgrade a existing database thanks in advance regards sathish On Fri, Mar 6, 2009 at 12:28 AM, John R Pierce wrote: > Heine Ferreira wrote: >

Re: [GENERAL] idle users

2009-03-05 Thread Sathish Duraiswamy
Can we automate this process , maintained by postmaster itself Regards Sathish On Thu, Mar 5, 2009 at 10:01 PM, Joshua Tolley wrote: > On Thu, Mar 05, 2009 at 04:50:09AM -0800, paulo matadr wrote: > >I need to procedure to kill users in idle,anybody have this made? > >

Re: [GENERAL] converting older databases

2009-03-05 Thread Sathish Duraiswamy
Thanks for ur reply John For information , We have Novell SuSe 11.0 server ON x86_32 and we have installed from source code Regards sathish On Fri, Mar 6, 2009 at 1:46 AM, John R Pierce wrote: > Sathish Duraiswamy wrote: > >> hai >> >> Recently we migrated our datab

Re: [GENERAL] idle users

2009-03-05 Thread Sathish Duraiswamy
Thanks for your reply. Can we have script in cron jobs to do this step periodically If possible , can anyone help for cron script to do this job . Regards sathish On Fri, Mar 6, 2009 at 1:21 AM, Joshua D. Drake wrote: > On Fri, 2009-03-06 at 01:09 +0530, Sathish Duraiswamy wrote: > &g