Re: [BUGS] 9.3beta2 unrecognized node type in join alias vars when retrieving view definition
On 2013-07-22 13:22:21 +0200, Feike Steenbergen wrote: While testing the 9.3 beta I am unable to get the view definition for some views. Because of this I cannot use pg_dump to create a valid dump of the specified database. Any chance you can post a schema only dump from 9.2 that reproduces the problem when loaded into 9.3? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] 9.3beta2 unrecognized node type in join alias vars when retrieving view definition
the attached dump can be loaded and results in an error message when retrieving the view definitions. On Mon, Jul 22, 2013 at 2:04 PM, Feike Steenbergen feikesteenber...@gmail.com wrote: I can reproduce it with the attached dump. On Mon, Jul 22, 2013 at 1:26 PM, Andres Freund and...@2ndquadrant.com wrote: only unrecognized_node_type_bug-dump.sql Description: Binary data -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] 9.3beta2 unrecognized node type in join alias vars when retrieving view definition
Feike Steenbergen feikesteenber...@gmail.com writes: the attached dump can be loaded and results in an error message when retrieving the view definitions. Thanks for the test case. It looks like I broke this in commit 2ffa740b, as a result of believing the comment in parsenodes.h that says joinaliasvars lists can only contain Vars or COALESCE expressions :-(. Will fix. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs