\dt Error

Started by Nonamealmost 28 years ago3 messagesgeneral
Jump to latest
#1Noname
cn.liu@tpe.panmail.com

Hi!

My previous PostgreSQL 6.3.2 (without --with-mb=EUC_TW in configure) worked fine except Chinese characters did not display correctly in Delphi 3.

Problem happens after I recompile PostgreSQL by adding --with-mb=EUC_TW
%configure --with-mb=EUC_TW
%make all
%make install

After everything is installed, both \z and \dt commands to psql always get error message:

ERROR: pg_user: Table does not exist.

The database do have tables because I created table "MyTable" and psql correctly lists column names in responds to command

\d MyTable

Is --with-mb=EUC_TW creating the problem or something else is causing me troubles?

Best Regards,

CN liu
(mailto:cn.liu@tpe.panmail.com)

#2Bruce Momjian
bruce@momjian.us
In reply to: Noname (#1)
Re: [GENERAL] \dt Error

Hi!

My previous PostgreSQL 6.3.2 (without --with-mb=EUC_TW in configure) worked fine except Chinese characters did not display correctly in Delphi 3.

Problem happens after I recompile PostgreSQL by adding --with-mb=EUC_TW
%configure --with-mb=EUC_TW
%make all
%make install

After everything is installed, both \z and \dt commands to psql always get error message:

ERROR: pg_user: Table does not exist.

This indicates that the view pg_user was not properly created by initdb,
and hence, \z and \dt do not work. Look at the initdb script, and try
and figure out why it is failing. Perhaps create the view by hand and
see what error you get.

-- 
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)
#3Noname
cn.liu@tpe.panmail.com
In reply to: Bruce Momjian (#2)
Re: [GENERAL] \dt Error

Dear Bruce,

I have fixed my pg_user problems after re-ran initdb. The problem I had was due to invalid permission for account postgre when running initdb.

Many thanks for the help.

Best Regards,

CN Liu (mailto:cn.liu@tpe.panmail.com)
--------Your message follows-------
This indicates that the view pg_user was not properly created by initdb,
and hence, \z and \dt do not work. Look at the initdb script, and try
and figure out why it is failing. Perhaps create the view by hand and
see what error you get.

-- 
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)