\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.
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)
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 installAfter 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)
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)
Import Notes
Reply to msg id not found: --GUIDQIOToeBEd0hGsmwAA+AdG6Q--/G=cn/S=liu/O=tpe/PRMD=panmail/A*@MHS | Resolved by subject fallback