Обсуждение: 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 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- 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