Skip site navigation (1) Skip section navigation (2)

Re: [pgadmin-support] Graphical ER Editor / Graphical Query

From: "Tim Finch, FosterFinch Ltd" <tim(at)fosterfinch(dot)co(dot)uk>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Graphical ER Editor / Graphical Query
Date: 2002-02-27 09:09:14
Message-ID: 5.1.0.14.0.20020227090743.027b3d70@mail.cix.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackerspgadmin-support
> > 2. Query Debugger. I reckon this would only be feasible as a
> > cross-development thing with the postmaster boys-and-girls.
>
>This is one of those things that will go a long way to replicating
>PostgreSQLs parser - i.e., masses of work without a huge benefit.
>
>I would suggest a system that uses the existing parser by attempting to
>execute the query, and interpreting any error messages that are returned
>followed by whatever highlighting of the dodgy syntax can be achieved.
>
>The downside of this is that if a large query is OK, then it will be
>executed. It is possible to prevent this by prepending EXPLAIN, but that
>will only work for SELECT queries.

Yes, I had rather assumed that deep in postmaster there must be decisions 
made about the syntax and semantics of a query - the issue was whether 
there was any way to hook into these decisions as postmaster is making them 
and expose them back to the pgAdmin user to interrupt, breakpoint etc. etc.

Tim.



Responses

pgadmin-hackers by date

Next:From: Tim Finch, FosterFinch LtdDate: 2002-02-27 10:20:23
Subject: Graphical ER Editor / Graphical Query Editor : First stages?
Previous:From: Tim Finch, FosterFinch LtdDate: 2002-02-27 09:07:03
Subject: Re: CVS co -c failure on pgadmin cvs server??

pgadmin-support by date

Next:From: Tim Finch, FosterFinch LtdDate: 2002-02-27 10:20:23
Subject: Graphical ER Editor / Graphical Query Editor : First stages?
Previous:From: Dave PageDate: 2002-02-27 09:03:50
Subject: Re: [pgadmin-support] Graphical ER Editor / Graphical Query Edito

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group