Re: Cannot access views

Hello Cedar,

> hmm.. I still don't completely understand. Let's say, for example, you
> have a test table "testtable" and view "testview". If I understand, from
> psql you can select * from both and it works, but going into Word
> testtable works but testview does not. Correct?
Yes - that is the problem. Using psql I can do everything I want to - what
ever I use (view or table). Using Word I can only access the table.
testview was createte by something like that:
create view testview as select * from testtable where id in (select adressid
from lists where listid = '1')
lists is a "n:m-resolve-Table" (creating n lists with m datasets from
testtable)

bye
joern