From: | "Comunicare s(dot)a(dot)s(dot)" <accursio(dot)avona(at)comserv(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | \dt and pg_user problems |
Date: | 1999-09-30 15:31:16 |
Message-ID: | 3.0.6.32.19990930173116.00909a50@comserv.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Rissman | 1999-09-30 16:15:26 | Red Hat 6.0 / Postgresql 6.4.2 Installed / How to manage? Where are docs? |
Previous Message | Moray McConnachie | 1999-09-30 15:24:58 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |