Re: Issue with circular references in VIEW
Gilles Darold <gilles.darold@dalibo.com>
From: Gilles Darold <gilles.darold@dalibo.com>
To: pgsql-hackers@postgresql.org
Date: 2017-07-24T19:43:33Z
Lists: pgsql-hackers
Le 24/07/2017 à 21:18, Tom Lane a écrit : > Gilles Darold <gilles.darold@dalibo.com> writes: >> Le 24/07/2017 à 19:19, Tom Lane a écrit : >>> ... I'm inclined to think in terms of fixing it at that level >>> rather than in pg_dump. It doesn't look like it would be hard to fix: >>> both functions ultimately call get_query_def(), it's just that one passes >>> down a tuple descriptor for the view while the other currently doesn't. >> I was thinking that this was intentional that pg_get_ruledef() returns >> the raw code typed by the user. I will fix it and send a patch following >> your explanation. > Oh, I just committed a patch. That's fine, I'm sure it is better than the one I could produce :-) Thanks for fixing this issue. -- Gilles Darold Consultant PostgreSQL http://dalibo.com - http://dalibo.org
Commits
-
Ensure that pg_get_ruledef()'s output matches pg_get_viewdef()'s.
- f579580bef50 9.5.8 landed
- f0f255a34bed 9.4.13 landed
- d9874fde89c9 9.2.22 landed
- b6d640047657 9.3.18 landed
- b4af9e3f378e 10.0 landed
- 3a07ba128581 9.6.4 landed