Re: [pgadmin-support] Reverse engineering problem on views

2004-12-10 Thread Andreas Pflug
[EMAIL PROTECTED] 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 =

Re: [pgadmin-support] Reverse engineering problem on views

2004-12-10 Thread Andreas Pflug
Dave Page wrote: 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? Still waiting for review in my mailbox. Also, to save writing another email - I notice when connecting now a black rectangle is shown bri

Re: [pgadmin-support] Reverse engineering problem on views

2004-12-10 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 December 2004 10:44 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Reverse engineering problem on views > > > Displays correctly on

Re: [pgadmin-support] Reverse engineering problem on views

2004-12-10 Thread Dave Page
ject: [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 > > Creat

[pgadmin-support] Reverse engineering problem on views

2004-12-06 Thread laurie . burrow
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 JOI