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.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)