Re: Reverse engineering problem on views

laurie.burrow@powerconv.alstom.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