Re: Reverse engineering problem on views

Hi Andreas (again!)

I haven't even looked at this one - I assume it's likely to be your
reformatting code that I never quite got my head around?

Also, to save writing another email - I notice when connecting now a
black rectangle is shown briefly. I assume this is the status message
that you added? If so, it never seems to draw properly on Windows. Dunno
about Unix.

Regards, Dave.

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> laurie(dot)burrow(at)powerconv(dot)alstom(dot)com
> Sent: 06 December 2004 13:25
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Reverse engineering problem on views
>
> Hi,
>
> I have noticed this possible bug:
>
> Using pgadmin V1.2.0 on Windows 2000 Desktop to a remote
> Windows 2000 Server Postgres V7.4.1 running on cygwin and to
> Postgres V8Beta2
>
> Created this view.
>
> CREATE OR REPLACE VIEW public.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
>
> 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.
>
> There seems to be an error caused by the reverse engineering
> adding the extra bracketting on the left join clauses. If the
> extra brackets are deleted the SQLis executed correctly.
>
> Any suggestions?
>
> Great work pgadmin, really enjoy using it.
>
> Regards
> Laurie Burrow
>
>
>
> :.________________
> CONFIDENTIALITY : This e-mail and any attachments are
> confidential and may be privileged. If you are not a named
> recipient, please notify the sender immediately and do not
> disclose the contents to another person, use it for any
> purpose or store or copy the information in any medium.
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>