From: | "Fathi" <fathibn(at)yahoo(dot)fr> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5593: Nested views working on same set of data on 8.1.21 but not on 8.4.4 |
Date: | 2010-08-03 07:52:14 |
Message-ID: | 201008030752.o737qE9g098104@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5593
Logged by: Fathi
Email address: fathibn(at)yahoo(dot)fr
PostgreSQL version: 8.4.4
Operating system: Linux 2.6.18-194.8.1.el5xen #1 SMP x86_64
Description: Nested views working on same set of data on 8.1.21 but
not on 8.4.4
Details:
Hello,
I have migrated a 5 years old database from 8.1.21 running on top of centos
5.5 on an i686 to 8.4.4 running on top of centos 5.5 on an x86_64
architecture.
I have some nested views and i am still able to get the results on 8.1.21
but when it comes to 8.4.4, I can get the results only from views that
references other tables but when the view references other views, I get an
empty result set.
I also noticed that a view (not nested) gives an empty result set on 8.4.4
while it gives exactly what it is expected to on 8.1.21. This is a simple
view for giving some pseudo-random data for an exam.
it's definition is as follows:
What other data should I post to get some help? There is no confidential
data on the database so I can send schema definition and data but this is a
huge amount for a web form.
From | Date | Subject | |
---|---|---|---|
Next Message | Fathi | 2010-08-03 07:53:37 | BUG #5594: Nested views working on same set of data on 8.1.21 but not on 8.4.4 |
Previous Message | Tom Lane | 2010-08-03 02:33:18 | Re: BUG #5592: list of integer undefined behaviors |