Thread: test select_having FAILED

test select_having FAILED

From
Ardell Dzaky
Date:
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

createdb for new user?

From
Ardell Dzaky
Date:
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

Re: createdb for new user?

From
darren@crystalballinc.com
Date:
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


[.bashrc] createdb for new user?

From
Ardell Dzaky
Date:
--- 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

Re: test select_having FAILED

From
Tom Lane
Date:
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