[ADMIN] How to install postgresql in different directory

1998-08-11 Thread cheng wah yeung
Dear All, I have to install postgresql v6.3.2 for normal usage. My professor asked me to install postgresql v6.2.1 but keep the postgresql v6.3.2 here. He said that Aolserver v2.3 only support postgresql up to v6.2.1, therefore, he have to do that. Is he right? Moreover, do you have any e

[ADMIN]substring check function

1998-08-11 Thread Jonathan H. Wheaton
ÀÌÀ±¿µ writes: > hi all! > coding a database search program on web, > i want to have that pg to find tuples including > the string that a user inputs. > how can i do? > Does Postgres supply built-in function such like strstr() > in C ? > I'm wating you. > -

[ADMIN] RE: User Authentication Problem

1998-08-11 Thread Bryan Brunton
The RPMS that I got from a Red Hat mirror appear to have been to source of the problem (at least on my non-upgraded Red Hat 5.0 machine). I compiled the source and everything works great. Thanks to all for making the DB possible. If things go well just tell me where to mail the check for one o

[ADMIN] User Authentication Problem

1998-08-11 Thread Bryan Brunton
I installed Postgres from RPMs from a RedHat site on to RH 5.0. I didn't have the latest ncurses library and I had I had to do a --force to get that to install. I have user authentication turned off with the trust parameter in pg_hba.conf. I can connect fine from the local machine with pgsql

[ADMIN] Errors in selecting pg_proc

1998-08-11 Thread Mateus Cordeiro Inssa
Hi, I applied all the patches in my postgresql 6.3.2 and now I have problems with pg_proc table. The functions still work, I can still create/drop functions, but I can't list them. Messages: innova=> select * from pg_proc; ERROR: nodeRead: Bad type 0 innova=> select * from pg_proc; NOTICE:

[ADMIN] Where can i download postgresql v6.2.1

1998-08-11 Thread Walter Cheng
Dear All, Where can i download postgresql v6.2.1? I need it because my Professor said that Aolserver v2.3 only support postgresql v6.2.1. Is he right? yours, Walter Cheng

[ADMIN] Does Aolserver Support postgres

1998-08-11 Thread Walter Cheng
Dear All, Does Aolserver support postgres v6.3.2? Where can i find the driver. Moreover, where can i download postgres v6.2.1 for slackware. Thank you for your get help. yours, Walter Cheng.

[ADMIN]substring check function

1998-08-11 Thread ÀÌÀ±¿µ
hi all! coding a database search program on web, i want to have that pg to find tuples including the string that a user inputs. how can i do? Does Postgres supply built-in function such like strstr() in C ? I'm wating you. -- Yoon