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

From Tim Finch, FosterFinch Ltd
Subject Re: [pgadmin-support] Graphical ER Editor / Graphical Query
Date
Msg-id 5.1.0.14.0.20020227090743.027b3d70@mail.cix.co.uk
Whole thread Raw
Responses Graphical ER Editor / Graphical Query Editor : First stages?
List pgadmin-hackers
> > 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.



pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [pgadmin-support] Graphical ER Editor / Graphical Query Edito
Next
From: "Tim Finch, FosterFinch Ltd"
Date:
Subject: Re: CVS co -c failure on pgadmin cvs server??