Dear murali,
We use psql for our ERP software .We found CREATE TYPE is useful in creating
new data type similar to creating domain.
For eg
CREATE TYPE date_condition (
condition_id int,
from_date date,
to_datedate);
Instead , yo
uery plan as cursor
>
> CONTEXT: PL/pgSQL function "fun_orderreport" line 30 at for over execute
> statement
>
>
>
> ** Error **
>
>
>
> ERROR: cannot open multi-query plan as cursor
>
> SQL state: 42P11
>
> Context: PL/pgSQL fu
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 psql queries, and fine tuning
> i
hai
Recently we migrated our database from 8.2.4 to 8.2.12 , went through
manuals and followed the below steps
1.pg_dumpall to take data dump of current database
2.stopped database
3.moved the pgsql to backup folder
4.downloaded 8.2.12 , configured - gmake - gmake install
5.recreated cluster dir
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?
> >thanks
>
> See pg_
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
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
