From: | Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> |
---|---|
To: | "Colin Price (EML)" <Colin(dot)Price(at)eml(dot)ericsson(dot)se> |
Cc: | Postgres-General <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] I can't drop view?! |
Date: | 1999-03-05 11:53:24 |
Message-ID: | 36DFC5B4.4174B1F2@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Colin,
I get the same result as you when trying to create the view the same
way you do.
The following looks as if it may work:
create view v_usertype as
select
usertype.description as usertypedescription,
useraccount.login as login
from usertype a, useraccount b
where usertype.id = useraccount.usertypeid
and b.rowstatusid = 0;
as this gives
test=> select * from pg_views where viewname like 'v_usertype';
viewname
|viewowner|definition
----------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
v_usertype|adriaan |SELECT "description" AS "usertypedescription",
"login" FROM "useraccount" "b", "usertype", "useraccount" WHERE ("id" =
"usertypeid") AND ("b"."rowstatusid" = '0'::"int4");
(1 row)
and rowstatusid is now properly qualified with b.
Hope it works for you,
Adriaan
From | Date | Subject | |
---|---|---|---|
Next Message | Byron Nikolaidis | 1999-03-05 14:28:01 | Re: [GENERAL] RV: Problems with Visual Fox |
Previous Message | Silvio Emanuel Barbosa de Macedo | 1999-03-05 10:01:08 | Re: query buffer exceed - Solution for common error |