Dave et al,
* This is a temporary solution until the cache is built.
I need to get a list of operators from the database that will return only
booleans types, not integer types. This is basically a list of possible
"join" operators.
This is the query I've found works the best. Do namespaces matt
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
> 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
> 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
> > 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
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
> > 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
Dave,
Speaking of the TODO list. Can you add me into the TODO for the Query
Builder?
PS, it's nice to see new people helping out with PGA3. I know several people
who are looking forward to this tool when it's done.
-Keith
---(end of broadcast)---
/wxWindows_2.4.0/include" /i
"c:/wxWindows_2.4.0/contrib/include" /d "NDEBUG"
MIDL:
/nologo /D "NDEBUG" /mktyplib203 /o "NUL" /win32
Browse Info:
/nologo /o"Release/pgAdmin3.bsc"
Custom/Prelink/Postbuild: nothing
-Keith
> -Orig
Dave,
I thought of one other thing ... I'm using MSVC Standard ... are you using
the Pro version? Maybe there is something in global options, or some kind of
compiler optimization. Since VC standard doesn't do compiler optimizations,
it's possible that there's a bad optimization set for compilatio
Dave,
> It's a program crash, whenever a treeview item is clicked (right or
> left).
I don't have any crashes on the treeview. I would say clean everything, and
rebuild everything.
> I also have one libpq, from 29th October (7.3dev), but it crashes
> before anything in that gets called anyway.
> If you do a release build of pgAdmin III in VC++, does it crash horribly
> on your system? In previous versions of wxWindows, I found it crashed
> when leaving one particular function (for absolutely no reason that I
> could find - it was literally on the closing brace!). I tried it again
> today
> The closest we have is a function to check whether we should quote an
> identifier, so I've added this one. Not knowing what a diacritical is,
> checking for one is beyond me as well :-)
It'll be a "feature" not a bug! :)
> Anyway, I've added your patch, and also committed it and your previous
> > I'm really confused as to why it's not showing any
> > tables/views ... the function is below.
>
> It's because I had System Objects turned off, and as your definition of
> a system object is relowner > 1, it ignored all my objects which are
> owned by user postgres, id = 1!!!
>
> What you nee
Dave,
PS -- it doesn't check for "diacriticals" or non-latin marks. That's beyond
my ability at the moment.
-Keith
> letter (a-z, but also letters with diacritical marks and
> non-Latin letters)
> or an underscore (_). Subsequent characters in an identifier or
> key word can
> be letters, digit
Dave,
>From the SQL docs (1.1.1): "SQL identifiers and key words must begin with a
letter (a-z, but also letters with diacritical marks and non-Latin letters)
or an underscore (_). Subsequent characters in an identifier or key word can
be letters, digits (0-9), or underscores, although the SQL sta
> Nice work, thanks. You must have been bored :-). As you can probably
> tell I'm fairly new to C++ and still get a little confused with
> references & pointers from time to time.
Dave,
I've been programming C++ for years and I consistently have memory leaks --
especially in MFC. The really hard
Dave,
Nevermind that last patch if you haven't patched it yet.
I got seriously bored of looking at memory leaks in VCC so I went through
and patched all the memory leaks that I could find. Also, there are a couple
of updates on the Query Builder.
Here is a synopsis of changes:
* Drag/Drop func
Dave,
Here is my patch file (changes and the relevant new files) for PGAdmin3.
Basically it's all related to QueryBuilder.
-k
www.fearstudios.com
www.efesar.com
www.efesar.com/blog
www.burque.info
=
I've stopped 6,843 spam messages. You can too!
Get your free, safe spam protection at http:
---
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 1:56 AM
To: efesar; pgadmin-hackers
Subject: RE: [pgadmin-hackers] query builder / system objects
Hi Keith,
This raises a point I'd not thought of before. In pgAdmin II we load all
object, system or not into pgSchema. We th
correction
relowner > 1 instead of >=1
// We need to know if we're going to show system objects
wxString sysobjstr;
if (!settings->GetShowSystemObjects())
sysobjstr = " AND relowner > 1 ";
-Original Message-
From: efes
dave,
pga3 question
i can tell system columns easily (and hopefully correctly):
// We need to know if we're going to show system objects
wxString sysobjstr;
if (!settings->GetShowSystemObjects())
sysobjstr = " WHERE attnum >= 0 ";
but is this an adequate
I'm surprised how easily I've slipped into wxWindows ... it's like MFC, but
a little more intuitive. Consequently, I've done a lot of work done on the
Query Builder doodad I'm building.
To progress, I need/want regular expressions ... I noticed there is a regex
library included with wxWindows (al
Okay, this is my first post so ... go easy on me.
I got PGA3 to compile (VCC6) in both Release and Debug mode. I'm using the
latest CVS for libpg ... unfortunately wxWindows 2.3.3 was not available so
I got 2.3.4 instead. Is that OK?
All my development/production databases are PG 7.2. I don't hav
24 matches
Mail list logo
