Re: [HACKERS] vacuum problem

>> Looked like creating pg_user failing. So I did following command by hand:
>>
>> echo "CREATE RULE _RETpg_user AS ON SELECT TO pg_user DO INSTEAD
>> SELECT usename, usesysid, usecreate -odb, usetrace, usesuper,
>> usecatupd, '********'::text as passwd, valuntil FROM pg_shadow;" |
>> postgres -F -Q -D/usr/mgr/t-ishii/src/PostgreSQL/anonCVS/data template1
>> POSTGRES backend interactive interface
>> $Revision: 1.86 $ $Date: 1998/08/25 21:34:04 $
>> > ERROR: cannot find attribute 1 of relation pg_user
>> ERROR: cannot find attribute 1 of relation pg_user
>>
>> Removing sources and getting whole source tree doesn't help.
>> This is FreeBSD 2.2.6. I will check on different platform.
>
>That is bizarre. You are running FreeBSD, and me BSDI. Seems like they
>should behave the same.

I think so too. I don't know why.

BTW, I tried the same source on my LinuxPPC box. This time initdb ran
fine. Then I did the regression test. All of tests failed and the
error messages are quite similar. Any idea?

results/boolean.out:ERROR: cannot find attribute 1 of relation booltbl1
results/boolean.out:ERROR: cannot find attribute 1 of relation booltbl2
results/char.out:ERROR: cannot find attribute 1 of relation char_tbl
results/int2.out:ERROR: cannot find attribute 1 of relation int2_tbl
results/name.out:ERROR: cannot find attribute 1 of relation name_tbl
results/strings.out:ERROR: cannot find attribute 1 of relation char_tbl
results/strings.out:ERROR: cannot find attribute 1 of relation text_tbl
results/strings.out:ERROR: cannot find attribute 1 of relation varchar_tbl
results/text.out:ERROR: cannot find attribute 1 of relation text_tbl
results/varchar.out:ERROR: cannot find attribute 1 of relation varchar_tbl
--
Tatsuo Ishii
t-ishii(at)sra(dot)co(dot)jp