[BUGS] startup scripts don't function properly

2001-04-19 Thread VASQUEZ_JASON
There are 2 problems: 1.  The "su" commands for start/stop/restart/status are in the form of "su -".  This picks up the environment of the postgres user, which wipes out the environment variables that were set earlier in this script (e.g., PGDATA).  Quick solution is to remove the extra dashes.

[BUGS] locale & glibc-2.2.2

2001-04-19 Thread Pimenov Yuri
Greeting! it seems like locale support with glibc 2.2.2 is completely broken... i got huge differences then performing tests in src/test/locale/koi8-r i am running PG7.1 from cvs. PS. locale itself isn't broken for sure ---(end of broadcast)--- TI

[BUGS] BUG??, fault in POSTMASTER when using GMAKE

2001-04-19 Thread DECC
hello there,   i must say i'm a rookie at using unix, but when i was trying to install postgresql 7.1, i came up with the following problem in the POSTMASTER program section. Could you, the reader of this message, please tell me what or where i can do/go to solve this problem. This is what th

[BUGS]

2001-04-19 Thread loganathan p
hai, I have installed postgres,jsdk,jdk,apache web server on linux machine.I also set current path as per in manual. But if I run any servlet program in java the following error occurs. Unable to load the driver. pls say what is the way to correct the above error. bye logu. __

Re: [BUGS] BUG??, fault in POSTMASTER when using GMAKE

2001-04-19 Thread Tom Lane
"DECC" <[EMAIL PROTECTED]> writes: > gcc2 -O2 -pipe -m486 -Wall -Wmissing-prototypes -Wmissing-declarations -I..= > /../. > ./src/include -c postmaster.c -o postmaster.o > postmaster.c: In function `PostmasterMain': > postmaster.c:406: `optreset' undeclared (first use this function) Hm. It loo

[BUGS] RAISE concatination/variables in plpgsql

2001-04-19 Thread Henshall, Stuart - WCP
SEVERITY:Minor Anoyance In the plpgsql docs it has the following example: RAISE NOTICE ''Id number '' || key || '' not found!''; When I put a function round this statement it gives a compile error at the |. Also when fiddling if I put a variable first it complains about that variable (eg key || '

Re: [BUGS] startup scripts don't function properly

2001-04-19 Thread Lamar Owen
[EMAIL PROTECTED] wrote: > 2. (Not necessarily a problem!) Scripts default to not allow TCP/IP > connections. Adding -o "-i" to start and restart fixed this problem. > This is understandable from a security standpoint. Maybe an > environment variable could be set in the "Editable" portion of t

Re: [BUGS] RAISE concatination/variables in plpgsql

2001-04-19 Thread Tom Lane
"Henshall, Stuart - WCP" <[EMAIL PROTECTED]> writes: > In the plpgsql docs it has the following example: > RAISE NOTICE ''Id number '' || key || '' not found!''; > When I put a function round this statement it gives a compile error at the > |. > Also when fiddling if I put a variable first it com

Re: [BUGS] startup scripts don't function properly

2001-04-19 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > 1. The "su" commands for start/stop/restart/status are in the form of "su > -". This picks up the environment of the postgres user, which wipes out > the environment variables that were set earlier in this script (e.g., > PGDATA). Quick solution is to remove the ext

Re: [BUGS] BUG??, fault in POSTMASTER when using GMAKE

2001-04-19 Thread Peter Eisentraut
DECC writes: > gcc2 -O2 -pipe -m486 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../. > ./src/include -c postmaster.c -o postmaster.o > postmaster.c: In function `PostmasterMain': > postmaster.c:406: `optreset' undeclared (first use this function) > postmaster.c:406: (Each undeclared

Re: [BUGS] Re: position('' in '') returns 1 instead of 0

2001-04-19 Thread Hiroshi Inoue
Terry Carlin wrote: > > I was wrong about the locate() function in the odbc driver. Thomas > Lockhart pointed out that it mapped locate in the driver to strpos in > postgres. This tweaked a memory. What happens with the locate() odbc > function in the odbc test suite is that it calls locate wit