Re: [SQL] postgresql multiple insert slow

2004-02-21 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Michael L. Hostbaek") would write: > I runs fine - and I get no errors - but it takes almost 25 minutes to > complete.. I tried running the script while just grabbing the rows from > the oracle database and writing to a text file - and th

Re: [SQL] Function

2004-02-21 Thread Tom Lane
"Sumita Biswas" <[EMAIL PROTECTED]> writes: > We installed postgres, but it did not install the default DB "postgres". The only DB that exists in a fresh installation is "template1". If you want to create a DB named "postgres", use the createdb script. BTW, it's bad manners to ask a new question

Re: [SQL] postgresql multiple insert slow

2004-02-21 Thread Tom Lane
"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes: > I runs fine - and I get no errors - but it takes almost 25 minutes to > complete.. I tried running the script while just grabbing the rows from > the oracle database and writing to a text file - and then it only takes > a couple of minutes .. So i

Re: [SQL] Function

2004-02-21 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Sumita Biswas , I have a postgres function that returns a boolean, I want to use this return in another function. How do I do it? Will the following code help me fetch it in a variable: select lv_flag = drop_table_if_exists(''alarmconfig'',false); drop_table_if_exists is the function which I

Re: [SQL] Function

2004-02-21 Thread V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Dear Sumita Biswas , We installed postgres, but it did not install the default DB "postgres". Default Db is template1 . I belive you are talking about user postgres -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.co