test select_having FAILED
Hi all,
I have installed postgresql-7.3.3 in my RH7.3 machine,
then did regression test.
1) after login as postgres
$ source ~/.bashrc
$ initdb
$ pg_ctl -w start
$ cd /usr/local/src/postgres-7.3.3/src/test/regress
$ make all runtest
.....appear a lot of error.....
2) otherwise
$ source ~/.bashrc
$ initdb
$ postmaster -Si
$ cd /usr/local/src/postgres-7.3.3/src/test/regress
$ make all runtest
....failed only 1 test -> select_having....
It is so important this 'select_having'?
How can I fix it?
Thanks for any help!
=====
Regards,
Ardell
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Hi folks,
As 'postgres su' I have created new postgres user
$ createuser ardell
....allowed to create database? yes
....allowed to create more new users? no
CREATE USER
Than login as new user
$ su - ardell
$ createdb test
bash: createdb: command not found
Can new user 'ardell' create a db?
How fix this problem?
Many thanks!
=====
Regards,
Ardell
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
You do not have the postgres bin directory in your search path for
commands.
run ./createdb ardell this should work
HTH
Darren
On Wed, 11 Jun 2003, Ardell Dzaky wrote:
Hi folks,
As 'postgres su' I have created new postgres user
$ createuser ardell
....allowed to create database? yes
....allowed to create more new users? no
CREATE USERThan login as new user
$ su - ardell
$ createdb test
bash: createdb: command not foundCan new user 'ardell' create a db?
How fix this problem?
Many thanks!=====
Regards,
Ardell__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Darren Ferguson
--- darren@crystalballinc.com wrote:You do not have the postgres bin directory in your
search path for
commands.run ./createdb ardell this should work
HTH
Darren
Thanks Darren!
I think it's not bad to add this 6 lines to
/home/ardell/.bashrc ?
PATH="$PATH":/usr/local/pgsql/bin
export POSTGRES_HOME=/usr/local/pgsql
export PGLIB=$POSTGRES_HOME/lib
export PGDATA=$POSTGRES_HOME/data
export MANPATH="$MANPATH":$POSTGRES_HOME/man
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH":"$PGLIB"
Or only the first line?
=====
Regards,
Ardell
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Ardell Dzaky <ardellinux@yahoo.com> writes:
I have installed postgresql-7.3.3 in my RH7.3 machine,
then did regression test.
....failed only 1 test -> select_having....
Did you examine the exact differences?
I believe select_having is one of the tests that is prone to show
locale-specific differences in row ordering. That's not really
a bug. But if you haven't examined the diffs, there's no way to
know whether there's a more serious problem.
regards, tom lane