From: | Peter Blazso <blazso(at)deltav(dot)hu> |
---|---|
To: | "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | problems with a view |
Date: | 1999-03-19 19:07:14 |
Message-ID: | 36F2A062.704300F7@deltav.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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 | Content-Type | Size |
---|---|---|
bug.sql | application/x-unknown-content-type-sql_auto_file | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | pete collins | 1999-03-19 19:16:45 | Re: [GENERAL] trouble with sum |
Previous Message | Karl DeBisschop | 1999-03-19 18:57:53 | database-level locking |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-03-19 19:16:41 | Re: [HACKERS] Re: Developers Globe (FINAL) |
Previous Message | Bruce Momjian | 1999-03-19 19:07:07 | Re: [HACKERS] Re: Developers Globe (FINAL) |