Re: [ADMIN] How to change datatype of a field

2002-05-26 Thread Jyry Kuukkanen
On Sat, 25 May 2002, Rajesh Kumar Mallah. wrote: > Hi Sreedhar, > > There are no commands as such but > combination of "CREATE TABLE AS SELECT f1,f2 from TAB" > and CAST might prove useful in certain cases > > > regds > mallah. > > On Saturday 25 May 2002 12:22 pm, shreedhar wrote: > > Is there a

Re: [ADMIN] Index file size keeps on growing.....

2002-05-26 Thread Rajesh Kumar Mallah.
Hi Jean, Have you tried REINDEX? what version of postgresql is it? regds mallah. On Thursday 23 May 2002 01:10 pm, Jean-Christophe ARNU (JX) wrote: > Hi all, > I'm in front of a real problem (from my point of view). I have some tables > with a lot of update insert and delete (24/7). These

Re: [ADMIN] File systems backup problem

2002-05-26 Thread Rajesh Kumar Mallah.
Did you problem finally got resolved? regds mallah. On Thursday 23 May 2002 09:13 pm, [EMAIL PROTECTED] wrote: > Sorry for CC, > > psql -h 192.168.133.15 -l > List of available databases : > > Name | Owner > -+-- > template0 | alf > template1

[ADMIN] Problem with ucred.h building 7.2.1

2002-05-26 Thread Niclas Gustafsson
Hi, I'm having some trouble compiling 7.2.1 on one of our machines, It's a linux box running SuSE 6.0, with kernel version 2.2.14. I'm configuring with: ./configure --enable-locale --enable-multibyte=LATIN1 --with-openssl (even tried with a clean ./configure) Compiling goes fine until the hba.

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Bill Cunningham
Peter Eisentraut wrote: >Tom Lane writes: > > > >>Is there any rhyme or reason to the various "RAID n" designations? >>Or were they just invented on the spur of the moment? >> >> > >The paper that introduced the term RAID used a numerical classification >for the various schemes. (So I gues

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Ragnar Kjørstad
On Sun, May 26, 2002 at 08:00:50AM -0700, Bill Cunningham wrote: > No Raid 10 is Raid 1 + 0 its strong points are faster writes but slower > reads. RAID 10 reads will actually be faster than RAID 5, but it will require more disks. (2n instead of n+1). -- Ragnar Kjorstad Big Storage -

Re: [ADMIN] Problem with ucred.h building 7.2.1

2002-05-26 Thread Tom Lane
Niclas Gustafsson <[EMAIL PROTECTED]> writes: > I'm having some trouble compiling 7.2.1 on one of our machines, > It's a linux box running SuSE 6.0, with kernel version 2.2.14. > ... > After searching the system I see that I do not have the ucred.h > anywhere. > However I find the ucred definition

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Manuel Sugawara
Peter Eisentraut <[EMAIL PROTECTED]> writes: > There are also other levels. One poster talked about RAID 10 which > appears to be a mirrored RAID 5. Those are multi-level RAID systems: - RAID (0+1) RAID 1 (high availability) plus RAID 0 (enhaced I/O performace through striping). - RAID (3+0)

Re: [ADMIN] Problem with ucred.h building 7.2.1

2002-05-26 Thread Niclas Gustafsson
> Niclas Gustafsson <[EMAIL PROTECTED]> writes: >> I'm having some trouble compiling 7.2.1 on one of our machines, >> It's a linux box running SuSE 6.0, with kernel version 2.2.14. >> ... >> After searching the system I see that I do not have the ucred.h >> anywhere. >> However I find the ucred de

[ADMIN] Doubt in Plpgsql

2002-05-26 Thread shreedhar
Hi all,     I am sorry for putting this question in this list. Hope some body may know 'plpgsql' in postgres.     As I am practicing plpgsql I wrote the following code which is not retrieving data.   declare temprec record; funcs text; funcid integer;   begin funcs := 'success';    for temp