The following bug has been logged online: Bug reference: 5593 Logged by: Fathi Email address: fath...@yahoo.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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
