Re: [HACKERS] vacuum problem - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] vacuum problem
Date
Msg-id 199808270611.PAA06418@srapc451.sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] vacuum problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
>> 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@sra.co.jp

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] vacuum problem
Next
From: Andreas Zeugswetter
Date:
Subject: AW: TODO (was: Re: [HACKERS] Problem with parser)