Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-03 Thread Dave Page
> -Original Message- > From: Dave Page > Sent: 03 April 2003 15:02 > To: Andreas Pflug; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > >- Keith's fix for the login loop doesn't work. If you get > > your password

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-03 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 03 April 2003 14:50 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > Dave Page wrote: > > >A couple of minor issues I found

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-03 Thread Andreas Pflug
Dave Page wrote: A couple of minor issues I found: - Casts do not live in a schema. They need to live alongside languages with the database as parent. Done. - I don't see the pg_catalog schema no matter whether I have system objects on or off. I always see pg_temp_*. Done. Ordered System/Temp/st

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-03 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 14:20 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > Dave Page wrote: > > >Yup, certainly is. BTW, did you kno

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread efesar
Andreas, > >That's old code. It's been namespaced for more than a month. > > I just committed the changes that deal with that. Go ahead and update. Also there is a bit more functionality on the QueryBuilder. I'll be spending most of the day finishing up what I started. It should be mostly done b

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Andreas Pflug
Dave Page wrote: Yup, certainly is. BTW, did you know that thanks to Frank Lupo, pga2 fully supports Casts and Conversions in the schema now? OK, message understood. CAST, CONVERSION and OPERATOR CLASS are missing in pgadmin3 (yet). Any more objects of your desire? Centerfolds excepted. Regar

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Dave Page
It's rumoured that Andreas Pflug once said: > Exactly. I've seen quite a lot of querying tools, and most of them were > quite ugly and at the edge of usability. For my experience, I think > two tool windows are the easiest way to handle it, not only in > concerning coding, but also regarding use

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Andreas Pflug
Dave Page wrote: So you're saying we make the arbitrary query tools (SQL/QB) produce very fast, but read-only output, but add an 'Edit' option for tables/views, that allows editting of their contents an a purpose designed grid? That would certainly be easier to code as we would always know the bas

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Dave Page
It's rumoured that Andreas Pflug once said: > Actually, I see YAQT (yet another query tool) for editing a table. You > just pick a table (maybe view), hit "Edit" and scroll up and down in > there. It must be capable of unlimited rows, which isn't easy but can > be done (I already implemented somet

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Andreas Pflug
Dave Page wrote: That's fine with me. My major concern is that the code that drives the grid is only written once. This is likely to get quite complex once editting features are added, and I don't want to maintain 2 copies. I always want to keep the look and feel consistant. So, how about we creat

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-02 Thread Dave Page
Hi guys, > -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 01:50 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > >Here are my two cents. We put a "view" menu in BOTH our &

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread Andreas Pflug
Hi Keith, efesar wrote: The only thing that is MDI is the table/view windows, and that should remain true. I dislike MDI as well, and I wanted to avoid it. However, it was the easiest way to do what was necessary. To build clipped frames in a similar manner seems like unnecessary effort. The reas

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread efesar
> Uh, I hate MDI. You're using it at the moment to keep tables and views, > and MDI looks quite reasonable for this (actually, the first time MDI > looks good for me). I don't see how the sql input field should be > assembled into the existing query builder, unless the second notebook > page is us

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread Andreas Pflug
efesar wrote: Dave, The Query Builder is based on an MDI Parent/Child structure. The parent is a frame, so I don't think it can be bound to any other windows. So that might be a problem. We might consider going the opposite way, and I can add the icons and functionality of the query tool to the Q

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread efesar
> Keith, are you happy to look at moving the QB onto Andreas' query form, > or does that create problems/worries? Dave, The Query Builder is based on an MDI Parent/Child structure. The parent is a frame, so I don't think it can be bound to any other windows. So that might be a problem. We might

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread Dave Page
> -Original Message- > From: efesar [mailto:[EMAIL PROTECTED] > Sent: 31 March 2003 23:39 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > Dave, > > > 'scuse me!! What's wrong with pga2's output? It&#

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread Dave Page
> -Original Message- > From: efesar [mailto:[EMAIL PROTECTED] > Sent: 01 April 2003 00:05 > To: Dave Page; [EMAIL PROTECTED] > Subject: RE: [pgadmin-hackers] pgadmin3 query tools > > > > > > 1. I just got time to try this build. There is a new bug &

Re: [pgadmin-hackers] pgadmin3 query tools

2003-04-01 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 31 March 2003 23:57 > To: Dave Page; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > Hi Dave and Keith, > > my sources are as

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread Andreas Pflug
PROTECTED] Sent: 31 March 2003 19:37 To: [EMAIL PROTECTED] Subject: Re: [pgadmin-hackers] pgadmin3 query tools Sadly, I'm suffering from a complete lack of desire concerning a query builder... ;-) No problem, I just don't want 2 seperate query tools. Keith, what are your t

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread Andreas Pflug
efesar wrote: My bad. I was looking at PGA2 and I realized my mistake. Views are not structured ... Which I realize now is also true of PGA3. Are they stored that way in the database? Is there anyway we can structure them? The reason I ask is because I have some monster views and it's almost impos

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread efesar
> > 1. I just got time to try this build. There is a new bug > > where if it can't connect to the server it goes into an > > infinite loop (ok, ok, ok, ok, etc. -- for instance, if the > > server is not running). Starting the server does not help, > > you have to kill the PGA3 process. Then restar

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread efesar
Dave, > 'scuse me!! What's wrong with pga2's output? It's multiline - I take > great care to format it nicely in fact... My bad. I was looking at PGA2 and I realized my mistake. Views are not structured ... Which I realize now is also true of PGA3. Are they stored that way in the database? Is the

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread Dave Page
Hi Keith > -Original Message- > From: efesar [mailto:[EMAIL PROTECTED] > Sent: 31 March 2003 19:37 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] pgadmin3 query tools > > > > > Sadly, I'm suffering from a complete lack of desir

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread efesar
> > Sadly, I'm suffering from a complete lack of desire > > concerning a query > > builder... ;-) > > No problem, I just don't want 2 seperate query tools. > > Keith, what are your thoughts? Dave, I have a lot so I'm going to number these. 1. I just got time to try this build. There is a new bu

Re: [pgadmin-hackers] pgadmin3 query tools

2003-03-31 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 30 March 2003 23:14 > To: [EMAIL PROTECTED]; Dave Page > Subject: pgadmin3 query tools > > > Dave Page wrote: > > >Wow, looks great. Nice work. > > > >My only thought is that we now have 2 query tools, though