Re: Reverse engineering problem on views

laurie(dot)burrow(at)powerconv(dot)alstom(dot)com wrote:

> Retrieved view into SQL dialog window using copy SQL option
>
> This gave
>
> -- View: "test_view"
>
> -- DROP VIEW test_view;
>
> CREATE OR REPLACE VIEW test_view AS
> SELECT or0.actvle AS treename
> FROM gnrcitm g
> LEFT JOIN ((gnrcitmothrref g0
> JOIN other_ref r0 ON g0.idntfyrefid = r0.idntfyrefid AND
> r0.catnmeclssid::text = 'Tree Name'::text) or0) ON g.gnrcitmid =
> or0.gnrcitmid;
>
> When executed this gives ERROR: syntax error at or near ")" at character
> 273.

I can confirm this; the backend's pg_get_viewdef will give these
parentheses too much with pretty-print option=true. Quite awkward, since
this option should *suppress* additional parens...

I'll check the backend code.

Regards,
Andreas