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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 06 December 2004 13:25 > To: [EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
