Thread: problems with a view

problems with a view

From
Peter Blazso
Date:
Hi all,

I have problems with SELECTing a view that I had been able to create.
The postmaster just keeps dropping the line as I'm trying to SELECT from
that view I had already defined (SQL statements/definititions attached).

I made a workaround (without using views) since I saw something about
buggy views in the new documentation and I thought I had found
something. This try was a bigger join which included everything (and did
more filtering):

SELECT subject, type
FROM students, subjects, examtypes
WHERE students.profession = subjects.profession     AND
      students.pk = myid()                          AND
      subjects.exams[ mysemester() ] = examtypes.pk AND
      examtypes.admin = 'yes';

I was glad because it worked but after a few tries the postmaster
dropped me out again... I did not give up and recreated the database but
it unfortunately it came up with the same bug.

I have a Linux (2.0.34) and Postgres 6.4.2. Please, if anyone knows
anything that I can do, share it with me! I'd be very grateful!

Thanks in advance,
Peter Blazso


Attachment