\dt and pg_user problems
От | Comunicare s.a.s. |
---|---|
Тема | \dt and pg_user problems |
Дата | |
Msg-id | 3.0.6.32.19990930173116.00909a50@comserv.it обсуждение исходный текст |
Список | pgsql-general |
Hi everybody, I updated my postgres V6.4.2 to V6.5.2 and i'm facing with two problems (maybe only one). First, using psql if i use the command \dt i recive the message " Couldn't find any tables ", but is i use the query SELECT * FROM tablename i can get what i need, also the command \d tablename works fine. Second, even if all users are in pg_shadow they don't appear in pg_user. I thought that initdb failed to create the rule for pg_user, so i tried to execute this ************************************************** CREATE RULE _RETpg_user AS ON SELECT TO pg_user DO INSTEAD SELECT usename, usesysid, usecreatedb, usetrace, usesuper, usecatupd, '********'::text as passwd, valuntil FROM pg_shadow; ***************************** by hand, but i recieved the following error message: view rule for pg_user must be named _RETpg_user. Is there someone who can help me to fix this? Thanks in advance. Best regards, Accursio Avona
В списке pgsql-general по дате отправления: